Hi, I installed (full installation) SQL Server 2000 Reporting Services on my PC (Windows Server 2003, SQL Server 2000 SP3 Enterprise and Visual Studio 2003) and everything went smoothly when no problems... now I am trying to open Reports Manager (http://LocalHost/Reports) but I get the foll...more >>

I rolled out reporting services to 180 extrenal users with their own personal pcs and I have a few extrenal users that are unable to view any of the reports. They can get logged into reporting services, see the list of reports available to them, but when they click on a report to view it they g...more >>

I am installing SP2 on a web farm. When I originally installed Reporting services I pointed the database to a separate server. Now when installing the SP the database didn't get updated with the SP and I can't get the SP to run on the server with the database. The error I get basically says that...more >>

Hi, I have a report I want to add subreports to....but the books online are worthless in this regard of a howto...any help? -- tym, Eskimo...more >>

I have a Datetime parameter from a dataset. It also shows the time but I only need the date, is it possible somehow to change how it displays the parameter. As what I can see it is only possible to choose datetime format. I tried to convert it like this convert(datetime,period,105) as dateonly an...more >>

I just installed SQL reporting services on a Windows Server 2003 machine. I am unable to open report manager, the error message that i get is "Unable to communicate with report server. Please verify that the report server is operational." Any ideas on how to resolve this problem? Thanks...more >>

Hi, I have a matrix control with actiondefined on the "Data" cell of the matrix. The action is jump to the details report. Now I have 4 parameters. Out which 2 CAN be sometimes nulls or not defined. @month has Fields!Month.Value @Item_Code has Fields!Item_Code.value. I tried setting th...more >>

Is it possible to share one parameter? I wanto to use two different datasets but need to use the same parameter in both of them. I don't want to repeat the parameter selection. ...more >>

I have some 'go to' links and 'back to' links in my report. I want the 'go to' links displays reports in new window and 'back to' links displays the reports in same window. any idea?...more >>

I have a report that toggles a group properly on my development machine. When I upload the RDL to the server the visibility does not toggle. I do get the + indication. I then change the default Visible property to True and I can see my details. When I attempt to minimize the group the sc...more >>

hello, I try to in install reporting services. First error i receive is the 25619 error message. I tried to apply the solution as described in the knowledge base. After applying the workaround i get the following error when opening the reportserver "HTTP status 405: Method Not Allowed." ...more >>

For whatever reason the database was not upgraded when doing the SP2 install. I noticed 6 or 8 sql scripts in the C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer directory. Is it possible to just run the SQL scripts against the database to upgrade the database? Is the...more >>

I would like to allow the user the ability to drill-through to a report (Tax Report) but only when the value of the field they're on is not equal to 0. To accomplish this I use a conditional expression. I assume the arguments need to be of type string. What argument is used to denote an action e...more >>

I need to change the amount of space that RS leaves between its rows in a report. Is this possible? Thanks os...more >>

Hi I have compiled the code which you can download from the article at http://msdn.microsoft.com/msdnmag/issues/05/02/CustomRenderers/default.aspx and entered the component information in the two config files mentioned in the article (RSReportServer.config, rssrvpolicy.config) and the custom ...more >>

Is this property available as in MS Access? It should attempt to fit the entire group (heading and detail) on the current page if it can, and issue a page break if it can't. ...more >>

Folks, I'm getting data back from the database in the following format: row_id | col_Name | col_Value 0 | ID | 10 0 | Name | First 0 | Jan | 1 0 | Feb | 2 1 | ID | 20 1 | Name | Seconds 1 | Jan | 10 1 | Feb | 20 .... We are grouping based on the row_id db column, thus creating dy...more >>

Hi, When I use the render method on a server using windows authentication the method works like a charm. When I use the render method on a server using forms authentication i get an error: Object moved to <a href='/ReportServer/logon.aspx?ReturnUrl=%2fReportServer%2fReportService.asmx'> ...more >>

Hi. I have a parameter driven report that has been built and deployed succesfully with no errors. After execution of the report I am just left with the format of my report in my web browser i.e. no data is displayed. However ...when I run the exact same SP from query analyzer I rece...more >>

Hallo, We have a ASP.Net app and need a way to manage the datasource. We have one report for 5 Customer. Every customer has his own DB on our Server. And Every customer has his own Datasource in the Reportmanager. Now i call my report with url and will tell the reportservices to take Co...more >>

Is there an example of how to call the report server web services without using the .Net API that it comes with? I need to call the web services from a non .Net client. Thanks. -- McGeeky http://mcgeeky.blogspot.com ...more >>