I am using a reporting services and have a custom data source. The custom data source calls a stored procedure and merges that with some extra data from active directory. When I run the report the parameters are there and it runs fine, but if I press 'refresh fields' to get a full listing in t...more >>

I've got a one page chart/graph report that runs fine when until I render it as PDF. When I do, it slows down to a crawl (about 10 seconds vs. normally sub-second). I can even render as EMF or gif quite fast, but PDF is killing me. If anybody has any ideas, I'd love to hear them. Chris ...more >>

Hi, I have a somewhat complicated problem, and haven't found any resources to help me out yet. I have a stored procedure (SQL) that returns a resultset. This should be grouped by a code. Each code can be flagged one of three ways. Depending on the flag, we need a different layout for the...more >>

In Excel, there is the nice ability to freeze panes so you can see the table header as you scroll down the report. Is there a way to duplicate this functionality in Reporting Services beyond just displaying the table header on every page and w/o having to export the data to excel first? Than...more >>

In Excel, there is the nice ability to freeze panes so you can see the table header as you scroll down the report. Is there a way to duplicate this functionality in Reporting Services beyond just displaying the table header on every page and w/o having to export the data to excel first? Than...more >>

We have 2 reports: /All Reports/Master Report /All Reports/Detail Report We have linked them to an individual's folder: /Users/Vince Carter/Master Report /Users/Vince Carter/Detail Report Problem: Sometimes the drill-through link in the Master Report in Vince's folder is properly li...more >>

I've implemented a custom security extension so that I have a single sign on between a custom web application and the Report Server (this allows to me to make calls to the RS Web Service and access reports via URL Access). This was accomplished with the help of the 'Forms Authentication Across ...more >>

Trying to install RS on Server 2003. Installed IIS and ASP.NET OK. Install goes through with little intervention from me, but installs only the help files. Install never gives me the option to select any components or options. Also, SETUP seems to keep running after it says it's done. An...more >>

Hi, when exporting a report containing a simple table to Excel (97, 2000, 2003 - all the same) I always experience the following problem: Row height is not adjusted to the actual height of the row (even if text wrapping is allowed) and the rows don't react on the Excel AutoFit command an...more >>

Is there any way to dynamically / programatically set the width of a textbox? Thank You ...more >>

Hello all, I need to render multiple Reporting Services reports into a single PDF for output. Each report will retain its own headers and footers. Current: (3 PDFs) --------------------------------- Cover Sheet (1 page) Sales Report (2 pages) Accounting Report (2 pages) Needed: (one ...more >>

We set up a server running SQL Server 2000 Reporting Services. We map multiple alias to its IP. If we assign it a name alias without ".", i.e. rptsrv, we don't get prompted for inputting user name and password for windows identification. But if we assign a name alias with ".", i.e. rpt.srv, ...more >>

Hi, i am using the following query. The user can choose the Year as parameter. I want an option for "All years" in the parameters.. How can I do this.My query is: SELECT Customer_Info.FirstName AS FirstName, Customer_Info.LastName AS LastName, Customer_Info.KPChoice AS BusinessUnit, ...more >>

Hi all! I have a report with a table which spans multiple pages. I need to sum one field not by group, nor by dataset, but by page. How can I do this? Thanks....more >>

Hi, I have a report that has fields that look fine in the report through the web but when it's exported to PDF for printing, it turns certain fields to unreadable. It seems to affect fields that have special characters. For example: "Patient Classification Systems: Historical Problems & Now...more >>

Hi, can anyone tell me how i can retrieve the link to the rdl file using web services ? Because i want to access the rdl file, but i've only got the name of the report (and the path to it) from the report server DB. (I need it because i want to know how many parameters the report has). T...more >>

In the layout tab, =Fields!Create_Date.Value returns the epoch date (1075484170), which is the way my db stores dates. Is there a function in Reporting Services that will convert this to a readable format? Also, in the properties dialog for the above field, I can select Date or Time, b...more >>

Hi, I am trying to set up an email subscription for some reports, but I keep seeing the following error when the report is trying to send: Failure sending mail: The message could not be sent to the SMTP server. The transport error code was 0x800ccc15. The server response was not available ...more >>

When I open some a report from the browser I get a directory listing instead of the report itself. This only happens with some reports, while other reports are displayed correctly. The listing is in the form p10/ReportServer - / .... list of directories under ReportServer... Microsoft SQL S...more >>

Hi, Is there any way through which I can change the SQL for a report at runtime. If the report was created with "Select * From Authors", I would like to modify that with "Select * From Authors Where RegionID=1". I know I can use parameters to achieve this. Is there any API to directly modif...more >>