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
1 answer

remove duplicate rows when joining 2 tables

I have 2 tables: patient_allergens prob_person_id allergens -------------- --------- 123 NO KNOWN ALLERGIES and patient_medication med_person_id med_start_date medication_name ------------- -------------- --------------- 123 …
user6391599
  • 41
  • 3
0
votes
1 answer

subscription contains parameter values that are not valid

I have a report with begin date and end date parameters and is specifically meant for subscription that should serve 2 types of subscriptions: 1, One for previous fiscal week -->Begin date is first day of previous fiscal week and end date is last…
par
  • 1
  • 1
  • 1
0
votes
2 answers

Why would some reports using the SSRS ReportViewer Web control not render while others do?

All of the reports I have on our SSRS server work great through the SSRS ReportViewer web control but I have 2 reports that will not render. I fill out the parameters and the page refreshes with nothing. No loading gif, no toolbar, just the…
Chris
  • 838
  • 1
  • 15
  • 27
0
votes
3 answers

Hide Main report also, when sub report does not contain data - SSRS

I have one main report which shows the order details and one subreport which shows order items details. Here I passed orderno as parameter to subreport. It has multiple records group by order number. so for each order number, there are seperate set…
KaviSuja
  • 450
  • 1
  • 9
  • 37
0
votes
1 answer

ssrs/ssrb end user picks a date to filter by

I'm using sql server 2008 r2 and i'm new to building reports with ssrs. I have the reports built, but i'm trying to make it so when the end user, goes to the report on the site, they are able to pick a start and end date. So the data gets filtered…
mol
  • 73
  • 10
0
votes
1 answer

How do I aggregate more than one result into a SSRS list report

I am creating a SSRS list report based on this SQL: select name, job_id, job_title from HR name job_id job_title --------- --------- --------- Mike Jones 123 Manager Mike Jones 775 Analyst Patty Bea …
user6391599
  • 41
  • 3
0
votes
2 answers

How to get percentage for a field

I would like to get percentage for a given field value. I am achieving this in excel by using formula. Is there a way to write down formula in SSRS? I attached images here. I need this In excel i achieved by using formula, how to get this one in…
Hari
  • 192
  • 2
  • 12
0
votes
1 answer

SSRS Pie Chart Sorting

This may be a simple question for someone. Can someone show me how to sort or order the slices of pie? I can sort a bar chart no problem, but there must be something a little different with Pie Charts. I would like the amounts in order and not…
BIReportGuy
  • 799
  • 3
  • 13
  • 36
0
votes
1 answer

Need to iterate addition/subtraction with LookupSet

I have a row "A" that has a column "Qty" I have a row "B" that has a column "Needed" that is to be subtracted or added from "Qty" and placed in another column on row B "Total" The data in row B is populated using a LookupSet. So in the "Needed"…
Dom Vito
  • 507
  • 8
  • 38
0
votes
1 answer

Making a table column Date or String based on type

I'm making an SSRS Report for my accounting team and I'm hitting a wall on their custom fields requirements. I created a custom code function for this: Public Function DateOrString(ByVal s As String) As String Try Dim dt = CDate(s) …
Eman
  • 1,093
  • 2
  • 26
  • 49
0
votes
2 answers

ssrs nullable parameter is demanding a value

Building a report in VS2013. I have a parameter that needs to be able to be null. I can successfully run the report in the query builder, with a null parameter value. But if I run the report in preview or deployed, there is no NULL check box next…
BattlFrog
  • 3,370
  • 8
  • 56
  • 86
0
votes
1 answer

SSRS SQL I need to display data for dates used in the parameter and the previous month

I have an SSRS report with parameters for Created On Start and Created On End. Users run this manually and choose the date range to display records for. I need to display in two different columnns the records for the month the user entered in the…
Mon
  • 25
  • 3
0
votes
1 answer

SSRS - How can I group fields all into 1 column?

I have an SSRS report which looks something like this: I used Row Groups to get the above layout but I need to get the layout to look like the below image. So basically I need the Groups and Sub Groups to all be in 1 column. Is this possible to do…
Juan Velez
  • 741
  • 5
  • 15
  • 29
0
votes
1 answer

SSRS graph relative interval

In SSRS chart i have values like MIN value 0.10 and max value is 30000, because of these values the graph shows like: but i want the graph like : there is relative option in other reporting tool to show graph like above. How to specify relative…
Jack
  • 510
  • 3
  • 6
  • 22
0
votes
2 answers

Convert DDMMYYYY varchar value to MM-dd-yyyy in SSRS

I wanted to convert DDMMYYYY formated data (data type is varchar) to MM-dd-yyyy format using SSRS expression only. I tried the following but it is showing #Error…
Pedram
  • 6,256
  • 10
  • 65
  • 87
1 2 3
…
99 100