Hi, We are having a problem with Reporting Services and are wondering whether it is a limitation in the current version, or whether we just don’t know how to implement something. We are attempting to create a report that is based on information contained in two databases. When the user op...more >>

Can anyone please confirm how well e-mail delivered subscriptions of reports work using Novell Groupwise as the mail solution? There is a post in this forum that suggests Novell Groupwise suffers from the same corruption of PDF and Excel attached reports as Lotus Notes....more >>

i would like to ask if using the Render() function is the ONLY way to get the report in the web?(exclude the url access) how about SOAP? how to use SOAP to generating report in web? by the way, is render() a method which comes from SOAP? i am confuse about it....please help thanks in advan...more >>

I've got a test RS server set up in QA. I want to move everything from it to Production. Is there an easy way for me to move everything from the QA server to the Production server? Thanks ...more >>

Hi There are some questions about the Microsoft Reporting Services: 1. We have a SQL Server 2000, but can I also run this reporting service on a SQL 7 ? 2. Can I set the positions of the objects (eg. rectangle) dynmically? (in asp) greetz patrick ...more >>

When we do a subscription to write a report to a file share we are occasionally getting a "The process cannot access the file" error because a user forgot to close out of it. For reasons that are long our client doesn't want us to save it out there with a different name each morning inste...more >>

Here's the setup: I've got a RS server set up in a QA domain. When I publish reports to it, it prompts me for a username and password. I enter the ADMINISTRATOR account and password and all is well. I've now set up a RS server in the production domain and I need to publish my reports to it....more >>

Is it possible to supress the <hr/> that gets generated for page breaks in HTML view. We want to use the same report definition for both HTML and PDF. We optimized page breaks for the PDF, but want the HTML to be displayed without the URL access (via Web Service) and simply put out the 10 or...more >>

aspnet_wp!ui!980!20.9.2004-09:42:16:: e ERROR: An internal error occurred on the report server. See the error log for more details. --> An internal error occurred on the report server. See the error log for more details. --> Key not valid for use in specified state. aspnet_wp!ui!980!20.9.2004-09...more >>

My RS has stopped working with the error aspnet_wp!library!234!09/20/2004-12:40:41:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ; Info: Microsoft.ReportingS...more >>

I am learning Reporting Servcies. I installed Visual Studio.NET 2003 and can't find 'Business Intelligence Projects' when I click on 'New Project'. Can someone please help?...more >>

Hi: I have a main report (Main Report), which has a subreprot 'Report1' nothing else in that report. Report1 is depend on the parameters from 'MainReport'. 'Report1' has a report heading and few subreports. Report heading is populated from Main reports parameter. When I run MainReport then...more >>

Is it possible to create a parameter where a NULL value returns ALL records and entering a value returns the filtered data? I am filtering a date field "ConvYear" (i.e. 2001, 2002, 2003,etc..) and I want to give the end user a choice of filtering the dataset with a paramater or leaving it bl...more >>

Hi, The scenario. The list of recipients with respective parameter information is stored in custom tables on the Report Server database on Server 1. Our reports pull data from another Server - Server 2. We have a data driven subscription set up to retrieve the list of recipients from t...more >>

HI,,,,,,,,,,EveryBody... Does anybody have code sample for on the fly report generation , generate "RDL" xml file with XMLA. pls help me, I am really stuck with this problem , becoz I have posted many posts but still I didnt get a helpfull machanizam. Thanks Summa. ...more >>

Hi, it would be great there was the option to fire off a data driven subscription manually in case we would like our recipients to receive an immediate update before the next scheduled run date. Of course, we could go into the subscription, set it to a run once schedule and once fired reset...more >>

Hi, we have an odd thing where our SQL Server Agent says it's running according to Enterprise Manager and in the Services Manager via the Control Panel, but when I try to view the Schedules, I get the message SQL Agent is not running. Restarting the Agent resolves this. Can anyone shed some ...more >>

Hi I've build my own report viewer app in an aspx project. This is made up using frames - top frame for navigation, bottom frame for viewing reports. One of my reports links to another report. I have this working, but have 2 issues... 1. When I click on the link it loads the new report i...more >>

I have serveral prameters in a report. I pass the values of some prameters from the URL. I hope that the user can just see and set the parameter which is not passed by URL. How can I do that? ...more >>

Hi, I have a number of reports which hidden parameters. The problem is that when I change the reports, or as the number of reports grows, I'm then having to manually go through the report in report manager and remove the prompt string, making sure that 'Prompt user' is checked to put the 'h...more >>

Hi I am having a problem with userid and subscriptions. Every time i try to use the value =User!UserID in a parameter the subscription failed with the message "report is using user defined parameter values". How can i get pass this as other parameter values in my report is dependend on the...more >>