How to Pass Multi-Valued Parameters to another Report

Right click the cell you want to use to go to the other report

Select Text Box Properties

Select Action

Select Go to report

Specify a report and select the one you created that you want to go to.

Note:

The report you are going to needs to have the same settings as the parameters on the main report.

on the Go to report create the parameter with the same name as the main report

make it the parameter multi-valued

create a DISTINCT list data set for the multi-valued parameter to select from

i.e. SELECT DISTINCT COMCDE_01 FROM [TABLE OR VIEW NAME]

I also trimmed it to make it look better in the parameter drop down.

i.e. SELECT DISTINCT RTRIM(COMCDE_01) AS COMCCDE_02 FROM [TABLE OR VIEW NAME]

add the SQL IN statement in the Where cause i.e. WHERE COMCDE_01 IN (@COMCDE)

----

Click the Add buttom

the drop down will pickup the parameter from the Go to report

Click the Fx

Use =Split(Join(Parameters!COMCDE.Value, ","), ",") expression to create the multi-value parameter list that the Go to report will use.

Click OK

I had to set it up like this to make it work right for my DB

Hope this helps,

Vincent Stefanetti

Simple SQL Update with Join and Where Exists

UPDATE Part_Master
SET RECVEN_01 = VENID_10
from Part_Master as P INNER join Order_Master as O ON P.PRTNUM_01 = O.PRTNUM_10
WHERE EXISTS
(SELECT PRTNUM_10, VENID_10
FROM Part_Master as P join Order_Master as O ON P.PRTNUM_01 = O.PRTNUM_10
WHERE TYPE_01 = 'B' OR TYPE_01 = 'O'
GROUP BY PRTNUM_10, VENID_10)

Passing Parameters to a Drill Down that are not in the Report Item

Click Series Properties - Action - fx - under Category select Parameters and select the parameter value

SRS 2008 Gauges and Chart Guide

 

 

Adding Custom Color Palette to Your Reporting Services Charts - Concise

1) Click Chart Area

2) Click Custom Palette Colors
3) If you have prior added custom colors anywhere in the project you can then select them here or create them and add them to the custom palette.
4) Select Custom under "Palette" beneath the NoDataMessage property and you have your sutom set for the chart.

Reporting Technology and Efficiency

All good decisions are based on good data evaluation - if you do not have data you can not evaluate. Thus it is of key importance that one have data and be able to distiguish between useless data and good data. The important thing to know when providing information is "is it useful" - "does it facilitate action, correction and benefit production". So, if you are going to venture into the realm of data provision you better be familair with the area you are evaluating and make sure that the data you are providing is of use. Reporting Services and data analysis are only as useful as they can be applied and used - thus one needs familiarity - provide data in timely fashion - best real-time - or distributed so that those that need the data get the best use from it.

Samples

Some MS SQL Reporting Services Samples