I am rendering reports using SQL reporting services. I would like a report rendered with a hyperlink/action button that would contain an ID value that will be used in rendering a new page....ie. I need to pass a row ID. How can this be done?...more >>

When I access the report from the localhost (Which holds the SQL & IIS Server for Reporting Services) - I can see everything. However, if I go to another machine and access the "reports" - I can see the report manager, the folder, everything - until you click on the report - then in the "repo...more >>

We are wanting to utilize the tables in ReportServer and ReportServerTempDB, but do not want write any code that is dependent on the current version (i.e. RS 2005) of the tables in SRS. Does anyone know if MS has provided us with some data abstraction classes over the tables beyond the stored...more >>

Hello, Our users run the report by clicking View Report button and print the report by clicking print icon. The problem is margin is always coming with 1” in all side and they have to change it to 0.5” for all sides each time they want to print. Is there any way I can set it for 0.5” as...more >>

Hi there, I'm looking for the correct syntax for using datetime parameters in the SQL statement. The parameter is called ReceiveDate and defaults to =Today() ="select ........ where creationdate = "&...... Thanks Ludo ...more >>

Hi, Are you planning a SP3 release for Reporting Services for SQL Server 2000? (I expect that it'll take most of my clients, at least several months before migrating to SQL Server 2005) -- Regards Antonio...more >>

I have a chart that has MM/YYYY for tics on the X-axis. The problem is that January and October are being positioned next to each other... 1/2005...10/2005...2/2005...3/2005 Is there any way to tell the chart to order these by date rather than by string value?...more >>

In my report I need footer with fixed lenght anchored to a bottom. The problem is what I need some dynamic fields (report values) in footer. How can I manage this? ...more >>

Is there a way to suppress the execution of an email if a subscription runs a report that returns no data? I am not yet on 2005 if that makes a difference....more >>

Can SQL Server 2005 Express Edition be set up on a local PC to work with RDL files? In other words, will there be a way to install and set up reporting services with Express? Thanks! Michael...more >>

My company uses Reporting Services and is looking at future upgrades of our development and server software. What we need to know is how backwards and forwards compatible the new VS dev environment and SQL Server are expected to be. Will it be possible to create/maintain Reporting Services...more >>

How should I resolve the following error? ERROR: [rsInvalidReportParameterDependency] The report parameter ‘Company’ has a DefaultValue or a ValidValue that depends on the report parameter “Company”. Forward dependencies are not valid. ...more >>

How do I resolve the following error message? ERROR: [rsMissingDataSetName] The data set name is missing in the data region ‘DataSetName’....more >>

How can you tell what version of Reporting Services is installed?...more >>

Has anyone written a conditional statement to change a gridline value at a specific value? =iif(???=90, "Red","Silver") Any advise is apreciated. Thanks, Scott A. Baker ...more >>

So I am having a problem with toggles and frames, namely, they don't work. I have embedded the RS viewer in a set of frames and use RC:LinkTarget to control any frame jumping but Toggles (to collapse and expand data) don't work in that frame. The reading I've done suggests that it's an issue wit...more >>

Hi I am having rtf stuff in database. I need to display it in the Report. Is ther any way to render rtf text in the report or Is there any way to remove rtf stuff and just display plain text. I Tried to use RichTextBox object of System.Windows.Forms.dll. It worked well in design time prev...more >>

I have prepared a report by using report builder. And I want that user can change filter, group, and sort property of this report template when running report. How can it possible?...more >>