I am working on a report which uses a multi value input parameter. The value set is depend on the other input parameter, so the size and value are different when the value of the other parameter has changed. The problem is sometime it works perfectly, but the other time when there are only t...more >>

Hi, I'am running reporting services 2000 and I'am having a problem with e-mail subscriptions. Here the low down. My reports run without any problems but when I click on new subscription the only option available is Report server file share. There's no option for E-mail. At one point I wa...more >>

I'm using SSRS 2005. I have a pretty simple report: it's a table with an optional date parameter. I have one column designated to allow interactive sort. When testing the report everything works fine. When I change the report execution to snapshot, the interactive sort no longer works. The ic...more >>

I need to save 2 copies of the same subscription via the file share method. Is there a simple way of doing this without programming. The goal is to have one subscription run and sit on an ftp site and then the other one be an archived copy of the same file. Thanks. Michael...more >>

How can you widen or shorten a column's width when the report is run? The width doesn't allow custom code or expressions. Basically, based on a parameter I pass in, I want to widen or shrink a column's width....more >>

Can reporting service 2000 do combo chart (column and line) with two y-axis? ...more >>

Hello everybody, I´m having the follow problem: I have a reporte that has a parameter, ok! If i open the report in the server itself, it works very well, but if i try to get a report througth network (from other pc) the report ask me for the parameter. Anybody knows what is happening...more >>

Hello, I have a winform c# application that I am building. It is actually a port of an existing access application. I am creating this new application using Sql Server instead of the original access mdb files. In the past I have always created my reports using Crystal reports, however ...more >>

Hi all. I am implementing a few servers with SQL Server 2000 Reporting Services for our CRM 3.0 implementations. Each CRM server runs a local install of SRS, and they all connect to one of our test SQL servers. Everything used to work. (We currently have two development servers and were trying t...more >>

I have a situation that I hope someone can give me a good answer to. Please bear with me as I try to explain my needs. My goal is to have an Excel spreadsheet that pulls from a SQL database and the the query pulls from a variable in the Excel sheet. For example let's say I am pulling Sale...more >>

I have the following set up installed 1. IIS1 server with Reporting Services. 2. IIS2 server with Reporting Services 3. Access Db on a third machine. I have created some simple reports in Reporting Services which connect to the Access Db. I can run this reports from the Report Manager if I...more >>

HI y'all. PROBLEM. Would like to change row color based on a calculated field. I.E. need the row to highlight when an expiration date is within 14 days of expiring. I can use the row expression panel to alternate row color, but cant quite find the magic to make it happen with data as t...more >>

How can I add a custom value in a textbox. For example, I would like to add a footer with a page number, date and the name of the user who's running the report....more >>

How can I add a company logo to the heading of my report. ...more >>

How can I access recordsets from Stored Procedures and/or views instead of tables from the database. I need to limit the amount of data a user can access but the only entities showing up in the Explorer are tables....more >>

Here are the requirements. This is a very small project, I hope you can help. I have a local application (not using the Reporting Services Server to deploy reports). I have a report with multiple parameters. I would like to display the parameters in the normal parameter display in RS. I ne...more >>

I would like to have this matrix format: JAN-06 FEB-06 .... Total Sales Dept 100 120 220 Team One 60 70 130 Emp A 30 35 ...more >>

Do the MVP's and MS Support people ever answer the questions posted here? Is there a technical support line for microsoft reporting services that's free for licensed users? All the other reporting products provide technical phone support for free for their users. But Microsoft doesn't seem to...more >>

what's the diff between 'allow null value' and 'allow blank value'? if I have a parameter with 'allow null value' and 'allow blank value' selected, does that mean that I can run the report without having to enter a value for that parameter? I have a report that has 3 fields: 1) region 2) sto...more >>

I have installed SSRS 2000 and then gone through the process of moving the virtual directories so that http://<server>/reports/pages/ has become http://reports.<mydomain>/reports/pages/ ... an now I get the following when I navigate to http://reports.<mydomain>/reports/pages/ The reques...more >>

When we try to install reporting services we get a message 'Terminal Services are installed in Server mode that is not supported by Reporting Services setup. Switch to Terminal Services Remote Administration mode for the time of installation' I have looked a the help but cannot see where a...more >>

I have a sales quotes report and want the report to run for quotes entered 2 working days ago. I have used a default date-time parameter in the past to do something similar for another report. I will be running the report daily and elivering by subscrition, so the parameter needs to be part of t...more >>

Hi all, I have a matrix in my report (document downloads) with two groups, a horizontal subtotal and a vertical subtotal: Doc Section Jan06 Feb06 Mar06 Total =================================== Doc1 A 1 4 2 7 Doc2 B 2 5 ...more >>

I installed Reporting Services 2000 in a VMWare virtual machine (running Win XP Pro SP2), and everything worked just fine. Inside the VM, I fired up the Report Manager (going to http://localhost/Reports/....) and everything seemed fine. Couldn't access reports from outside (the "host" compu...more >>

Hi, Can anyone tell me if it is possibe to produce a single PDF file from two seperate reports. Each report has it's own data source, headers, footers and detail. Many thanks, Simon. ...more >>