One Dataset populating multiple Reports

• wafw1971

  SSC Eights!

  Points: 976

  More actions

  April 22, 2013 at 4:23 am

  #273188

  Good Morning

  I have a stack of data and I want to be able to create a single report, this report will have two parameters one is 'date' and the other is 'place' once these are selected then a report will show me the following results:

  1st Report:

  Time:14:10

  Person 1

  Person 2

  Person 3

  2nd Report:

  Time 14:30

  Person 1

  Person 2

  Person 3

  3rd Report

  Time 14:50

  Person 1

  Person 2

  Person 3

  I have tried list boxes and all I get is Person 1, 3 times and person 2, three times etc but I need to separate them out. can it be done?

  Thanks

  Wayne

• Ray M

  SSC-Insane

  Points: 21093

  More actions

  April 22, 2013 at 10:27 am

  #1608754

  What does your dataset look like?

  If it returns each Multiple times with different dates. Then Use a table.

  Create a group on Date, and put the person in the detail rows.

• wafw1971

  SSC Eights!

  Points: 976

  More actions

  April 23, 2013 at 1:50 am

  #1608962

  Thanks Ray, all sorted now.