I needed to move my IIS to a new server and upgrade it. So this is what I did. Originally running on windows 2000 server w/ IIS 5 Backed up both the reportServer DB and the temp DB backed up the key file Installed a new server running server 2003 and IIS 6.0 deleted the orginal 2 databas...more >>

Is it possible to have charting in SQL Server REporting services, where when a mouse points to a point on the graph, it displays the value of the point?...more >>

Hello Everybody I have the question about the SQL Server Performance and design considerations. I am developing code that is going to deal with a lot of records (specific detail in the attachment). I am writing code right now that is working fine with a few records. My concern is to know ho...more >>

Scenario: Using VS, I deploy a new version of a report (e.g., change some text) to ReportServer. When I view the report from the web server using a browser, the report does not show the change. I tried deleting the report from the server, and re-deploying. The new report appears in Reports...more >>

I am looking to put the SQL2005 Xpress on my dev machine, which already had 2K and RS + .NET 1.xxx. I understand I need to remove .NET 1.xxx to install 2.0. How will this affect SQLRS? I have RSSP2 installed. Thanks, Tony...more >>

Hi, i am trying to export report data to excel but when i choose to print, its default layout is set to LANDSCAPE and i want to set the layout to PORTRAIT. HOw can i do. If anybody has done it pls share it with me. Thanks JAsvinder...more >>

Hi, I have a report based on a stored procedure. The stored procedure does some calculations and finally returns a query based on a temporary table: Select * from #Tmp The problem is Reporting Services doesn't see the results based on a #temporary table (no error, no rows...more >>

Hello, Somebody knows a way (different to the described in the troubleshooting guide of Reporting Services) to resolve this error???, I Installed Rs into a w2k3 machine with sharepoint portal server and Microsoft SQL Server 2000 - 8.00.818 (Intel X86) Thanks in advance KMILO ...more >>

I have created a report with two columns. Using the preview for the new client printing: When the report I only contains enough data for a single column nothing is being displayed in page header and footer. When the report contains enough data for both columns the values in the page hea...more >>

I have installed SP2 on my workstation (client only, no server components) and I can't seem to find the new version of the HTML Viewer control anywhere. Also, the documentation doesn't seem to have been updated either. Is there updated documentation for SP2, and if so, does it contain inform...more >>

There are things configured/setup in Report Manager that we would like to version in Visual SourceSafe... the setup of data-driven subscriptions, for instance. Has anyone done this? Does anyone know of a third-party product that assists with this? I'm currently thinking of writing some code...more >>

I have a bunch of reports with four parameters, two integers and two datetimes. They don't have defaults. I have gone through them and added another parameter, a string, nullable, with a default of =String.Empty (the purpose of this is to have a parameter in which I can pass a unique ID, to ...more >>

When I create e-mail subscriptions they have an error with the status: "Failure sending mail: The transport lost its connection to the server." Has someone run into this before? Thanks, Nathan...more >>

In the History section of a report (in Report Manager), assuming the report is run from a snapshot and the server is configured to store an unlimited number, at what point do these appear in the History? I have several reports that, even though they're run from a snapshot, they say "There are ...more >>

I've looked at most of the emails from people that are confused regarding how to setup the email. But in the http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsadmin/htm/arp_configserver_v1_4bzl.asp from Microsoft, it indicates that in SendEmailToUserAlias "true=The e-mail ad...more >>

Hello all, I need to generate a report based on dates(from and to). Is there anyway I can include a dropdown of datetime in the parameters of the RS interface. for example like from mm/dd/yyyy to mm/dd/yyyy. I have RS 2003 EE with SP1 and have no plans of installing SP2. Any help will ...more >>

Is there way to print the Header column of a table along with the NoRows message ? Seems like it just prints the NoRows message and doesnt render any part of the table. Thanks Ravi ...more >>

Greetings, I have a set of reports that were created using the report designer in Visual Studio. They were originally written to run against an Informix database, but I now need to change them to run against an SQL Server DB. I added a new datasource for the SQL Server DB, but couldn't find *...more >>

Regards, When a non administrative person sets up an email subscription to a particular report, the "to" field defaults to their login name rather than their email address. So for jsmith@microsoft.com, the "to" field defaults to "jsmith" and is read only so it can't be changed. Once the ...more >>

I am just getting started with reportingservices and have it installed (SP2) on my development machine (Win XP Pro SP2). I created a simple report and set the layout to be 2 columns across. It print previews as two columns in VS designer, but when viewing through the report web interface, it...more >>

I have read all the threads on ReportItems and Sum within a group but still can't solve my problem. Really appreciate any help. I have a report with 3 groups and a report parameter called Recharge as follows Hours Hrly Cost/Rate Total Costs/Rates 8 67 ...more >>

I am trying to print a report in landscape with legal paper size. I can get my report printed just fine by clicking on the print icon and changing the paper size to legal in the printer properties. Since we have multiple reports it is hard for the users to memorize which reports have to be prin...more >>

How can we change in code the Scale Minimum value via code, depending on the data in a dataset? What I would like to beable to do is find the min. value in the dataset and then set Scale Minimum value ...more >>

Hi all, I'm trying pass parameters by Post. Woks fine but when the length of parameter is over 1845 chars the report is not displayed. There are limit in the post method in RS. Rachel...more >>

Hello, i wonder if it is possible to install the adventure works sample db after updating to ms sql reporting svcs sp1. I got a new book and want to do the trainings on it and would like to know if there are problems or issues that have to be cared about. Thanks a lot in advance. Kind re...more >>

Hallo Zusammen, wo sind denn die ganzen Beiträge hin, sehe hier im Moment nur noch 13 Stück, erinnere mich an Zeiten, wo es weit mehr an einem Tag gab? Viele Grüße Jens...more >>

Hi, I would like to add one more item to RS wishlist: - ability to dynamically switching parameter prompts Example: when userid = Person1 then Parameter1 prompt is ON when userid = Person2 then Parameter1 prompt is OFF TIA, Kamel ...more >>

I'm looking into deploying Reporting Services on a new project. The reports in question would be accessed from the Internet. We have a requirement to separate the HTTP server from the application logic, but all of the RS deployment examples I have seen show the RS server on the same box as t...more >>

Hi Got a problem... Have a report of about 30 pages but in print preview it has 60 pages. How do I control the page breaks, because after every 1 page there is a blank. Thanks! ...more >>

I'm trying to call a report from an aspx page and so far the whole process works good. However, in the <DeviceInfo> XML element the <Toolbar> element was set to false like this: <Toolbar>False</Toolbar> Now I want to see the toolbar in the report so I changed the Toolbar element to True, ...more >>

I'm writing a vb.net winforms app and need to call up reports from SSRS. I also need to pass in secure parameters into the report and I don't want to pass the credentials if I don't have to. I was hoping I could call my own web service where I can pass encrypted data to my web service which ...more >>

I have developed more than 100 reports in SSRS for my company. I see the usage of SSRS growing in the developer community. The one basic thing that Microsoft forgot to give priority is the datepicker for date parameters in the parameters toolbar. I WANT A DATEPICKER FOR DATE PARAMETER SELECT...more >>

Is there any way when rendering reports into PDF, to specify metadata such as Title, Author, Subject and Keywords? And... what about security properties? Allow/Prevent document printing / changing document / extract contents / etc. Regards. ...more >>

Hi folks, We have a report that is emailed to three users (one "To" and two "Cc") at 6:45am every weekday. As of applying SP2 earlier this week, each user is receiving two copies (generated about 2 seconds apart) in their inbox. There's one curious difference between the two emails: One...more >>

Hi, We are using Novell as NOS. However, we would like to implement Reporting Services. At the present moment, we are using mixed mode for our SQL Servers. For RS, should we create two accounts: 1) Payoffice 2) Enquiry on the Report Server and let user to use Browser to view the report ...more >>

Hi All, I need to programatically create a report, and deliver it. I managed to create the report and a schedule. When I call CreateSubcription, it fails (InvalidDataSourceCredentialSettingException is thrown) the message is: "The current action cannot be completed because the user data source...more >>

Please help me! Is there some possibility to add line numbers to a table in Reporting Services??? Can't find it anywhere... Thanks! Armands ...more >>

Within Excel you can create Drop Lines in line graphs, is it possible in the Graph Control in Reporting Services? ...more >>

Same problem here too. I get the first page & then the error on the second page. I also only get the first page when printing & the error at the end. I have checked my IE explorer settings & verified scripting is turned on. Anything else to check? ...more >>

I've got the printer delivery sample compiled and configuration files edited per the sample ReadMe file, but I'm not clear on how to use the printer delivery extension to have the report(s) print. Do you use a report subscription, or what? Thanks very much. ...more >>

I have deployed the sample reports to reporting server. When trying to subscribe to any of the sample reports I get the following error: --------------------------- Microsoft Internet Explorer --------------------------- Subscriptions cannot be created because the credentials used to run the...more >>

Hi, I installed SP1 and have specified an image as External & am using "https"//abc.com/Images"+Fields!LOGO.Value as the exprseeion for getting the image but the iamge is not displaying. The image in the database field LOGO is stored simply as xyz.gif . How acn i display such an image? Am ...more >>

Hi, I get the "Index out of range" error that a lot of people seem to be getting when exporting to Excel. All other formats work fine. I have already read a bunch of the previous posts, including Bryan Bullard's posts where he seems to have resolved the problem. In my case, I have tried ...more >>

When i try to administer my Reporting Services, the following page comes up with the picture of a folder and "Home" http://dev7/Reports/Pages/Folder.aspx How do I administer the Reporting Services enough to at least give myself permissions to administer it?...more >>

WE have locked down our security so that no active x controls can run for our end users. Is there a way to integrate the installing of the print active x control into the startup script? Or does it have to be installed using direct from the report manager? We have looked at the cab file but...more >>

Does anyone know how to create a button or link that would collapse all open groups? I'd like a link/button that would collapse all lower level items. For example if your report looks like this: Level 1 Level 2 Level 3 And the user has it drilleddown all the way...more >>

I use the email feature where you reference a remote SMTP server. It worked previously only for emailing links. It would not email the report. I was hoping this issue would be resolved with SP2 and it did. It works perfectly now. -- Bruce Loehle-Conger MVP SQL Server Reporting Services ...more >>

Hello Now with SP2 the page margins works fine. Exists a method to set the Footer and Header margin in the Excel Rendering Extension? Thanks......more >>

We would like to be able to publish a report to more than 1 directory at the same time. Is this or would this be possible? Currently, we deploy the base report to a central location and create linked reports to all other locations....more >>

I am getting the following error message when previewing or trying to just print using the client side activeX printing control after installing sp2 release: An error occured trying to render the report. (0x800040005) ??? don't have the slightest clue what this could be. I have deleted ...more >>