Stack Overflow
Stack Overflow

Questions tagged [ssrs-2008-r2]

Microsoft SQL Server 2008 R2 Reporting Services provides a server-based platform designed to support a wide variety of reporting needs enabling organizations to deliver relevant information where needed.

Microsoft SQL Server 2008 R2 Reporting Services provides a complete, server-based platform designed to support a wide variety of reporting needs enabling organizations to deliver relevant information where needed across the entire enterprise.

This is a version of Reporting Services provided by SSRS

2305 questions
0
votes
0 answers

How to make query with more than one argument in SSRS?

There is a report with a few arguments - name, surname and others. For example, we have name "Jason" and surname "Statham". In this case I have to select all who are "Jason Statham". The second case: we have name "Jason" and surname empty. Now I…
tw1ggyz
  • 23
  • 5
0
votes
1 answer

How to split multivalue parameter that is already contains comma in ssrs reports

I have a SSRS report with a multivalue parameters JobTitle. But Jobtitle itself contains ','. So, how to split this multivalue parameter? For example, I have records : Responder,supervisor,Field distributor 1,worker,Field distributor I…
Deepi
  • 11
  • 4
0
votes
1 answer

How do I stop tables inside a list from expanding the list

I have a List that contains a Table. The List is sized sufficiently that the table should be able to fit 10ish rows, which is more data than should ever come out in that table so that should be fine. My problem is that as rows are generated in the…
Dan Scally
  • 1,922
  • 1
  • 19
  • 31
0
votes
1 answer

SSRS multiple condition on textbox

I am stuck in ssrs scenario where i have to show the textbox when it is exported to excel or pdf also I have to hide that in count("dataset") = 0 Below is the expression I am using in hidden property of textbox =IIF(…
user2941762
  • 61
  • 1
  • 1
  • 9
0
votes
0 answers

how to connect report manager url in reporting service configuration manager?

I have been trying to connect a report manager to the url http:\\pc14:8080\report but it is asking username and password I don't know which one I have to enter. After giving some password randomly I see one error page on asp .net. Please help me to…
megh123
  • 11
  • 1
  • 5
0
votes
1 answer

SSRS 2008 R2 Subscribtion tab missing from report

i'm just started by using SSRS 2008 R2. When i try to subscribe my report, Subscription tab is not shown and also i'm not able to subscribe my report by right click on the report and select subscribe option. Please help me
Anupa Sankar
  • 491
  • 2
  • 7
  • 17
0
votes
2 answers

How to deploy in ssrs?

I have created report in ssrs and i want to deploy it in report server but when click on deploy button it asks username and password i don't understand which username and password it is asking i have not created any password while installing…
Megharaj Shetty
  • 43
  • 1
  • 4
0
votes
1 answer

What is the difference between Report manager URL and web service URL in ssrs 2008

What is the difference between Report manager URL and web service URL in ssrs 2008 r2?
Anupa Sankar
  • 491
  • 2
  • 7
  • 17
0
votes
0 answers

How to create connection in new server registration wizard for reporting service on ssms?

I have been trying to register new server(reporting server) on sql managment studio but i am getting error on that.Please help me how to do that .I want to deply ssrs reports using that.I am using windows authentication but test connection is…
Megharaj Shetty
  • 43
  • 1
  • 4
0
votes
2 answers

No row message for more than one tablix in SSRS

I created four tablixes for my report. if at least one tablix has no data, I would like to show 'no row message' and no data for other tablixes. Any suggestions are appreciated.
Hari
  • 192
  • 2
  • 12
0
votes
1 answer

Only show a subreport if it returns data

I have a subreport in a tablix row that I want to only show if there is data, because when the subreport doesn't return anything, i get a blank line. How can I fix this? I do not want that blank line to show.
Dom Vito
  • 507
  • 8
  • 38
0
votes
1 answer

Running subreport ONLY on max of a group

I have a subreport in a tablix that I only want to run if the row has the maximum due date of a grouping. The grouping I have is by part #. Basically, if a row has the latest due date for that part #, I want the subreport to run/show. I tried this…
Dom Vito
  • 507
  • 8
  • 38
0
votes
2 answers

SSRS - Is it possible to sort a chart on a field that is not shown

I have a horizontal bar chart with Values, Category Groups, and Series Groups. However I would like to sort on a forth field value that never actually shows in the chart. Is this possible?
David Choi
  • 6,131
  • 10
  • 28
  • 28
0
votes
0 answers

Using the Lookupset function for 3 datasets in SSRS

How can I use Lookupset function in SSRS with 3 datasets =LookupSet(Fields!Account_Number.Value,Fields!Account_Number.Value, Fields!Referral_Date_Created,"ReferralsDS") (LookupSet(Fields!Account_Number.Value,Fields!Account_Number.Value, …
user3666224
  • 71
  • 4
0
votes
0 answers

SSRS expression to pull data (today, week, month, year, total) from SP calendar

I have a report I'd like to display against my SharePoint calendar. I'd like to display a COUNT/SUM of items and entries for but having problems display correct data. Anyone able to…
Grey
  • 51
  • 2
  • 10
1 2 3
…
99 100