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
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