I am running RS2005 I have a report that contains a link to another report using Jump to URL. To avoid hard coding, I am using the Globals!ReportServerUrl variable to build up the path to the linked report. When I run the first report from Report Manager, it displays as expected and the...more >>

get the message EXECUTE permission denied on object 'xp_sqlagent_notify' when trying to create subscription on the report in RS From http://www.developmentnow.com/g/115_2004_7_0_12_0/sql-server-reporting-services.htm Posted via DevelopmentNow.com Groups http://www.developmentnow.com...more >>

I have a set of 25 reports that contain the links to the other application (URL). Is there a way to define a single "global" string for all the reports to quickly replace that url with the right one? Let's say it's http://testingserver/app for testing, and http://production/app for production. I...more >>

I'm reposting this since no one has answered and I'm finding other forums where people are asking the same question and no answers to be found, including when I asked the question. It seems like if I'm not the only person seeing this error, someone, somewhere should have it documented. I...more >>

What is the minimum installation for the developer's computer if the person is going to desing the reports locally? Typical installation of Visual Studio 2005 does not have anything to do with Reporting Services, SQL Server Express installed together with VS2005 also not configured for Reporting ...more >>

Does anyone know if it is possible to use the Jump To URL feature to display a pdf file? It seem like it should be possible because I can upload the pdf to a Reporting Services folder and then use Report Manager to open and display it, but I can't seem to get it to work in a report. Possibl...more >>

Hi, ReportServerTempDB db log file cannot be shrunk. I'm not sure how, but in sys.databases, the log_reuse_wait_desc field contains REPLICATION for both the ReportServer and ReportServerTempDB records. I believe this should read Nothing. I believe this may be our problem. Has anyone seen th...more >>

I work for a non-profit agency which is slooowly computerizing itself. We recently acquired SS 2005 and I am learning RS 2005. My question: How can I create a report format such that the 'groups' are adjacent to each other?? This is not the same as multi-column report, which looks like ne...more >>

Hi, I need to know if we have any automated process of converting reports generated in asp and dispalyed as html format can be converted to SQL Reporting Service rdl files. This will reduce my effort of re designing all the asp reports into the SQL reports. Please need an urgent help on thi...more >>

I use Firefox as my default browser on my development machine for RS2005 with SS2005. I solved the authentication problem by setting IE to Tools, Security, Intranet to User Authentication, Logon, all the way down at the bottom of the list to Automatic logon with current user name and password....more >>

Hi, I am trying to export a report to pdf and it does not keep all teh columsn in the same page. I could not find any options to specify. Has faced the same problem??? Jaideep ...more >>

I have designed a report that has a parameter that allows you to select multiple customers. When I preview the report in Visual Studio 05, the drop down list has a checkbox at the top that says "select all". When I deploy the report to the Report Mgr Website (SQL Server 2005 STD, SP1), everyt...more >>

I have a simple asp.net 2.0 page using Report Viewer to render reports from SQL Server 2005 Reporting Services. The report itself has input as criteria for search. It seems fine to get to the report page. Once the page takes the input and clicked on the View Report button, the following e...more >>

I would like the paramter for a report I am building to be set to 30 days ago. Using T-SQL syntax it would be DATEADD(dd, -30, getdate()), but this seems to throw an error in reporting services. 1) How do I write DATEADD(dd, -30, getdate()) as a parameter in reporting services? 2) What ...more >>

Ok fellas, I need your help. I have a crosstab query that I wrote in Access that lists all my marketers regardless of their referrals. The outer joins selects all rows from marketer table. Now in SSRS I recreated the same query, setup the matrix and populated it correctly. Problem is, that if ...more >>

Hi, I have a report with a group and detail rows. I want to count up the groups in the column groupnumber. I tried the rownumber(<scope>) function. If I use rownumber (Nothing) the detail rows were counted. If I use rownumber("Groupname") the Report Server shows the number of detail ...more >>

Our web based Application is based on ASP.NET 1.1 and SQL Server 2005. Can we use 2005 Reporting Services (ASP.NET 2.0) to create and publish reports and use them in the 1.1 Application? (We need to change the Data Source at run time, which is not easy or not possible in 2000 Reporting Servi...more >>