when i work with a report in visual studio with a document map, it displays all members in the report on the map. when the report is deployed to report server, it has the document map but only displays the top 20 or so (first visible page) members and i can't scroll down past the top 20. ...more >>

Hello, Does anyone know if it's possible to programatically change the datasetName and/or dataSource via either the reportViewer.dll or through report parameters? My situation is that I need to be able to switch the database and query statement from an active database to an archive database...more >>

Hi I would like to show the data in the report horizontally instead of vertically. I am using reporting services 2000 and sql server 2000. Thanks passx ...more >>

I am unable to install Reporting Services on our new Windows 2003 Server. I have tried several times. I have given ASPNET administration privileges. I have tried the install via remote desktop and VNC. I have tried various systems and local accounts all of which work on other servers. A...more >>

We're planning on upgrading from sql server 2000 to 2005 and we're hoping that SRS 2000 .rdl files will run on sql server 2005. Can anyone confirm if this is the case or not. Thanks in advance for your help. ...more >>

I have a report in which the results are grouped. For example, the report returnd 25 rows, the first 5 rows are one group (lets say all 'A's, the second 5 rows are another group (lets say all 'B's), etc... Can I add conditional formatting to alternate the backgroup color based on groups? ...more >>

For some reason, our reports will just stop working...randomly. It basically tells us it can't connect to our record sets. The report works in the designer. Also, if we re-deploy the report it starts working! Even if we don't change anything it sometimes stops. Then, we re-deploy and it...more >>

I have the following nested structure: List 1 ---List 2 -------Matrix I don't need List 1 anymore in the report. However, if i delete List1 then List2 and the Matrix disappears from the layout as well. How can i remove List1 without deleting List2 and Matrix.... thx. ...more >>

I'm creating a report where I'd like to list out the lines of the report. I deceided to use RowNumber function but it is keeping a running total when I use it like this: RowNumber(Nothing) I used the report wizard to create a report and used the page grouping to seperate pages by "team". ...more >>

Does anyone know if there is a limit to the length a connection string can be? Or if there is a configuration setting that I am missing. We have a XML doc which contains the connection strings for multiple database which we pass to our custom data extension which then figures out which datab...more >>

following up on a post from the setup forum. that post concerned putting ss2000 and ss2005 on the same server, i found out that was fine, which brings me to my next question. would it be ill conceived to also run reporting services 2005 on this cluster? i would like to reuse the ss lice...more >>

We would like to lock down the ability to create individual subscription schedules. We want anyone who creates a subscription to only be able to use a shared schedule. Is there a way to do this? Thanks....more >>

Here is my setup: I have Reporting Service and SQL Server 2000 in one box (Box A), and IIS and Analysis Service in another box (Box B), which has couple of cubes based on the database in Box A, using SQL Authentication and Allow save password. Create AS2000 data source at Reporting Project, t...more >>

Using SS2000, RS2000, VS2003 I have a report that displays group totals and grand totals but no detail lines. There is nothing in the group header. I made the height of the group header as small as possible but there is still too much room between the rows when the report is run. I tried ...more >>

Hello, I need to insert a PDF417 barcode into a report...I have an ActiveX control that will render this barcode. As an RS novice, can someone please give me some pointers as to how I can embed this control in the report and wrap my text in the function that will display the barcode in the...more >>

Please could some one tell me how set the culture of a report inside Report Builder as everything is always formatted en-US (neutral). Where as we have international customers who'd like their reports fomatted with their date / currency standards. It's simple in the full blow Report Desinger...more >>