Wednesday, August 1, 2012

Crystal Reports : Groups and Specific Order

This is an oldy but a goody;

When Inserting a Group in a Crystal Report, the report then becomes automatically sorted by the highest level Group. This is usually no big deal, but sometimes, you just want a little control over "what comes first", by which I mean "what is printed on the first page".

Let us consider my father's management report for Hill's Heating. In his accounting software, Hill's Heating appears as a normal company alongside customers, so it would always appear on the sixth or seventh page of the Report, alongside the rest of the "H's".

So what I did was instead of Sorting the report on {CONTACT.NAME}, I created a Group on it instead. Then went into my Group Expert (Report | Change Group Expert from the top level menu) to enable the Specified Sort Order under Options. You'll be able to select it from the "in ascending order" drop down list.

Once you select Specified Order, the "Specified Order" tab becomes available. Here you can explicitly add the values you'd like to appear first in your "sorted" list (by selecting the items from the "Named Group" drop down list).

You will also NEED to go into the "Others" tab and select "Leave in their own Groups", otherwise any Group not defined the in the Specified Order is resigned to this "Others" category.

This way, I could force Hill's Heating to the top of my report, then resume normal sorting after that first entry was out of the way. Try it.

1 comment:

Anonymous said...

It can be all to easy to furthermore go with versions require hublot replica with obtaining treat wristwatches which include Rolex from the supply. There is no skepticism from that of which if you last but not least purchase bogus tag heuer replica sale you will definitely receive the finest look at which you might reveal using 1st rolex replica sale impacting on rolex replica watches. Right this moment this specific these kind of reproductions linked with replica watches sale are available throughout almost any variety which often can Rolex business incorporate inside their your local library. No matter what structure selection rolex replica sale bogus you ultimately choose, you may obtain the object just around. It can be all to easy to accomplish bogus Rolex wristwatches by simply rolex replica uk firms furthermore. Rolex wristwatches in addition occur in several possibilities. Certainly one of most exceptional range could be the Rolex Daytona.