OK, Hopefully this is an easy one, but it's got me stumped. I'm trying to build a table that will show a daily amt total and a month-to-date amt total I'm grouping the data by brand. Below is a partial result set. I have one column with ifamt that needs to be filtered by report date. and one colu...more >>

When I installed SQL Server 2005 on my machine, VisualStudio 2005 was also installed. I now have both 2003 and 2005 running. However, reporting service projects are no longer available in the VS 2003 environment. Is it possible to use both side by side? TIA Howard ...more >>

We have published a report to SQL2005 and when we try to view it through XP SP2 PC's it comes out with the following error. An error has occurred during report processing. (rsProcessingAborted) Cannot create a connection to data source 'NZDF2000'. (rsErrorOpeningConnection) For more informa...more >>

Hi - If I want a Reporting Services 2005 installation in which the repository is on a *different* box than the RS services, can the repository database be SQL Server 2000 rather than SQL Server 2005? Thanks and regards,...more >>

I have a client that we're hosting a website for and we have a few reports that we've done for them. They're wanting to create and publish their own reports now and I'm wondering what to buy. They picked up Visual Studio Standard Edition because on the MSDN site it says Standard does Reporting...more >>

We are testing SQL 2005 Reporting Services that was upgraded from SQL 2000 Reporting Services. For the install we reformatted and reinstalled a clean OS (windows 2003) and SQL 2000 sp4/Reporting Services 2000 sp2. When we have a date parameter, there is a long load time after the report ...more >>

My users want to be able to view a report in html and have the rows expand and collapse on certain information. However they want to be able to view the same report in PDF mode and be able to view all of the drill down rows. So my question is this is there a way to have a master expand and c...more >>

SQL Server 2005 and Reporting Services. Has anyone successfully configured Report Manager and Report Server (Virtual Directories) to operate over SSL? If so, how? I have set all the settings I know of, but can't get it to go. Thanks. ...more >>

I'm having trouble rendering a subreport properly. The parent report only takes about 10% of the first page. The subreport returns too many rows (80 - 200) to fit on the first page with the parent report, and is automatically being forced to a new page. This is leaving about 90% whitespac...more >>

I have an issue with a customer who are using reporting services, when they run a report (URL driven) the export link does not always enable, they can run it a second or third or fourth time and it will enable, has anyone seen this behaviour before?...more >>

Are there any tools outside of Visual Studio and the new 2005 Business Intelligence Studio for deploying Sql Server Reports? I need to pass the deployment responsibilities to a separate IT team but can not give them Visual Studio. Thank you Tom ...more >>

hi all Is there a way to tell how many times a report has been run in SRS Report manager? and maybe other related stats. much thanks ...more >>

I don't know if this is possible, but I wanted to throw SSL on the reports folder. I see in the config that you can set it on the report services virtual directory, but I want it on the reports as well. When I set it in IIS, only some of the links use the https redirect, all the other links ...more >>