Is it possible to check the values for a particular field in a dataset and change it with a filter? I need to turn nulls into empty strings in a few fields in the incoming record set. If so, how? Thanks....more >>

Hi, I am on RS sp1, I have developed several reports bases on Analysis Services cubes. I use in the reports several pie, bar, etc charts. I would like to know if there is a Dashboard type Guage chart ( sort of like a speedometer in the dashboard of one's car) in the RS graphicas library, maybe n...more >>

I have read previous posts and am still having an issue. Our production server is running SP1 and still exports Excel Files as web archive format. So the files end up being 10 to 20 MB and not 1 MB. Any help would be appreciated. Thanks in advance -- Thanks, Chris Allen ...more >>

I am trying to create my own query designer (instead of using teh generic query designer) for Reporting Services. I have implemented IQuery Designer and everything works fine. I click on teh data tab, and i can see the designer that i created. However, when I change something on teh query ...more >>

Problem: I'm getting a generic error reported when I attempt to run a subscription bound for the Printer Delivery sample. Detail: The subscription job fires successfully, but fails to print. The status indicator in Report Manager says only: "New Subscription" In the service log I see: R...more >>

Hi, I did the following : From Data Link Properties dialog Provider tab, choose Microsoft Jet 4.0 OLE DB Provider. In the Connection tab Typed the name of the workbook into the 'Select or enter a database name' box (or select it by clicking the 'ellipses' button, changing the 'File of T...more >>

I am running MS RS SP1 Developer Edition, and I have implemented forms authentication based on the various online articles. I have custom authentication and authorization providers which are working great. I access the Report Manager on my local development machine, my custom logon page appears,...more >>

Is there a way to configure how long to display the "!New" icon in the Report Manger? ...more >>

here is an example of this bug at work.. (i am using RS SP1) 1) upload this report into report manager 2) - RUN THE Report, and notice that the 2nd parameter called 'defaultparam' gets set to the date, and it works.. (all the report does is show this parameter) 3) - go to the parameter...more >>

Hi, How do I format dateme to i.e. Thursday, February 17,2005? Thanks. Chuck...more >>

Hi, I have one report that needs to connect to 15 databases and generate same reports every day. Instead of creating 15 reports with 15 data sources, is there a dynamic way to create one report only by automatically connecting to various databases? Thanks. Chuck...more >>

Hi, I have some data I'd like to retrieve and run a report from, but the data is one 2 different servers. I don't know how to set this up in report manager or create a query that says something like select server.database.field, differentserver.database.field etc. Any help would be greatly a...more >>

Hi, This is my situation: I have a report that is generated as Excel.The data for this report needs to come from 2 sources 1.Database 2.Another Excel. I was able to do the first i.e from the database. How can I pull out data from another excel into this? is there any reference material ...more >>

Hi all, I'm working through the Microsoft forms authentication extension sample, and I've noticed that when logging into ReportManager, the authentication cookie name (System.Web.Security.FormsAuthentication.FormsCookieName) is always ".ASPXAUTH" I'm guessing this is because ReportManager's we...more >>

Hi i succeeded in just getting of ReportManager,ReportServer browsers. Now problem r *I am not working with RS Programming .I am working all by designing only* 1)After i registerd name and password i can't able to logon into reportmanager. I am getting error like " The request fa...more >>

When I uncheck the 'Snap to Grid' checkbox in the Report properties window, and attempt to move an element in the report designer, I recieve an Unspecified error, I continously get this error popping up - I have to close VS.NET and reopen for the error messeges to stop. I also occasionally get...more >>

I have a matrix that displays data for tags per day on each page. The matrix has a grouped column that does the grouping by day (this column is returned from a stored procedure) and page breaks at the end of the day. This is what I need - before I page break, I need to also display the statist...more >>

Hi, Trying to install the developer's version of Reporting Services on Windows 2003 Server with SQL Server 2000 SP3. I click on SETUP.EXE and the very first dialog box comes up and says: Software components to install: >Microsoft SQL Server Reporting Services Setup Support File...more >>

Hi, Can I modify the export dropdown list in the report viewer. The Html viewer that is provided has a predefined set in the drop down list. Can I modify this list so that it only shows pdf, excel and html in the list. Thanks in advance. Sam...more >>

We are attempting to take a 13 Slide Graphical Powerpoint Report and Generate same in Reporting Services. The individual Slides (which contain up to as many as 4 subreports with graph and matrix) are beautiful! They deploy well and we are all happy....IF that is you are opening them 1 at a t...more >>

Hi, I have been working on this problem for some time now and I am no closer to a solution/answer. The trouble is that I have created two reports which are basically tables which display database data, with the input of several search parameters, but when they get to a certain size (it a...more >>

I have created a static column in my matrix with the following steps: - Click on the detail cell of the matrix with the right button and choose "add row". A new row and a new column are added. - Delete the new cell that has been created under the detail cell. This deletes the new row but leav...more >>

Hi, How can I pass a parameter to a Reporting services report from an ASP web page? i.e. How does the Reporting services report receive the the parameter? do I have to create a dataset for this parameter when designing the report?. I have used MDX statement for the Reporting services repor...more >>

Does anybody know if it is possible to create an ASP.NET webform (Form1) that simply recieves a request from a client browser, and then sends that request (changing a few bits as necessary) on to another page (Form2). The response from Form2 will then be digested by Form1 and returned to client ...more >>