Hi, I an trying to install Reporting Service 2000 on my machine, it has Windows XP with SP1, SQL 2000 Developer edition with SP3a, Visual Studio.Net 2003. This is the first time I try Reporting Services, I am going to make my machine a Report Server and for reports authoring. However durin...more >>

Hi, I came across a problem with master detail regions: I have two data sets in my report ( MasterDS and DetailDS) The report layout items are within a free form list region and MasterDS is the list's data source. I also have a table region with the main list region. I defi...more >>

I successfully use the code below to output a report to a web page or to a PDF file (which opens in Acrobat Reader) but when I try to create an Excel file, it looks like the result is the binary for an Excel file being displayed in a HTML page. Where can I get informarion on how to modify the ...more >>

I am fairly new to MS report services. Through Profiler I've found that the report service is constantly calling procedures in the ReportServer database; procedures like GetMyRunningJobs and updates to the Notifications table. I don't have any scheduled reports. If users need reports, they h...more >>

Two crystal reports developers are about to join me writing reports for Reporting Services. Neither has used RS before and I don't believe either has ever used Visual Studio. I am concerned about what will happen when they build/deploy a project. Will we end up with multiple unwanted fold...more >>

Hey guys, I have a problem where I just can't find a solution. I have a report with several parameters. To speed up reporting I create a couple of snapshots with variations in parameters. When I access this report by URL with certain parameters set, I get the following error: The report ...more >>

Here is a very funny problem and I searched, tried every method and cannot figure this out. Problem: If my field has carriage returns at the start and then some text and then again carriage return, the HTML shows fine but when exported to PDF start Carriage returns are not displayed. Exa...more >>

Is it possible to implement some code somewhere that allows a user to click a button and send an e-mail to a predefined address (and server)? I know I can do this through a data-driven subscription and also through a regular subscription, but I'd like people to pull up one of our reports for a s...more >>

What is the best / recommended setup for a development system where you want to develop using .NET 2.0 using VS 2005 against both SSRS 2000 and SSRS 2005? ...more >>

1) Is it possible to run RS 2005 Express Edition against data stored in MySQL or PostgresSql? 2) Is it possible to read/write data to SQL 2005 using .NET Framework 1.1? Thanks, ...more >>

Hello I am using Reporting Services within Visual Studio .Net 2003, connecting to a SQL Server 2000 database. I am having an intermittent problem with a report misbehaving. The report has 5 subreports, all of which work fine on their own (for the most part). The problem is that, sometimes,...more >>

Hey everyone, does anyonw know how to output a report directly to PDF? That is, without passing any parameters, but defaulted in the report itslef. So a user would not have a choice to view it in the report manager? ...more >>

Hello guys, I'm quite new to reporting services. My Question is, how can I do this using Reporting Services? Q. How can I preview the report (i know MS supplies a sample 'report previewer'). But, I have to do this WITHOUT PUBLISHING this report on to the server. i.e., I just want to us...more >>

I'm trying to create a mailto link with muliple email addresses like "mailto:name@email1.com;name2@email2.com;name3@email3.com" and cannot get it working. any ideas on how to get this working? Thanks ...more >>

Is it possible to do hyperlink in reports? say I have a Matrix report, when the user clicks on the specific item, it drills down to the detail page. Is it possible? ...more >>

I'm about to deploy reporting services and was wondering what the best approach would be to set it up. I have 2 machines available, both a database server and a webserver. Is it best to install everything on the database server, or just the data store, and run the report server and manger on m...more >>

Hi, I have an internet app via VS.Net 2003, ASP.Net, VB.Net, and SQL Server 2000. I want to add reports to it via Report Services. I have successfully created a very minimal report within VS.Net and I have been able to view it through the Preview and also by Debug, Start without Debugging. ...more >>

I have been fighting this for several days now and it is REALLY beginning to irritate the crap out of me. Configuration is as follows: Win2k3 server SP1 SPS 2003 SP1 SQL server is remote Using the Network Service account to run the Report Server service Using windows integrated for DB acces...more >>

Hi, I get an error when I try to open my Report Builder reports with a ReportViewer control inside my windows app. The error I get is: "Remote GDI stream version: 10.0.1. Expected version: 9.0.931. Input string was not in a correct format" But I have no problem to open my Report Builder r...more >>

What Value is passed by a Parameter Dropdown when it's not selected? I have a Stored Procedure that has 6 parameters that 3 of them can be left blank. Needless to say the report won't work, because I'm prompted to select something. Is there a way to leave the dropdown blank? ...more >>

how to solve it? thanks ...more >>