sql server reporting services: Creating a group at run-time -- sql server reporting services

Creating a group at run-time

Matt
1/4/2005 4:05:07 PM

sql server reporting services: I have a request for a report to allow the user to render the output grouped
by start of last name (A's, B's, C's, etc) and have each group print on its
own page. This action would be controlled from a report parameter ideally
and the user would be able to toggle from normal output to this grouped
style. Creating a new group on the first character of the last name and
setting Page Break after was easy. The problem that I am having is how to
enforce the toggling of styles. The Visibility property of the group doesn't
appear to do what I want. Can groups be created at run-time? What is the
best way to achieve what I am after?

Re: Creating a group at run-time

Robert Bruckner [MSFT]
1/15/2005 6:16:27 PM

Please check this article about dynamically changing groupings in a report:
http://blogs.msdn.com/chrishays/archive/2004/07/15/184646.aspx

In your particular situation, you would want to group on the first character
of the last name or group on a constant value in the other case (read step 3
in the article carefully).

--
This posting is provided "AS IS" with no warranties, and confers no rights.

[quoted text, click to view]