Hi, I have a dataset that returns the following columns, CategoryID, CategoryName, CategoryParentID, MonthIndex, Amount I am adding this to a Matrix in SSRS 2008 and configuring for a recursive hierarchy which works fine. However, when I change the column from a SUM(Fields!Amount.Value) to a SUM(Fields!Amount.Value, "GroupName"...
I have an asp.net page that is trying to access a SSRS 2008 ReportServer through the ReportViewer control. The reports are accessed using a proxy account that is setup with 'Browser' role on the server. With a regular report access scenario this setup works fine. but whenever we try to load test this page using 100 virtual users, we star...
This is in SSRS 2008. I've created a report with a tablix, embedded in the tablix there is a subreport. This subreport contains a lot of information (and I mean a lot – it takes more than 45 sec to load it). I don’t want to show it, or to be more precise – to process/load the data when the report initially runs. Note that I dont want...
We've recently upgraded one of our SSRS2005 servers to SSRS2008 and have found that all of our applications that utilized the reporting services web service for producing reports no longer works. The first issue is that the web service itself was no longer available at ReportService.asmx, and had been replaced by: ReportService2005.asmx...
Hi folks, I have a tablix in an SSRS 2008 report. It has two-level row groupings, and I'd like the value for the left-most grouping to continue to be displayed on each row. Eg, I get this: group1 subgroup1 500.00 subgroup2 250.00 ... but I'd prefer... group1 subgroup1 500.00 group1 subgroup2 500.00 I can't seem to ...
I have a report with a parameter that is populated by a list of sales representatives returned by a query. I want to filter that list based on security rights of the user running the report. In order to make the query work I need to pass the user!userID to the db. I tried something like this: ...where UserName = user!UserID... But it...
I'm using some complicated expressions in Reporting Services to control the value, format etc of data in a report (see MSDN). Is it possible to insert code comments into these expressions, and if so, what is the syntax? By code comments I mean something like: // single line comment /* or multi line comment */ ...
We have a report that in 2005 version of SSRS, we could dynamically update one parameter (which is a text box) from another report parameter (which is a drop down). Each time the drop down changes, the text box would update. No problem. Now in 2008, it only happens when we first preview the report (in other words, the text box is upda...
I have a report that needs to display accounting data from different locations or all locations. Table_sales: PartId Rev LocId 1 $10 1 2 $2 1 3 $5 2 Lets say the query is something basic like this to get all revenue: SELECT SUM(rev) FROM Table_sales If I want to be able to limit the rep...
I'm trying to figure out if you can create template files or skins for SSRS reports. We are trying to standardize all of our reports to look similar. If there are no known ways to create templates or skins how do you work around this issue? ...
I have 2 reports that need to be printed together. The first report has a header and footer that will repeat (if necessary) on data overflow. The last page, which is a form to be sent back. I basically need a way to print the last page without the repeated header/footers from the first report, and send in parameters to be used in the...
i.e. Can you have more than one data source in a table, or do you still need to use subreports if you want that functionality? ...
Our company started using SQL Server reporting services integrated with sharepoint from the old reporting services with SQL 2000. The web service that is available is called ReportingService2006 and it has lost the .Render method that used to be available in the old ReportingService. My question is what happened? How do I render a rep...
I am running SQL Server Reporting Services on SQL Server 2008 Standard and trying to get the web pages to work. What do I have to do to get RS (Report Manager, Reporting Services Connection), to see me as an admin in the first place so that I can make then change my role and look at the Web Service URL properly? I have Windows auth...
Hello, I have a SQL Server Reporting Services (2008) chart (error chart). The X-axis has date intervals 1/1/2009, 2/1/2009, etc. The Y-axis has numeric intervals of 50. Values on the Y-axis are 0, 50 and 100. However, instead of displaying 0, 50 and 100 i would like to display "Small","Medium" and "Large" respectively. Does anyone know ...
I have a number of SSRS 2008 reports that need to be exported to word in landscape mode. The reports look great when exported but when you attempt to print (or even preview) the page Word appears to be trying to print the reports in portrait mode thus cutting off all content to that is more then 8.5" from the leftmost side of the page. ...
We have an opportunity to purchase 3rd-party chart controls for SQL Server Reporting Services. We are currently using SQL Server 2005 database engine and reporting services, but are contemplating going to 2008 within the next 6 months to a year. What 3rd-party charting controls do you use? What do you see as the good and bad points ...
I have a reporting services dataset returned from a stored proc. I'd like to further filter the data based on a parameter. I've added that filter to the dataset but it's still giving me all of the data. Does filtering work with a proc based dataset or just with a cmd text based select statement? Before I get bombarded with 'just add the...
I'm using SQL 2008 and SSRS 2008: CREATE TABLE [dbo].[DimDates]( [pkDateID] [int] NOT NULL, [FullDate] [date] NULL, [DayNumberOfWeek] [tinyint] NULL, [DayNameOfWeek] [varchar](9) NULL, [IsLastDayOfMonth] [char](1) NULL, [MonthName] [varchar](9) NULL, [CalendarDay] [smallint] NULL, [CalendarWeek] [tinyint]...
Similar to this question, but I have one "master" report which contains many subreports. Everything works great until one of the subreports, when rendered (to PDF, for example), will take up > the space left on a page. In this case, the page breaks so that the subreport starts on a new page. Sometimes this looks incredibly awkward when...