persnickety

That will work, but it will be several additional steps for every report you develop vs. a template.

Rather than use a text based query with EXEC spname, just set the dataset to use a stored procedure directly. There is an option in the dataset dialog box...

ByronOne (3/6/2012)

---

Hi everyone

I have the following SWITCH function in my report:

=Switch(Fields!Result.Value >=92, "Green", Fields!Result.Value >=82 <92, "Yellow", Fields!Result.Value <82, "Red")

I've noticed that in most cases it works ok but sometimes...

I built and use a report template for all my reports that includes all the components I want in each report: logo, report title, parameter listing, report path, runtime, and...

Basically I do it exactly the same as you already have, but....

After I have 2 columns, I cut the data from the outer group and then put that data for...

You need to set up your Columns parameter to depend upon the Project Title parameter

Basically in the Columns parameter you create your query with a where clause that is fed...

Belgrade

upgrade

When doing row groups I usually build the detail section of the report. Next I right click on the left edge (Gray area) of the row and say add...

SSD

storm

harebrained

Hike

The SSIS expression builder is not SQL, so first off I don't think Stuff will work. If it does, you need double " quotes not single ' quotes in...