Reports

Group Sum, Count based on sub group information
I have a table report that shows tenant information in buildings and has two groups - Market, Building. Some of the buildings have no tenant information. I want to show at the market level - number of buildings in the market that have valid tenant information. Can I use the Count/ Scope feature to do this? Pl... 24 Jun 2008 14:23

error parsing script file C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer\CatalogTempDB.sql: 87
I'm trying to install Reporting Services Standard Edition on a Windows 2003 server running SQL Server 2000 SP4. The install is failing with the following message: "SQL Setup failed to execute a command for server configuration. Refer to the Server error logs and setup logs for detailed error information." U... 24 Jun 2008 12:19

Moving Reporting Srvcs to other Server
Hello to All.... I'm using reporting Services Express 2005 in a XX Server. I need to move this to other Server YY using Sql 2005 Standard. How do I do that? Thanks AfterHand CarlosMag ... 24 Jun 2008 13:22

copy paste does not work
With SQL server 2005 I created some nice graphs. The reports are opened with some default parameters (dependent though) and the graph comes up immediately. Now the end user wants to copy only the graph into Word or Powerpoint. Although it takes a few seconds, it only pastes a blank square. Workaround: If the us... 24 Jun 2008 11:17

When does Microsoft support for Reporting Services 2000 end?
When does Microsoft support for Reporting Services 2000 end? ... 24 Jun 2008 09:13

Data Drive Subscriptions with Multi Value Parameters
Hi, Having problems using the data driven subscription feature when the report contains a multi value parameter. I am able to create a SQL Statement that provides the values to the parameter as a comma seperated list but it's not happy. Is this possible? I have read a few very old posts where it looks like i... 26 Jun 2008 03:19

standard install - cant see web page
hi all I have a standard install of SSRS 2005, all is running fine, I can deploy to my web page fine. I have added a group and in some cases a single person to verify. Giving them browser and publishing roles when they try to log on to my server eg http:\\myservername\reports they get cannot o... 24 Jun 2008 00:02

Issue with Default Parameter
When default value is given to parameter it is not shown until "Hide/Show Parameter" is pressed. How do i show parameters with its default value without need to press "Hide/Show Parameter" button? Thank you, -- Tyampoo ... 23 Jun 2008 17:53

Report Builder - Drop-downs and lists not populating
If you're still looking for an answer, I had the same problem. I found one solution was to give the user select permission to the tables that the filter list is coming from. This seemed like a bit of a hack, but it worked. In my case, my DSV was using SQL views to which the user had select permission, but a... 23 Jun 2008 16:51

Report Manager Virtual Directory disabled
Awesome - this trick works !!! (I had run a manual install of sql server express 2005 adv services setup sp2. at the very beginiing, it shows a dialog where it 'extracts' all files to a folder(the 'to' folder also will be shown in that dialog), made a copy of the entire 'temp' folder and cancel that setup.. next i f... 23 Jun 2008 11:42