Never tried that but I don't think it...

Martin,

There is not a way to do what you want in SSRS 2000 or 2005 (not sure on 2008). You'll need to create a second version of your report...

I doubt it. If you're running the standard or better edition you should have it. We've always run the standard version.

I'm not the database or network guy here...

I'm sorry my friend but the books and BOL are not wrong. There are four image options.

We no longer run SSRS2000, having upgraded to 2005 however, I know for...

John,

This query of the ReportServer database on your server should get you started:

select DISTINCT

c.name as ItemName,

Rolename AS 'Role',

u.username AS 'User',

CASE c.type WHEN 1 THEN 'Folder' ELSE 'Report'...

John,

First, make sure of your spelling. Hopefully you have "silver" and not "sliver" in your actual expression.

Second, make sure you have the expression in the background color property for...

Peter,

Try this:

1. Create a calculated field called PosQty as

=IIF(Fields!ADJUST_QTY.Value > 0, Fields!ADJUST_QTY.Value,0)

2. Create a second calculated field called PosCost as

= IIF(IIF(Fields!ADJUST_QTY.Value > 0, Fields!ASTD_TOTAL_COST.Value,0)

3. For...

Can you share your IIF expression? And the error message and/or result you're getting when you attempt to sum the Value column.

Depending on what you've written or are getting...

There is a LIKE VB operator so you should be able to use that. Take a look here: http://msdn.microsoft.com/en-us/library/swf8kaxw(VS.71).aspx

Here's what I'd try.

Set up a first parameter that selects either Dept. or Location. Trigger the Dept. or Location parameters from that.

HTH

What you've run into is not necessarily an SSRS issue although it manifests itself there a lot. Especially when using IIF to catch divide by zero conditions.

The problem is...

Documentation for SWITCH() is here

http://msdn.microsoft.com/en-us/library/dft2z9yf(VS.71).aspx

VB functions in general here

http://msdn.microsoft.com/en-us/library/32s6akha(VS.71).aspx

Happy hunting!! 😀

Read the very last entry in this thread.

http://groups.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_thread/thread/ced46d3319ec0854

John,

Try using SWITCH(). It looks at pairs of comma delimited conditions (first half of pair is check condition, second half is true result) and selects the result based on...

YVW