|
| Re: Fixed structure of rows [message #1029535 is a reply to message #1027513] |
Fri, 29 March 2013 20:53   |
|
What are the check numbers grouped on? This could be a table, grouped by whatever joins the checknumber values together, then an aggregation would be used to give you a concatenated listing of the checknumbers in the group, for the first value and a sum of the amounts for the second value. Let me know if I'm misunderstanding the issue.
Michael
Developer Evangelist, Silanis
|
|
|
|
| Re: Fixed structure of rows [message #1031868 is a reply to message #1031115] |
Tue, 02 April 2013 09:59 |
 Tomas Greif
Messages: 53
Registered: September 2010 |
Member |
|
|
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 #1032194 is a reply to message #1031868] |
Tue, 02 April 2013 17:31 |
|
Igor,
Do you have a field that tells whether a certain row is a cash or cash equivalent, trade receivable, etc? Can you show a sample of what your data looks like in your dataSet preview?
Michael
Developer Evangelist, Silanis
|
|
|
|
Powered by
FUDForum. Page generated in 0.01931 seconds
] 
Search
Help
Register
Login
Home
(If it's possible, please could you show how)