Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

One Dataset populating multiple Reports Expand / Collapse
Author
Message
Posted Monday, April 22, 2013 4:23 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, May 7, 2013 3:30 AM
Points: 62, Visits: 155
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
Post #1444916
Posted Monday, April 22, 2013 10:27 AM
UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Yesterday @ 2:29 PM
Points: 1,480, Visits: 1,031
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.
Post #1445061
Posted Tuesday, April 23, 2013 1:50 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, May 7, 2013 3:30 AM
Points: 62, Visits: 155
Thanks Ray, all sorted now.
Post #1445303
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse