tags:

views:

15

answers:

1
Q: 

Microsoft Reporting Services 2008- Multi-Value Parameter- New Page

I am creating a report where the parameter selection = customer_name and the report is one page and has 5 tablix relating to the customer. What my team would like is to be able to select more than one customer at a time to save time; however they want a separate page per customer_name. Can this be done with multi-value parameter and if so, how do I group so that the data does not comingle with each other?

Ex. ABC Customer RentTablix ExpenseTablix PAGE BREAK EFG Customer RentTablix ExpenseTablix

I am over thinking this??? Please help ;-)

A: 

On the report parameter enable the multi-select option. Pass this through to your reporting procs ensuring it's handled properly (I think it's a comma seperated list). In the report add a list control and put all the tablix control into the list area. Set the grouping on the list region to be base on customer and specify a page break on change of customer in the list control.

SPE109  2010-07-02 22:57:12
I will give this a try ;-)
Lissa  2010-07-06 12:42:49

related questions

How do I include empty rows in a single GROUP BY DAY(date_field) SQL query?
Complex join with nested group-by/having clause?
Using Linqdatasource and groupby property
How can I read LINQ group by Query?
SQL "group by" question - I can't select every column
Table Group By - Tsql -
MySQL - Control which row is returned by a group by.
Optmizing MySQL GROUP BY or DISTINCT on large views
How to get list of values in GROUP_BY clause?
SQL select nth member of group
How to lambda the group by data on a LINQ to Sql results?
MSSQL: Only last entry in GROUP BY
MySQL Query - getting missing records when using group-by
sql group by versus distinct
Grouping List by the last Char
Why does SQL force me to repeat all non-aggregated fields from my SELECT clause in my GROUP BY clause?
SQL group by date, but get dates w/o records too
MySQL finding subtotals
SQL expression problem
C# List<> GroupBy 2 Values
How would I calculate timespans from a list of check in and check outs?
"Most popular" GROUP BY in LINQ?
How do I return my records grouped by NULL and NOT NULL?
How to concatenate strings of a string field in a PostgreSQL 'group by' query?
How do I use T-SQL Group By