crystal reports repeating groups

[jasonseay]

i have a daily report that shows everything that came in on trains all day long (at the top of the report).

below that i have what came in on a specific train.

if there is more than one train in a day then i need this group to repeat.

how can i do this

[jasonseay]

Sorry not enough info

 

i have the report connected to a dataset.

the dataset is reading from 2 different tables.

the data at the top of the report is from one table

called daily

the data in the group is from a table called trains.

the sql statement that is loaded into the dataset looks like this:

 

select daily.*,Trains.* where daily.datestamp = '11/02/2003' and trains.datestamp = daily.datestamp

 

 

 

when this comes back with data there are two rows, both have the daily values in them and the trains data is different for the two trains.

how can i get this to group them so that the train data is grouped by the daily info.

 

or is there a better way to do this

 

Please help

[jasonseay]

i got it

 

the report was working correctly i just didn't have enough room at the bottom of the report to fit another group so i closed it in and the second group showed up on the page.

thanks for the views though.