This is a migrated thread and some comments may be shown as answers.

Master-detail crosstab

1 Answer 116 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Maxime Gaudreault Proulx
Top achievements
Rank 1
Maxime Gaudreault Proulx asked on 28 Apr 2011, 08:57 PM
Hello, I'm trying to do a master-detail kind of report. I have tried to put my data in a crosstab, but the detail cell only shows me the first entry for every group, instead of showing a list of entries. 

I am trying to do some kind of schedule, having a row grouping on the resources and a column group on the date. Since a resource can do multiple jobs in a day, in the detail cell I would like to show a list of those jobs. 

For example: 
Data: 
Entry1:  Resource1 Day1 Activity1
Entry2:  Resource1 Day2 DayOff
Entry3:  Resource1 Day1 Activity2
Entry4:  Resource2 Day1 Activity1
Entry5:  Resource2 Day2 Activity2

Output: 
Day1 Day2
Resource1 Activity1 DayOff
Activity2
Resource2 Activity1 Activity2

I have tried multiple things, but none did exactly what I need: 
 - Create a child Detail row group on the resource group, but that doesn't work because it puts me every activity as a unique entry, like this: 
Day1 Day2
Resource1 Activity1
Activity2
DayOff
Resource2 Activity1
Activity2

 - Put a table or list in my detail cell, but I am not able to bind its data source to its parent's grouped data (ex. for Resource1, Day1). 

Has anybody ever tried to do such report? 
Can you help me? 

Thanks

1 Answer, 1 is accepted

Sort by
0
Squall
Top achievements
Rank 1
answered on 04 May 2011, 09:48 AM
Hi, 
Have you tried the Bindings? I have used them a few times to bind a table to report datasource collection. In my report.datasource I have  Field.Clients that is a collection and I have bound Table.DataSource to the =Field.Clients.
SN
Tags
General Discussions
Asked by
Maxime Gaudreault Proulx
Top achievements
Rank 1
Answers by
Squall
Top achievements
Rank 1
Share this question
or