We have deployed our reports on a local machine say "MC230" which is the local intranet. Now we have created a asp.net page and given a link to one of the reports by mentioning "MC230" in the URL of the link. After hosting this page on out web site, we are able to take the reports by clicking ...more >>

Bruce I am pretty much in the same boat I have setup a test reporting services instance on a Windows 2003 box. I now want to setup the WIndows SMTP server and make reporting services send emails to the SMTP server running on Windows. Your help would be highly appreciated if you can specify ...more >>

I have an .aspx page where the user selects filter criteria on the left, and ideally, when the user clicks the LoadReport button the report will load in an IFRAME within the same page. I was generating a URL then generating Javascript and opening a new window for the report. We would rather h...more >>

My host provides access to Report Manager and Report Server with the same login and password for my SQL Server. For obvious security reasons, I do not want to pass these out to my client to access their reports. My host has mentioned consuming the report and using the "credentials" propertie...more >>

I have built a large report but when I try to execute inside of the Report Designer, I get the following error and then an abort: [An error has occurred during report processing Exception of type System.OutOfMemoryException was thrown] I have applied SRS SP1 and here is the MSD info: Mic...more >>

Is there any to let users have a folder of favorite reports? I tried using "My Reports" folder, but the security required to allow a user to see the option to create a linked report created too much of a security risk. Any ideas? ...more >>

We created a sales history report for a client that has one prompt, Sales Region, and when they schedule the report all the filenames of the Excel attachments are the same. They are all the report name. They would like each file to have a name like "SalesRegion-SelectedRegion.xls". And po...more >>

Anyone know how to make a report jump to a particular part of the report when you open it. Here's my situation. I have a summary commission report, that when you click on the Sales reps name, it takes you to a detailed report about the reps invoices. This report needs to have all reps on it,...more >>

I'm using the forms auth sample: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/ufairs.asp I've followed the steps in the sample for configuring forms auth on the /Reports and /ReportServer webs. Forms Auth now works fine on the /ReportServer web. However, o...more >>

I created the below report and it has worked fine all year, however it will not pull data for Dec 2004. Can anyone tell me what may be causing this? Thanks! Glen SELECT Customers.CustomerName, DNRM_ItemMaster.ItemCategory4, SalesDetail.ExtendedPrice, ISNULL((SELECT SalesDet...more >>

Hi, I got the following problem. 1. created Matrix 2. created a stacked bar chart showing the difference in percent (of 2 fields in the matrix) Problem is, the chart is kind of messed up, e.g. 9962 : 1250 being about 13% and 363 : 148 being about 41% But the chart l...more >>

I designed a nice report with a table and a bar chart image to the right from it. It shows exactly how I defined it in the editor....nice. But when I do export to any format (tested mostly with PDF) the report always has the table on the first page and the image on the second. I tried moving ...more >>

Hello all, thanks for your help in advance. I have a report with 1 subreport that is having problems I believe due to timeout issues. It takes a date range and a tour series, then displays a header info for the tour series. It then displays a subreport under each tour series with information...more >>

On my table, I have my footer as grand total line. I set the border style for the "bottom" as "double". But it will not print. Is there something I need to do so I will print double line. Thanks....more >>

I have a static report that has 2 parameters begin date and end date. The report has been running fine for several months but today we had a major data problem. The query returns dollar amounts based on sales, When running the report for 12/29/204 to 1/5/05 we received 3 million in sales,...more >>

Hi, Is there a utility to set cache a temporary copy of the report for multiple reports, instead of going to execution properties of each report? I have close to a 100 reports to which I need to set this to expire after 2 hours (120 min.). Thanks, Sam....more >>

I can easily create reports using the wizard, but I have to spend a lot of time changing them. Is there a way to change the templates the wizard uses? ...more >>

I have built a report. The dataset for the report requires two parameters and retrieves a single record. The report has a page header and body but no page footer. The body contains seven subreports. Each subreport dataset requires the same two parameters, and I am able to pass them without d...more >>

Is there anyway I can send report properties to a custom assembly which does all the work and passes back a dataset that I can then bind to a report? I've got to do some extensive pre-processing of the data, which I couldnt really do with sql query alone, but I'd still like to take advant...more >>

Can you pass a value into the custom code window, do some logic, and if the criteria aren't met move to the next dataset record? I don't know how to do this or aren't sure if you can....more >>

Is there any to manage Reporting Services security (add users,grant acces to reports, ...) outside of the Report Manager ? I would like to enable Reporting Services security and managment from our win32 application... Thanks, Eric...more >>

Well, this is what is happening. I am getting my data from a stored procedure, and for this particular chart am need to use 4 different data fields, 'AverageFillRate', 'AverageFillRateTarget', 'Years', and 'Months'. The years need to correspond to the averagefillrate, so for example, betwee...more >>

I currently have one report that I would like to be able to use to report off of stored procs on multiple servers. And am hoping someone can point me in the right direction. Example: Report A will run off of storedProc1 which exists in every database. However, the specific server and datab...more >>

I find some .DTS file and I want to know what it is doing , but I don't know how to open them, any one know how to do this? thanks a lot...more >>

Hi all, Consider the following scenario: I have two tables: producttable 1 2 3 4 5 indextable child parent 2 1 2 3 4 1 5 3 the tree looks like this: -1 ---2 ---4 -3 ---5 product 2 with parent 3 is missing. Thanks Tom ...more >>

Hello, I need to create a report with a fixed number of table rows. For example: the table is fixed at 20 rows per page regardless of data retrieved. If say 10 rows are filled with data then the rest are blanks. If 25 rows of data is retrieved then the first page is filled and next page h...more >>

I've installed Report Services and need to setup the E-Mail Delivery. There are documents like 'Configuring a Report Server for E-Mail Delivery' that talk about entering values in the SMTPServer field in the rswebapplication.config file, but there isn't enough specific information about set...more >>