I have two reports built using SSRS 2005. The first report is set to navigate to the second when a specific field is clicked. I am using an expression similar to the following in the "Jump to URL" property of the textbox: ="javascript:void(window.open('http://server/reportserver?%2fFolder%2fMyReport&rs:Command=Render&Date=" & ...
I've inherited a headache! I have two SQL Reporting Services servers. One is a production server, the other is a test server. I know for a fact that some of the reports were deployed directly to production. I know for a fact that some reports are out of sync, meaning the version on Test isn't the same as the version on Prod and vice-...
I have an SSRS matrix report that has 4 column groups with the last group set to hide some of its columns if they contain no data. The report works perfectly, however when exported to excel an empty column header appears and all the headers shift right. It can happen multiple times on the same sheet. For examples instead of seeing some...
Is there a way, in a report, to filter data by AD group? I need to make it so "Group A" can see all data and "Group B" sees less. I can't change anything in the DB and the just the user name is passed to the report. Any ideas? ...
What the main differences between SQL Reporting Services 2005 and 2008 in terms of features? I read about 2008 has much better in scalability. How about the features? What's in SSRS 2008 but not 2005? Thanks! ...
My business analysts have created 7 reports (using Report Builder) they want merged into a MEGA-report. I've been trying to do this by wrapping them all in subreports (which you can't use in Report Builder 1.0). While all reports show up, the layouts are all over the place. The subreports seem to reorder themselves. I've dropped down to...
I've got the following report setup: 1. Letterhead (not in the header, since i only want it on the first page) 2. List control with some data when i export the report to PDF, and the contents of the List are less that one full page - my letterhead is displayed on the first page (the rest of the page is empty) and the List content gets...
I would like to be able to programatically add a user to the report server by creating some stored procedure that accepts user_id and does inserts into ReportServer..Users and other associated tables. I am having trouble doing this (especially the column ReportServer..Users.Sid). Has anyone been able to accomplish this in the past? Th...
This question is a follow up to my original question, I've done a bit more reseach, i narrowed a problem down quite a bit. I've also uploaded a sample .rdl to illustrate the problem I've got the following report setup: a header (image in the body), two textboxes, and a footer. First textbox has a little bit of text, and second textb...
Hi I have been working on a large matrix which displays the results of a stored procuedre with date fields for the dynamic columns. Prior to the dynamic columns i have several other columns of identifiers for the data. The problem i have is when i try and add column headings (in the tableheading textbox) for the identifiers i need to use...
Is it possible to create a custom Web front-end to run SSRS reports from? We have an existing cross-browser web front-end for gathering reporting inputs (for a non-SSRS platform) that we would like to see continue with SSRS instead. It includes domain-specific UI controls that have been developed in-house already, and nothing comes clo...
We are considering migrating to Sql Server 2005 Reporting Services. Many of our existing reports require pre-processing of the data before rendering it. For example, we have a query for a report that returns GPS coordinates (Latitude and Longitude) from a stored procedure, but before passing off the DataSet to our reporting engine (curr...
The other day we installed SQL Server 2005 SP3 on our reporting server. Since that point our ASP.NET 3.5 website, which uses the Report Viewer web control, is giving the error message "Unable to load client print control" whenever someone tries to print. The reports and printing work fine if we go to the Report Manager directly, it i...
I have a set of reports defined for Reporting Services in SQL 2005. I'm rendering the reports using the ReportViewer control inside an ASP.NET 3.5 application. In all the reports I have a chart and a table where interactive sorting is implemented. The sorting works perfectly when I test it on the report server catalog page. But in the re...
We have a report in SSRS 2005, where in we wanted to update one parameter(which is not linked to any other report parameters or dataset) based on the value of another report parameter(which is the selected value from a dataset). Can anyone let me know how to achieve this functionality? ...
Hi, I have created a dynamic subscribtion. All work well, but if I create the subscrbtion on any month say like July 09, and select that I get the report of previous month on monthly basis. Now In month of August I will receive the report for the data of July 09 which is correct but after that in September 09, I should Receive the repor...
I have a number of reports deployed to a SQL Server 2005 Reporting Services server. They were all developed using the same Report Model (SDML) that references the same Data Source View (DSV) that points to a test database filled with mostly dummy data. Now, I would like to make those reports pull data from the live database with our real...
We are using Reporting Services 2005 on SQL 2005 and when a report is running then Reporting Services seems to block for that user. e.g. navigating in /Reports/Pages/Folder.aspx will wait until the report finishes before displaying anything. I have had a look at the rsreportserver.config file but nothing in there seems to be limiting thi...
I have a Winforms application that uses the ReportViewer control to display SSRS reports. I have one report with many paramters that must be set by the user. I specifically set one of the parameters to have no default value so that the parameter prompts would display in the report viewer prior to running the report. However, when th...
I work for company A. Company A has a sister company B. Both companies A and B use the same ERP database. I have created an SSRS 2005 report that can be used by both companies. It has a CompanyID parameter that determines whether to display data for company A or company B. For most reports this will be OK, but for company sensitive info...