| Fixed structure of rows [message #1027513] |
Tue, 26 March 2013 23:44  |
Eclipse User |
|
|
|
Hello everybody
I have to create fixed structure of rows (non dimanic report)
For example: How could I create following structure: (using sample DB CLASSICMODELS.PAYMENTS)
Checknumber --------------------Amount
AG240323------------------------20220,04
AU364101------------------------36251,03
AH612904 + AK412714-------------67599,57
What is the best way to set different filters by Checknumber on each row
What kind of report item should I use and how to restrict it?
Thank you in advance
|
|
|
|
|
| Re: Fixed structure of rows [message #1031868 is a reply to message #1031115] |
Tue, 02 April 2013 05:59  |
| Eclipse User |
|
|
|
Hi,
I don't think you can create such report easily. If your datasource is SQL, you can prepare your aggregations in SQL query and then use conditional formatting to highlight aggregations, e.g.:
select 1 as DisplayOrder, 'Cash and equivalents', sum(amount) from acc_data where id_account = 10001 union all
select 2 as DisplayOrder, 'TradeReceivables', sum(amount) from acc_data where id_account = 10002 union all
select 3 as DisplayOrder, 'TradeReceivables', sum(amount) from acc_data where id_account in (10001,10002)
The other option is to go row by row and add one number in every cell and use filters to get sum of values you are interested in.
|
|
|
|
| Re: Fixed structure of rows [message #1032559 is a reply to message #1027513] |
Wed, 03 April 2013 02:30 |
| Eclipse User |
|
|
|
Tomas Greif,
Thank you for reply. I've tried to use unions, it works. But takes a lot of time for big reports, and some effort to create texts for each row ("Cash and cash equivalents" etc.)
Michael Williams,
there is no spesial field, just accountnumber, amount, date.
|
|
|
Powered by
FUDForum. Page generated in 0.03331 seconds
Home
(If it's possible, please could you show how)