Check the Hide in List view box.

Vandy,

You need to add WHERE clauses to your 2nd and 3rd data sets.  For example - if the parameter for the first pick is @ProductManager then the query for the...

Tracy,

It is possible to conditionally hide rows based on their contents.

Select the row you wish to hide / not hide and then go to the Properties area.  Under the Visibility property click the...

Syed,

This from MS Books on Line.

=Join(Parameters!Title.Value, ", "))

Provides a comma delimeted list of the selected values.  You could also use .Label if the values aren't user friendly.

Mike

Kerrie,

Your code looks reasonable.  I'd comment out the date test and see what the query produces without it, to eliminate the possibility the problem is elsewhere.  Also, you can shorten...

if @var in (@paramlist)  This will work if you place your query in the report as text, but not in a procedure.

Mike

Toni

You need to make the calculated dates 'dependant' on the date entered by the user. 

Instead of:

SELECT CONVERT(char(11), MAX(src_date)) AS src_date_cur

, CONVERT(char(11), dateadd(mm,-1, MAX(src_date))) AS src_date_pre

FROM tbl_src_date

Try

SELECT dateadd(mm,-1,@UserEnteredDate) as ....

Make...

Jon

Pass the parameter just like you would any other.  Procedure needs to define the value as varchar, as it's simply a comma delimited string.  Trick is to parse this string...

My dilema, at least as I see it, is that the parent report has the page footer spoken for.  I could add a second table to the body, but then...

Senthil,

May not be the most efficient but should work for you.  It will report each date in the range whether there were registrations / cancellations or not.

Mike

DECLARE

    @startdate     ...

Ramon,

Assuming that any given customer can have any number of invoices I'd try this.

=Iif(RunningValue(Fields!CustomerID.Value,

countdistinct,nothing) mod 2,"Blue",