I have a text box that I'd like to toggle visibility on when a report parameter is null or an empty string... How do I do that...? Thanks! Dan...more >>

here is the deal- i have a bunch of reports to which i need to add a generic caching plan. i know how to do this through the report manager web interface on a per-report-basis. my problem is that i am lazy and don't want to click through every single report individually setting up the cach...more >>

I am experimenting with Report Builder for the first time. I did an upgrade from SQL Server 2000 to 2005. When I first strated trying to post models I created I was getting an error that I didn't have the required permissions. I then found that I needed to create a role with model permission...more >>

Hoping to find some help. In general: I am writing a SQL report and I need to be able to access the report object model from custom code but I don't really see how nor am I finding much data out there on this topic. For example, in Access, one can execute code during each iteration of th...more >>

I've got a report that is pretty simple but for some reason I keep getting the following error when I try to run it: An error occured during local report processing. An error has occured during report processing. Query execution failed for data set "Dataset 1" Must declare the scalar variabl...more >>

Hello, My Report Table contains a Date Field and a numeric Value field. In the Footer row of the table I use the Sum Aggregate function to sum up all the values for all the rows that get displayed =sum(Fields!CountFld.Value) I also have an conditional Expression for the background colo...more >>

We are using SQL Server 2005 SP2. We have setup the RS smtp configuration and we we have created scheduled reports, but we get an error when the report is emailed. If I understand correctly, the account name/password that is used for authentication is the account name used for the SQL Server...more >>

Hi, I am looking into letting users build their own reports. So far, it looks good for most scenarios. However, some of the 'reports' I'd like users to create are forms for our quotes, orders and invoices. I can create these kinds of reports in VS 2005, but I can't in report builder becau...more >>

Greetings, I have a dataset something like this: Loc Value Time A 3 1AM A 8 2AM A 2 3AM A 1 4AM .... B 8 1AM B 1 2AM .... When we collapse the Loc group I want to show the Max vlaue and the time it occurred. What is the expression for the Time column of the table to ensure the ...more >>

Is it possible to use an expression to set the ReportName element of a subreport (say, based on a parameter value)?...more >>

Is it possible to create a folder of reports that do not require a log in to execute? I would like to be able to put specific reports in a open folder so that people can run them without login. Thanks Bob ...more >>

I've created a report that uses a multi-value parameter based on a dataset usign a simple select statement. It works fine when a single value is selected, but when multiple values are selected the report returns the error "Incorrect Syntax near ','. " The query to get the parameter list is...more >>

Hi, I've installed SQL Server Express Edition and Reporting Services on my PC running Windows XP Pro SP2. When I point the browser to localhost \reports I get a "Internet Explorer cannot display web page" page. At home I've been following the excellent video series on the msdn website for SQL...more >>

Hi All, I have two reports and each of them contains 3 sub reports. When I deployed my project, I don't want the users to see the sub reports. I have set Hide in list view = Checked for each of the sub report. After doing this when the users access the reports folder, they do not see the repor...more >>