Crossing Data

[victorinable]

Hi,

I would like to create a Cross-tab that should be getting data from 2 Different Datasets. One of them have diferent periods (Lets say, register per month with start/end date. The other has data that has a column with start/end active date and the building where they are located (It contains data from employees). So the final result is the sum of people in each building per period.

So I can't relate them to create a single table and then do a simple cross-tab. The excel-based report is attached in the post, can you please give me any clue on how to achieve that result?

Attach_report.PNG (20.79 KiB) Viewed 2406 times

Periods and buildings can vary.

Thanks in advance.

[Alex K.]

Hello,

As a way, you can try to use the Cross-Data band components with master-detail construction for your task.

Thank you.

[victorinable]

Hi Aleksey,

I've been trying to do this but no succeed on this task. There's somewhere any example using Cross-Data bands??

Thanks.

[Alex K.]

Hello,

Unfortunately, there are not any samples with Cross-Data component, this component used in specific situations.

Thank you.

[victorinable]

Hi Aleksey,

If I send you what I have done so far, can you help me a little? even giving me some hints will be ok... I suppose I could succeed with a little of help.

Anyway, there's somewhere I can have some tutorial/formation about this tool?

Thanks.

[Alex K.]

Hello,

Please send us a test data for analysis.
We will try to prepare the sample for you.

Thank you.

[victorinable]

Hi Aleksey,

Thank you very much! I'll prepare it for you tomorrow at the very very morning, as now I've to go from the office.

This is very appreciated

Have a nice afternoon!

[Alex K.]

Hello,

Ok.
We will wait.

[victorinable]

Hi Aleksey,

Finally I decided to create a single Dataset with both tables and use a cross-tab component.

Thanks for the support!

[Alex K.]

Hello,

Ok.
Please let us know if you need any additional help.