What's the best way to display "approved" when a status field is "A",
"pending" when a status field is "P", etc?  Would the SWITCH statement be
best?  If so, what is the syntax for this and where do I put it in my report?
Any suggestions are welcomed.

I have wrote a set of report for a large company, this company has up
to 20 different divisions, all with a seperate sql server and seperate
instances of reporting services.
My single report project needs deployed to all 20 different instances

I have a report with two parameters.  Date1 and date2 and both are of type
datetime.  when I select a date greater than 12/05/2006 the report fails
stating "the value provided for the report parameter Date2 is not valid for
its type".  Now date1 has 01/05/2006 and date2 has ...

Hi,  RS2000 was a separate from SQLServer2000 and a free download, only
requirement being you must have a SQLServer 2000 lic.  For RS 2005 it looks
like its bundled up with SQLServer 2005. Must I purchase SQLServer 2005 in
order to upgrade to RS 2005, we don't wish to upgrade ...

Is there a way to search all of the RDL's that have been deployed out to a
Reporting Services site? I am looking for what stored procedures are being
used on our production reporting site.
Any help would be appreciated.

Has anyone had any luck getting an Avg on Date Diff?  Here's what I'm
trying to do:
Figure out the average time it takes from ringtime (datetime) to
starttime(datetime).  

I have a report that has information in the header that only needs to
print on the first page, as well as info that needs to print on all
pages.  I have successfully been able to make the visibility on the
first section so that it only shows on page 1.

I am putting the client name in my header using ReportItems! reference to
textbox in report - this renders correctly on my server and in pdf however in
excel the client name is not showing up on the report.  There are 2 textboxes
overlapping each other because I have 2 groups and ...

What is the best way to lookup a value in a column from another data set?
I am trying to locate and display the employee name based on the employee id
found in another data set.
I.E.  

I'm using SQL Server 2000 Reporting Services. I want to create a curve using
chart for a series of data.
If the number of points (x axis) is small (less than 800), the curve is
displayed correctly.  

Sometimes my subreport renders fine in the preview environment.  An then
sometimes I simply get the message Error:  Subreport Could Not be Shown.
There is no clue given as to why it cannot be shown.  I just have to do
random things with the layout and hope it shows.

I have an ASPX web form with a WebForms.ReportViewer on it.
I have created a new ReportServerCredentials class form this site
http://blogs.msdn.com/bimusings/archive/2005/11/18/494436.aspx
My code for the report viewer is:

This is really weird. I want to divide Amount by Units to get the average
amount per unit. So I used this:
=IIF(Fields!UnitsBilled.Value = 0, Nothing, Fields!AmountBilled.Value /
Fields!UnitsBilled.Value)

Can I apply validations to the parms in SQL Reporting Services?
Example:
I create a report that has two parameters listed:
FromDate

Can subfolders be added to a project?
i want a few folder like : dashboards, full reports , management
reports etc.
in each folder i would like to store only the relevanr .rdl files and