Grid summary on each page

[Niqu]

Hello again.

Now I want to do grid with data source and grid with summary. For example:
I have two columns in grid with data source - first column is Name, second column is Number. In grid with summary (this grid will be always on the bottom of page) i want to sum of all numbers from column Number from grid with data srouce. Doing something like that it is easy, but i want something more.
I have big data source (like 100 rows), so it will be display on 2-4 pages. On each page I want to have this two grid - first with data source, second with summary. In grid with summary i want to display sum of all numbers from this page in first column and sum of all number from previous pages in second column.

I hope you will understand what I want to achieve. Is it possible to do something like that?

Thank you in advance.

[HighAley]

Hello.

Now I want to do grid with data source and grid with summary. For example:
I have two columns in grid with data source - first column is Name, second column is Number. In grid with summary (this grid will be always on the bottom of page) i want to sum of all numbers from column Number from grid with data srouce. Doing something like that it is easy, but i want something more.
I have big data source (like 100 rows), so it will be display on 2-4 pages. On each page I want to have this two grid - first with data source, second with summary. In grid with summary i want to display sum of all numbers from this page in first column and sum of all number from previous pages in second column.

I hope you will understand what I want to achieve. Is it possible to do something like that?

You could use next expressions:

Code: Select all

{cSum(DataProducts,Products.UnitsInStock)}
{SumRunning(DataProducts,Products.UnitsInStock)}

Please, look at the attached report template.

Thank you.

[Niqu]

It works exactly as I wanted. Thank you for help.

[Andrew]

Hello,

Great! Have a nice day!

Thank you.

[Niqu]

Hello.
Your last advice here was very helpful and I really help me.
Now I have a bit different businessObject and i found some difficulty. I was trying something similar in this report, but it didn't work as i wanted (perhaps i am doing something wrong).
Like the last time - I want to print grid summary on each page and in this summary I want to have in first row sum of values from this page and in the second row sum from the previous pages.
Perhaps it is impossible to achive what I want, but I am not sure. Maybe you will have some advice?

In attachment I am sending report and project to fill report data.

Thank you in advance.

[HighAley]

Hello.

Sorry, we need a little more time to prepare an answer for you.

Thank you.

[Niqu]

Hello.

It is no problem. Just let me know when you will have the answer.

Thank you.

[Andrew]

Hello,

Sure, we will.

Thank you.

[Niqu]

Hello.

Any progress about my issue?

[HighAley]

Hello.

We are still working on your problem.
We'll let you know about the results.

Thank you.