Eclipse Community Forums: BIRT » Fixed structure of rows

Help

Home

Home » Archived » BIRT » Fixed structure of rows (Fixed structure of rows )

Show: Today's Messages :: Show Polls :: Message Navigator

Fixed structure of rows [message #1027513]

Wed, 27 March 2013 03:44

Igor Wagner

Messages: 4
Registered: March 2013

Junior Member

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

Report message to a moderator

Re: Fixed structure of rows [message #1029535 is a reply to message #1027513]

Fri, 29 March 2013 20:53

Michael Williams

Messages: 1925
Registered: July 2009

Senior Member

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

Report message to a moderator

Re: Fixed structure of rows [message #1031115 is a reply to message #1029535]

Mon, 01 April 2013 07:45

Igor Wagner

Messages: 4
Registered: March 2013

Junior Member

I have to create financial reports like balance sheet, Cash flow etc. So there is different accounts in each row.

Cash and cash equivalents (account 1011000000+1013000000)---1000$
Trade receivables-net (account 1211000000)------------------500$
Total current assets(Sum of 1st and 2nd)-------------------1500$
Share premium (no accounts)-------------------------------space
Trade payables(certain accounts)--------------------100500$
...etc.

(in this topic i use checknumber just for example )
I guess I can't create such a structure using groups. Sad

(If it's possible, please could you show how)

Report message to a moderator

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.

Report message to a moderator

Re: Fixed structure of rows [message #1032194 is a reply to message #1031868]

Tue, 02 April 2013 17:31

Michael Williams

Messages: 1925
Registered: July 2009

Senior Member

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

Report message to a moderator

Re: Fixed structure of rows [message #1032559 is a reply to message #1027513]

Wed, 03 April 2013 06:30

Igor Wagner

Messages: 4
Registered: March 2013

Junior Member

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.

Report message to a moderator

Previous Topic:	How to generate multiple reports?
Next Topic:	Adding column to Report

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jun 08 16:54:05 GMT 2023

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter