customize groupname printing 1

[ridhirao22]

Using CR2008

Working on report where I am group by date field for weekly totals. I would like to rename the group name in the group footer as “Weekly Total(weekstart MM/DD-MM/DD weekending)

For example:

05/15/11
05/16/11
05/17/11
05/18/11
05/19/11
05/20/11
05/21/11
Weekly Total (05/08-05/21)

Any help is appreciated;

TIA,
RR

 

[hilfy]

For your week group, use summaries to get the min and max of the date values in the group. Then use those values to create your label.

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.

 

[lbass]

You could use:

"Weekly Total ("+
totext({table.date}-dayofweek({table.date})+1,"MM/dd")+"-"+
totext({table.date}-dayofweek({table.date})+7,"MM/dd")+")"

-LB

 

[ridhirao22]

Thank you! Dell and LB.

For the above example I am showing. I am grouping same date field twice -once for each day and and once for each week.

Could I group date only once and still sort the date sin order as date and do weekly totals. Just curious

Hope I could explain it better.

TIA,
RR

 

[lbass]

Yes, you probably do not need the inner group on date. Just sort on date, if you want it in a certain order. The formula I gave you is not dependent on the records within the group, as long as there is at least one record in the week group.

-LB