Hello, I just installed Vault Source Control on my machine. I then opened a Reporting Services project with rdl's in it. Every RDL that is currently in source control opens with this error "Deserialization failed: File or assembly name Microsoft.ReportingServices.Interfaces, or one of i...more >>

I can't get a table to return top n rows. The sorting tab works fine. Can anyone provide a syntax example? Thanks, Dave ...more >>

I require three parameter fields: 1.)Daterange 2.)EndDate 3.)Start Date Selecting an option from the DateRange Parameter (eg. option = today) automatically populates the EndDate and StartDate Fields. I also want to give the user the option to extend the date range to one which is not def...more >>

My report has 9 subreports. When main report has 3 records then this report goes into loop and run these 9 subreports 3 times. But I want the heading in all the pages and should change the data as record changes.. This report can be 30 - 40 pages long. I am giving you an example on my repor...more >>

Microsoft wants to make its Report Definition Language (RDL) an industry standard. how's that going? have other vendors bought into this yet?...more >>

Well I have to implement Mail Merge ...user defined Letters in short... basically like this.. The user can enter any custom letter with Fields we will provide them to put into the letter ...We will them store this in database(right now thinking on storing in HTML format). For eg Letter templ...more >>

On the report table, there are 3 fields called Beginning Amount, Used Amount and Remaining Amount respectively. The Beginning Amount and Used Amount field are retrieved from the SQL database, while the Remaining Amount needs to be calculated from the previous record, e.g, ItemB's RemainingAmou...more >>

I am using the RS web service to generate reports. I know it is possible to generate lists of available reports, together with a list of required parameters for each. But is it possible to get a list of valid values for each parameter via the web service? i.e. retrieve the dataset results that...more >>

I have been getting ready to finally put into my company's Production Environment all the reports I have been developing in our Test Environment. The Test Environment is SQL 2000 Developer Edition, and SRS was installed via the CD that came in the box - I read that it said "For SQL Server 200...more >>

Hi, I did a fresh install on a windows 2003 server. I have IIS installed with the default webiste running. I have SQL Server 2000 installed with service packb3a. I have Hotfix 859 installed as well. When I try to install Reporting Services, I get an error message: "This edition o...more >>

Hi! On thursday last week one of our clients Reporting Services installation stopped working and reports "Key not valid for use in specified state" error message in the log files. This is strange as we have not done any changes to the server. It is running Windows Server 2003 Standard Ed...more >>

I'm trying to figure out how to create a custom series color in a bar chart, and am unable to find documentation on it. I read a post here on trying the Choose() function in the fill color portion of the series value, but my chart goes gray in the layout mode, and then in the preview mode i...more >>

Hi, In configuring the the email extensions for the email subscriptions, we have done the following: Applied SP1 Configured the email extension section of the RSreportingservices.config for the FQDN of the exchange server. Emails are not being sent. Error indicates configuration problem. Wh...more >>

c:\Report1.rdl The underlying connection was closed: An unexpected error occurred on a send. When i deploy I get this error sometimes. It gets resolved on its own. Its like a hit and trial thing, sometimes it runs, sometimes it doesnt. Wonder what am I doing wrong? Thanks ...more >>

Hello, when I call the render method of a ReportService() object with the following... data = rs.Render("/OnlineInvoice", "PDF", Nothing, Nothing, paramaters, Nothing, Nothing, encoding, mimeType, parametersUsed, warnings, streamIds) with the argument paramaters being... Dim paramaters(...more >>

I need to be able to convert a Date-Time Field to a Date Fied in my SQL Tables. Using CONVERT (varchar, "Date-Time Field", 103) gives me the correct result but because it converts the date value to a string I can say goodbye to localization..... any ideas on how to convert the field but s...more >>

Hi all, I have an Email Subscription for a report that includes several email addresses. If even one of the email addresses is wrong or misspelled, noone gets an email. Is there a way to send email to other email addresses when some of the email addresses are wrong? I knwo I can create dif...more >>

To All, I have looked all over to get an answer to the following: I have installed Reporting Services with the latest service pack. When I or any of my customers try to initially load the default page (http://localhost/reports/Pages/Folder.aspx) it will take 20-30 seconds. After the initi...more >>

I have looked all over to get an answer to the following: I have installed Reporting Services with the latest service pack. When I or any of my customers try to initially load the default page (http://localhost/reports/Pages/Folder.aspx) it will take 20-30 seconds. After the initial load it ...more >>

Hi, We have two SQL servers. To generate reports, we need to go to both servers to collect data. The reporting service is installed in server 1. The database connection b/t server 1 and reporting service is fine. However, we couldn't create connection to server 2. When I ran a report ...more >>

I create a report that brings information from an informix database. I have a problem with date parameters when I put them static on query design (with date format mm/dd/yyyy) it retreives information on a good response time. But if I preview report with the option to add date paramaters repor...more >>

I know this question has been asked a zillion times and will be asked again and again but here are some of my outstanding concerns after spending almost half a day browsing this group for answers. I read and followed and deployed the extension available in the September 2004 article in...more >>

Hallo, I have a question about the communications between Reporting Server and SQL server works, when using the drill down funtion: Does the RS requests all the data from the SQL Server at the first time the client opens the report (not expanded in the first step), or not? If the user does...more >>

Hi, I like to see in the generated report what the parameters value are for the current report like startdate and enddate Thanx Wimmo...more >>

Can we design reports using Reporting Services with SQL Server Express?...more >>

Hi, I want to try an evaluation version of Reporting Services 2000, but it requires Visual Studio 2003 which I don't have. I don't see an evaluation version of Visual Studio 2003 anywhere, but a free download of Visual Studio 2005 Express is available. Will Reporting Services 2000 work if I...more >>