I'm new to Reporting Services, and i'm trying to re-create the 1st report in Reporting Services that we have in a old Access97 db. Anyway, I have setup a 2nd DataSet that allows the enduser to specify what group that they would like to run the report for. I would like to give them the option ...more >>

Hi, How do we enable Print Preview and Printing using Report Viewer control? -- Divya...more >>

I know the BOL give details on the mimimum spec, but in the real world what would you expect for the following? Memory Processor(s) Operating System it can run under SQL version needed IE version it will run with Will it run on other browsers Mozilla etc? -- Regards <<<Bryan Av...more >>

I've noticed that for automatically refreshing reports when you run the report (and the page refreshes) the data is not updated. Only when you click the refresh button in the toolbar does the data start changing. Is this a bug or a feature? The reason why I ask is I want to know if I can depen...more >>

My group total contains the total for all groups instead of the total for the individual group. Can someone tell me what I have done wrong?...more >>

Hi: My business users want to record each time a report (which is actually a letter) is generated. They want a record to include the time as well as the value of a few of the fields that appear on the report. Can this be done with SQL RS? Can a custom assembly or module be written that...more >>

Hi, I have a dataset with values for each month. For example: Jan Feb Mar Apr May Jun Jul 1200 1500 1420 1540 1450 1470 1467 I would like to create a Bar chart from this data. Is there a way to supply the row as a source data? Since my data is in 12 columns, i have to add each column as...more >>

Hi, Is it possible to have a Bar chart and a Line chart on the same graph? I have a series that I would like to display as a Bar chart and anther series as line chart. is it possible? thanks,...more >>

I am getting errors when I try to print after SP2 has been installed on the server. I have cleared out the activeX control from my downloaded files folder but I keep getting the same errors. How can I tell if I have SP2 or SP2 Beta installed? Anyone know? Can I check the version numb...more >>

I am trying to sum the columns in a matrix and am having trouble with the totals row. I right-click the row group and click subtotals. This creates the Total row just fine, with the “Total” cell directly under the row group cell. However, the cell in the data column is inaccessible, so ...more >>

Hello: I am new with the Reporting services. When I tried creating a data source with the following connection string with the following options: Conenction Type: SQLServer or OLE DB Connect using: credentials supplied by the user running the report) Connection String: Provider=SQLOLE...more >>

Had anyone made an export to excel that has 33 rows? 33 rows in excel, together with header and all... I'm asking that because in my case when export to excel has 33 rows, 33. row is always missing!...more >>

I need to make a report that looks like.... Statistic A Statistic B Statistic C Statistic D ---------------------------------------------------------- 99 07 102 91 It would be easy but the values are all in one column in the table, ...more >>

I am using Microsofts sample ReportViewer in my asp app I am using window impersonation but I can not get the viewer to use the identity of the user that I am impersonating Is there a way (within ReportViewer) to set the authentication for viewing the reports? -- Dain Computer Progra...more >>

Within Reporting Services you can apply a description to a report in the Report Manager. How and where can I access this? I would like to access the Description through WebServices, but not sure how. I am currently using the following code for accessing the report name: Dim rSe...more >>

We have an asp.net app that calls the report server for our reports. We are running into an issue we don't even understand why it's happening let alone fixing it.... You can only run one report and then you have to logout of the app and log back in to run another report. This is with any ...more >>

We have an order screen which we would like to be visible at all times, and a report based off some of the information on that screen. Is there any way to keep this window open and open the report in a new window? Right now the button used to launch the report is a server control button. Thi...more >>

I have a report that need to use a decrypting dll. I can save the DLL on my locat drive and run the report locally in the report designer. Ho do I get it to work with a published report. I have put the dll on the local drive of the server but it does not work when I run the report in report...more >>

I had an unfortunate situation where a downed server resulted in a significant amount of lost work (the rdl files of several reports I had been working on). I had previously uploaded them to the reporting services server and had hoped that I could recover them from there - but I can't find...more >>

Our database is normalized to the point that I need to build a dataset to render a report from. For example "select county name from COUNTYTABLE where COUNTYNUMBER IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15) ". This query return 1 column and 15 rows of county names. I need them to be in 1 r...more >>

We have multiple development environments on one machine for our Visual Studio .net projects. These are web applications so we have organized them by IP Address and Host Headers. When I installed Reporting Services, it installed into my default web site (localhost) and that is fine. Howeve...more >>

When I view the Employee Sales Summary Sample report, The text of the title and headings of the charts looks awful. It looks like the browser is unable to cope with the resolution required. Text in the tables is OK. Is there anything I can do....more >>

Hi, I'm having this wee problem when trying to view my report via the report manager screen - I get the following error "Request for the permission of type System.Security.Permissions.SecurityPermission, mscorlib, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 failed...more >>

Hi, Our production Report Server has stopped sending out automated subscriptions since being patched on the weekend. This is obviously quite serious as none of the automated reports are being delivered to users. The error in the logfile ( ) is: ReportingServicesService!emailextension!6...more >>

When setting default parameters for a report, and you click on the report, it runs automatically. Is it possible to allow the user to still change the parameters before the report runs?...more >>

Is it possible to call a .Net Class from within a report code window. I need to access a complex routine that is held in one of my classes but I can't seem to access it through the reports. -- Regards <<<Bryan Avery>>>...more >>

Is there any easy way to find out SP2 is installed on the Server ? Thanks...more >>