Cross tab for Accummulated Aggreggate function

[victorinable]

Hi Aleksey,

That was previously checked. Access is granted and Data is there.

Mail is sent (Subject: Support_Master_Detail)

Thanks in advance.

[HighAley]

Hello.

OK. We will answer you by email.

Thank you.

[victorinable]

Hi,

Thanks for the corrections. I also had to correct it a little, as the idea was a little different. So final expression is:

(H991162_DIM_TIEMPO.FECHA >= H991162_SADMIN.H1DDEB && ((H991162_DIM_TIEMPO.FECHA <= H991162_SADMIN.H1DFIN) || (H991162_SADMIN.H1DFIN == null)))

Also I had to define H991162_SADMIN.H1DFIN as DateTime(Nullable), otherwise it's showing always "0".

Once this is resolved, next step is to add another aggrupation, so I'll need to display something similar to the image attached. The grouping I need is for a column that belongs to Dataset "SADMIN" (Details), To have "Periods" as a rows and "Building" as a columns, so the data is "Active registers per period and Building"

Also, as you can see, I'd like to have a summary final row with the average of active registers per period per Building.

Is this possible? There is any restriction due to my Data Model?

Thanks in advance.

[HighAley]

Hello, Victor.

Could you specify is the number of periods fixed for the report?
Do you have the fixed list of the buildings? Could be there null values?

Thank you.

[victorinable]

Hi Aleksey,

Periods and Buildings are not fixed and there can be not null vallues either in periods or buildings (No empty buildings, not empty periods).

So it will be possible to decide how much periods you can see and buildings are different for each customer.

Thanks in advance.

[HighAley]

Hello, Victor.

Then it's better to use Cross-Tab.

You could learn how to create reports with cross-tab at the Cross-Tab Report in Data Band section of the Stimulsoft User Manual. There you could also find a link on the tutorial video.

Thank you.

[victorinable]

Hi Aleksey,

But then, as far as I see, If I do this, It will not look like the attachment I sent you 2 posts ago, I'll have several tabs, each for a period. Is there any way of having this presented as a single tab??

Thanks.

[HighAley]

Hello.

Could you send us a screen-shot of the report that you get with description what us wrong?
Please, send us your report template with sample data for analysis.

Thank you.

[victorinable]

Hi Aleksey,

I'll re-cosntruct it, as I did something different, but I'll give to you asap.

Thanks.

[HighAley]

Hello.

We are waiting for additional information from you.

Thank you.