Reports

Fields cannot be used in query parameter expressions
Hello, using SQL Reporting Services 2008. I trying to allow users to enter parameters to filter a report so I'm using stored procedures....common right. But I want a parent/child relationship between 2 datasets. The first ds pulls records based on the visible parameters entered by the user. The 2nd ds needs to u... 22 Jan 2010 17:29

Help needed to calculate % Total
Hi All, I am working on SSRS 2008. I am facing a issue where I have to % Total based on distinct group based values. Below is the table which I need to achieve. Row No Length Total % Total 1 :15 2 33.33% 2 :30 3 100% 3 :15 4 66.66% 4 :20 6 75% 5 :20 2 25% In the above table I need to calculate % Total ... 24 Jan 2010 07:54

Can you expand/collapse columns based on a reportitem/field values
I have a report that is driven by accounting periods. The columns are 1, 2, 3, Q1, 4, 5, 6, Q2...YTD. Currently when the report opens all that is shown is Q1, Q2, Q3, Q4, and YTD and the user can expand from there. What I want to happen is, if we are in Q2, I want columns 4,5,6, Q2 to be expanded. So the rep... 21 Jan 2010 15:47

Multi-level grouping drill down SSRS report
I have the following dataset: col_group col_province col_health_region col_city_region col_hospital col_total col_median col_25_percentile col_75_percentile province BC 661 65 53 75 health_region BC east 499 56 45 73 city_region BC east city_east_1 143 69 105 89 hospital BC ... 20 Jan 2010 23:03

SQL 2005 PDF Export
I am trying to create an address block in a letter generating report. I use VbCrLf to get the address lines on the correct lines. When you export to PDF from the reports intranet, it comes up as all squares. I tried replacing the VbCrLf with char(13) + char(10) and it does the same thing. I have tested this... 20 Jan 2010 21:57

How to create this grouping in ssrs?
I have a dataset with the following columns: This is a one to many relationship between the health authority to city and one to many relationship between the city and hospital column_group: health authority, city and hospital (three possible groupings for each of the row in the dataset) column_health_authori... 20 Jan 2010 02:57

How to access dataset from embedded into RDL code (urgent)
Hello, I have 2 datasets defiened in my RDL. I have a table linked to the first one. In an expression of one of the header fields I would like to lookup a value from the second data set through the following expression: =Code.GetColumnHeader("Book2") What would the GetColumnHeader() function look like in t... 19 Jan 2010 13:33

SSRS 2008 report properties code window language support
In the report properties code window, does SSRS support C# or VB only? Thanks G ... 19 Jan 2010 12:25

Multi-Parameter Stored Procedure help
stored procedure 1: exec getcolor @color = blue....this runs fine. stored procedure 2: exec getcolors @colors in('red', 'white', 'blue').........bombs code is create procedure getcolors @colors nvarchar (50) as (select * from hrs_by_activity where color in(@colors) ) need help making this wo... 19 Jan 2010 14:41

Display RTF String
You can convert the RTF to HTML format and display it on SSRS 2008 or above, see: http://pebblereports.com/ReportingServicesUtilities/ From http://www.developmentnow.com/g/115_2005_8_0_0_581541/Display-RTF-String.htm Posted via DevelopmentNow.com Groups http://www.developmentnow.com/g/ ... 18 Jan 2010 13:11