how to supress repeating elements?

[voirin]

Hi I have a report that is generated in tabular form. I want to get of repeating row elements. Take for example a weekly diet plan. Each row of the report represents a row of data based on data contained between linked tables. In the examples below i am using three columns: Day of week, time, and food.

Now, instead of displaying:

---------------------------
Monday 7pm Steak
---------------------------
Monday 7pm Potatoes
---------------------------
Monday 7pm Curry
---------------------------
Tuesday 6pm Turkey
---------------------------
Tuesday 6pm Cheese
---------------------------

I want the following displayed:

---------------------------
Monday 7pm Steak
Potatoes
Curry
---------------------------
Tuesday 6pm Turkey
Cheese
---------------------------

where the '---' represents an inserted line.

Is it possible to create a report like this?

Any help most appreciated!

cheers, voirin

 

[MisterMo]

Right click on the date fields>FormatFiled>Common Tab

Check the box that say Suppress if Duplicate

Mo

 

[Madawc]

'Suppress if Duplicate' will get rid of the repeated date/times. For the line between, you could group by date/time and put the line in the group footer.

Madawc Williams (East Anglia, UK)

 

[MisterMo]

It does Help if read the whole question first... Doh

Mo