You might want to consider SSRS Security extensions. I see them mentioned in your article link.

A lot of people in this situation also use ASP.Net as the external...

I think if you add a column to your dataset of Calls * AvgTalkTime you should be able to work out the rest of the formula in SSRS.

Cut, as in cut and paste.

Cut or delete the data from the text box of the outer group, and paste it in the outer group row level immediately above the...

Daylight saving time.

The catalog table would probably get you there, but you will have to do a fair amount of XML shredding.

I am not totally clear on your table or column structure, but here is a stab at it

SELECT A.BLDGCODE, B.BLDGDESC, A.USABLE

...

Make your query a stored procedure.

Calvo's suggestion should work.

Switch does not have a functional ELSE, it is always boolean expression, value, boolean expression, value, boolean expression, value and so on. The switch statement will...

It looks like you are trying to separate the leading number from the rest of the data. If so, try this.

SUBSTRING( YourFieldDataHere, 2, FINDSTRING( YourFieldDateHere, ")", 1) -2)

appetite

Learned something today, thanks.

Just do a COUNT of one of the values that is on every row, and that will tell you how many rows are on the report.

The SSIS built in SCD transormation is not very good. I actually had a developer on the SSIS team tell me to never use it. You would be...

There are 2 places you can look.

First would be the ExecutionLog view in the reporting services database.

The second, and I find generally more helpful, is to review the trace files....

neck