Grouping data

[scclem]

I am putting together a report that contains data for items listed in a catalog. I would like to show the detail level grouped by each distinct page number. As the next highest level of grouping I need to group two pages together and am having difficulties.

Example:

Group = pages 2 & 3
subgroup = page 2
detail
summary page 2
subgroup = page 3
detail
summary page 3
summary pages 2 & 3

etc.

Any suggestions on how to do the main grouping?

 

[mbarron]

Create the below formula and then group on it. The grouping will be by even pages being first and then the next page.


if remainder({page},2)=0 then "Pages " + totext({page},0,"&quot +" and " + totext({Sheet1.page}+1,0,"&quot else
if remainder({page},2)=1 then "Pages " + totext({page}-1,0,"&quot +" and " + totext({page},0,"&quot

 

[kenhamady]

How about:

Truncate ({page} / 2)

This won't work for display but will group correctly. The display could be anything you like, including:

"Pages " + totext({page},0,"&quot + " and " + totext({Sheet1.page}+1, 0, "&quot
Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB

http://www.kenhamady.com/