Topic: Dynamic grouping Posted: 20 Sep 2007 at 2:04am
Is there any way to change the grouping of a report depending on a value selected in a parameter? I have never done this before so does anyone have any ideas?
Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Posted: 20 Sep 2007 at 7:36am
Yes. Build a formula based upon that parameter and then group on the formula. You can also do the same for dynamic sorting of the group data. I have various examples in Chapter 3 of my new book. You should specifically look at Tutorial 3-7 on page 145.
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>
Basically, I want the user to be able to choose whether they want the report grouped by department or by geographical region. So the parameter will allow them to select either of those choices and then group the report accordingly.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
