Page 1 of 5
Grid summary on each page
Posted: Tue Sep 04, 2012 10:21 am
by 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.
Re: Grid summary on each page
Posted: Wed Sep 05, 2012 9:07 am
by HighAley
Hello.
Niqu wrote: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.
Re: Grid summary on each page
Posted: Mon Sep 17, 2012 5:56 am
by Niqu
It works exactly as I wanted. Thank you for help.
Re: Grid summary on each page
Posted: Tue Sep 18, 2012 3:49 am
by Andrew
Hello,
Great! Have a nice day!
Thank you.
Re: Grid summary on each page
Posted: Fri Oct 05, 2012 5:42 am
by 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.
Re: Grid summary on each page
Posted: Fri Oct 05, 2012 2:55 pm
by HighAley
Hello.
Sorry, we need a little more time to prepare an answer for you.
Thank you.
Re: Grid summary on each page
Posted: Wed Oct 10, 2012 7:13 am
by Niqu
Hello.
It is no problem. Just let me know when you will have the answer.
Thank you.
Re: Grid summary on each page
Posted: Thu Oct 11, 2012 2:54 am
by Andrew
Hello,
Sure, we will.
Thank you.
Re: Grid summary on each page
Posted: Wed Oct 17, 2012 2:01 pm
by Niqu
Hello.
Any progress about my issue?
Re: Grid summary on each page
Posted: Thu Oct 18, 2012 1:20 pm
by HighAley
Hello.
We are still working on your problem.
We'll let you know about the results.
Thank you.