Force display on grouping

system · September 25, 2006, 7:57pm

hello all:

I selecting records, and grouping by weekday. If there are no records for a given day, the day, and record will not display.

I would like the day to display with a “0” instead.

Looks like this:

Mon 23
Tue 56
Wed 48
Fri 75
Sun 93

I want it to look like THIS:

Mon 23
Tue 56
Wed 48
Thurs 0
Fri 75
Sat 0
Sun 93

Thanks in advance!

hagnik (BOB member since 2006-08-01)

system · September 25, 2006, 8:03pm

Hi,

please have a look at this BO reporter FAQ

It deals with the months instead of weekdays but you should get the idea how to get what you are after.

Marek Chladny (BOB member since 2003-11-27)

system · September 25, 2006, 8:50pm

Excellent! That was just what I needed.

Much appreciated.

Nick

hagnik (BOB member since 2006-08-01)

system · September 25, 2006, 9:03pm

You are welcome 8)

Marek Chladny (BOB member since 2003-11-27)