Can anyone direct me on how to add a subtotal column to a matrix? I have dates in each column header and I want to add another column that has "Total" in its header and sums up the other columns. Thanks...more >>

Hi, I have a Matrix-control which has to "summarize" a lot of data in the end, based upon boolean values. (the column-grouping is a static group). Customer1 Test1 0 1 0 Value 1 Test 1.1 Value 2 Test ...more >>

I need to select more of a value in the parameters How?? -- Tomas...more >>

I have to print some labels in a report and I am using a list. the problem is that there are more than 45 rows in the datasource, so I get a report with 2 pages. How can I list the labels in 2 columns to have a 1 page report....more >>

how do i find out what version of sql server reporting services i am currently using? I would like to install SR1 since it is buggy as hell and i'm hoping that this'll help ...more >>

so can you sort without having a group? ...more >>

I am getting a render error when trying to plot 2 series in a chart. The line seems to be breaking up into spaces. The data is quite simple. There are 2 forecast series. Each forecast series is based on different dates. eg Date Forecast1 Forecast2 1/1 1000 null 2/1 null ...more >>

Is it possible to change line color in the line chart. I can change series color in a bar chart, but cannot seem to change the color of the lines when selecting a smooth line chart. -Chris...more >>

Hi Iam reposting this as my qs seems to have submerged in a deluge of questions ! I have a .net application that lists all the reports within a specific folder using RS.children methodand then calls a specific selected report in Report viewer. My application code and reporting services are i...more >>

I have a store procs that return more that one result set i.e. multiple selects in the store proc. The report always picks out the first result set it finds. How can I get a report to show the other result sets that the store proc generates? Rewriting the store procs is not an option due to ti...more >>

Hello, friends and gurus. May I have some advice on general approach you guys take to generate a mock database with fake data in it? Thanks -- Sincerely...more >>

I have a report (A.rdl) with a FullPath property set to my C:\Temp folder. The rest of my reports have a FullPath property of C:\Documents and Settings\........... I want to permanently change the FullPath property of report A.rdl to be the same as that of the other reports C:\Documents and ...more >>

How can I show the % sign on the Y-axis (20%) for a 100% stacked column chart? Thanks. Jamie...more >>

Hi NG, i want different colors for the values in my drilldown-tables i.e. if value < 0 the values should be red if value > 0 the values should be black any suggests? frank ...more >>

I'm debugging my ReportServer proxy, and cannot find where the RSAuthenticationHeader name is set. (I'm wondering if I need to reference my own cookie name since RS is integrating with several products using the same forms auth.) I can see where RSAuthenticationHeader is *retrieved* in the...more >>

Hi NG, i try to put 3 tables on a report who filled up by three different named datasets (but with same structure). All datasets are filled from the a AS-cube with the same MDX-Statement. The difference between the datasets are the different parameters. And here is my problem: I start to d...more >>

I cannot get my report to connect to my datacube. I've got RS running on a web server and Analysis Services running on another server. The two servers have an established relationship as i am currently able to run RS reports against the SQL Server relational db's that exist on the server tha...more >>

Greetings... I have a report that is being deployed w/ the parameters @sdate (Start Date) and @edate (End Date). My goal is to setup a subscription to a few folks w/ the default dates to be the previous day. I tried using the =datetime.today -1 but recieved errors during compile. If someon...more >>

Using Forms Authentication, is there a way to show all users via a SOAP call? The intent is to then manage the users as can currently be done in Report Manager. Thank you....more >>

Let me preface this by stating that I am a Reporting Services newbie... I need to design a report that displays financial data for 2 companies, Company A and Company B. The problem is that each company has their own distinct database. The schema is identical between them, just different data ...more >>

Hello, I have a field has some calculation and I need to display it somewhere else too. I do not want to calculate again, how can I do this? Thanks, Jim. ...more >>

Hi, When i run my report i don't want to see the parameters that i have given it. How can i hide the parameters? Greetings, Mike Klaarhamer...more >>

I've created a report with a parameter populated from a query that returns the distinct values in a field. However, in addition to the subset of records returned as a result of their parameter selection, I also want to be able to return all rows (as if that field were not part of the select)....more >>

I et the following error trying to start Report Manager after installing SQL2005 beta December CTP. I installed side-by-side with a full SQL2000 implementation on Windows 2003 Server: Server Error in '/Reports$SQL2005' Application -------------------------------------------------------------...more >>

Is there anything I can do so that when my users export their report from reporting services to Excel that it freezes the columns?? I also need to set a default zoom % Is there anyway to do this - thanks ...more >>

Hi How can i set the document map to startup with the report hidden but not gone. -- Thanks Francois...more >>

shotHi group, When I open a report in my IE a new session (ej:zxzxzxzxzx...) was insert into table SessionData in my ReportServerTempDB. It's OK. My report hava same groups and has many drill-drops But when I open other IE and I give this URL: http://myServer/reportserver?my_report&rs:Ses...more >>