Creating groups at run-time

Question

Creating groups at run-time

SSC Eights!

Points: 948

January 12, 2005 at 2:22 pm

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?Thanks

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Aiwa SSC Veteran Points: 201 More actions · Answer 1

Hi,

We use this kind of functionality a lot. This should get you started:

1- Edit your Group

2 - In the Group On option you should have something like this:

=iif( Parameters!ReportGrouping.Value = 1, "What ever you did to retreive the first character of the last name","")

Where the ReportGrouping Parameter VALUE 0 = "No grouping"

VALUE 1 = "First character of last name"

I actually have reports running with multiple grouping options.

HTH,

Eric

JSM-257162 SSC Rookie Points: 46 More actions · Answer 2

Hi Eric,

I'm a real newbie at RS, can you explain how you have your parameters set up to allow for flexible grouping? For example, I need to allow users to chose between the following grouping options: Item, Station, Area or Zone (with Item being the default grouping if the user doesn't modify the group setting).

I appreciate your help,

Jacque

ofir shoval Ten Centuries Points: 1278 More actions · Answer 3

U can C a discussion about it in this forum:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=150&messageid=203010#bm203036