Reports

Column Alias
In the query below, I can sucessfully return different recordsets based on a parameter. The problem is that I need to change the "Month, Month_Name" and "Quarter, Quarter_Name" headers to something generic like "vDate, vDate_Name" .... Any help would be appreciated. SELECT NON EMPTY {[Measures].[Clm Amnt], ... 8 Apr 2010 15:12

FIND equivalent in an SRS Expression
I need to show/hide a line in a report depending on if more than one value is chosen in a multi-select parameter. I know how to determine if that is possible. I just look for a comma in the following formula… ="Provider Type: " & Join(Parameters!ProviderType.Value, ", ") My only issue is within SRS Expres... 8 Apr 2010 11:06

Request to IIS hangs when accessing SQL Reports
Hi, on further analysis, we identified that: Call to reportingservice2005.asmx is not comming back. the last request we have seen in IIS log file is: /Reports/reportingservice2005.asmx (At the same time we noticed DCOM errors in event log) And then no response even after 10 minutes time. Then we have to reset th... 13 Apr 2010 04:01

Anyone else notice this problem?
Whenever I add a table inside another table or delete the column the grouping creates, it takes away full page breaking functionality. It is annoying and we should have full page break functionality regardless of what is going on in the report. Is anyone else realizing this. Can one of the Microsoft guys put... 6 Apr 2010 10:49

SQL 2008 reportmanager SSL Alternate port switches to http when trying to upload file.
Hi there, We have configured SQL Server reporting service 2008 to use SSL over an alternate port. Everything is available for our customers over the internet, even report builder works great. Of course we had to apply some tricks to get the job done, but almost everything works fine. There are a few things w... 15 Apr 2010 08:05

Custom Assembly error in SSRS 2008 Options
Hi Experts, I am facing an issue with SSRS 2008. Currently I am modifying a SSRS report which will take parameters from an XML datasource. I am using sub reports on my main report and passing parameter values to sub reports from main report. Sub reports working good without any issue individually but w... 6 Apr 2010 04:15

date/time formatting
I'm trying to duplicate an Excel date/time format in Reporting Services 2005. On the Excel sheet, the difference between two dates is displayed formatted as "150:58:12" and then as "6.29". (12/1/2009 9:41:49 AM - 11/25/2009 2:43:37 AM). Is there a way to format the date/time in Reporting Services to do this... 7 Apr 2010 10:07

IIS hangs when accessing SQL Reports
Hello, we have a strange issue at customer site. We are using SQL 2005 Service pack 2 reporting services, OS is: Windows 2003 server Some times IIS/web requests hangs when accessing reports. once this is hanged, i can't event browse: http://localhost/Reports. Nothing can be done. I need to restart to start acc... 5 Apr 2010 09:24

creating a "prerequisite" parameter going to one table or the othe
Hello: I am creating a receivables aging report. The end user will choose, through a drop-down list, to run the report for periods of either "30-days" or "90-days", depending on which of these two choices he makes in that drop-down list. I know that a drop-down list will need to pull from a parameter. Now... 1 Apr 2010 13:33

SSRS 2008 get report parameters to work
I want to add report parameters to a sql server report service 2008 that has been generated by the report wizard and have the parameters work. I can get the report parametes to look like they work by doing the following: 1. select view then report data then right click parameters in the report data window. 2.... 1 Apr 2010 13:33