Create Page Header or Group Header based on Detail 1

[rewob65]

From my database I have a list of dates. Such as:-

1 Jan
2 Jan
6 Jan
9 Jan

I am able to pull each date into colums using if then functions however I want to set up either a group header or page header with these dates, which could change depending on other factors. I use crystal 8.5.

Thanks

 

[lbass]

You could insert a crosstab, using date as the column, in a group header.

-LB

 

[Madawc]

rewob65, I'm not sure what you want. You can use a formula field to group several dates together, e.g.

if {Your.date} >= currentdate-10 then "a) Recent"
else if {Your.date} >= currentdate-40 then "b) Older"
else "c) Past"

Crystal will also offer you choices of date-ranges if you group by a date.

Does this help?

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[rewob65]

The cross tabs works well, Can I format out the lines on the cross tab as well as the summary data. while the info is spot on it is not pleasing to the eye even for someone who is poor on presentation.

David

 

[lbass]

Go to the customize style tab and check suppress row totals and suppress column totals. Then go to format grid and uncheck "show grid".

-LB