crossdataband assistance

[cbrydon]

Hi,

I am trying to figure out how to use the various cross components. I can figure out how to use the CrossTab itself, but
I'm trying to figure out how to use the CrossDataBand, CrossHeader and CrossFooterBands. At one point while looking for something
else, I think I came across an example of how those components work together, but I can't find it anymore. Would there be a simple
example (with data) that you could point me to?

Thanks,
Carl

[cbrydon]

I suppose I should have included a screenshot of a report I'm trying to produce.
The attached image shows 3 "sections" of a report. The top left shows the date/department for
which the report will be run. The bottom part shows employee time.

The top part where it has SpeedType, Cost Center,Asset, Project etc. needs to be dynamic in that
depending on the date chosen, there could be one or more groups of Chartfield Details. The employee
time groups need to correspond to the headers above.

I'm thinking this may involve the use of CrossDataBands, CrossGroups, etc. but I'm not sure really how to
use them.

Hoping you can provide some guidance!

Thanks,
Carl

[Alex K.]

Hello,

It is difficult to say without a test data. Please send us a test data as it present in your report, we will try to prompt a solution for you.

Thank you.

[cbrydon]

Thanks Aleksey, Attached is some test data. I will also keep plugging away on my end to see what I can come up with.

[cbrydon]

Please note, there is no employee data in the sample data. I would be happy to just get the top header part of the report working.
Thank You,
Carl

[cbrydon]

Hi, I thought I would try and simplify what I'd like to do and have attached a word document with a test layout that I'd like to
achieve. Essentially I'd like to have the report grouped vertically by Department and filtered by date - these two things are
easy enough to do. The tricky part for me is how to group horizontally various attributes for each department. I believe this
can be done with CrossBands, but can't quite figure out how to use them properly.

Hopefully you'll be able to help!

[Alex K.]

Hello,

Please check the sample report in the attachment.

Thank you.

[cbrydon]

Thanks Aleksey, That was very very helpful! I modified the report slightly and moved the text controls from the crossdataband into a crossgroupheader band just to make things a little tidier. Is there a way to label each group with a sequential number? For example, in the cross header groups, can the first group be labeled as group 1,the second group as group 2 and so on...?

[Alex K.]

Hello,

Please try to add the Text component with the following expression on the GroupHeader band:
Group {GroupLine}
or use additional variable wich increases at the GroupHeader and set to zero in each master record.

Thank you.

[cbrydon]

Thanks for the suggestion Aleksey. I did try the {GroupLine}in the header band and it counts the groups across all master records.
For each master record, I'd like the counting to start at 1 so will try your 2nd suggestion of adding an additional variable. I'm not sure
how to set it to zero for each master record though.