Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Fixed structure of rows (Fixed structure of rows )
Fixed structure of rows [message #1027513] Wed, 27 March 2013 03:44 Go to next message
Igor Wagner is currently offline Igor WagnerFriend
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
Re: Fixed structure of rows [message #1029535 is a reply to message #1027513] Fri, 29 March 2013 20:53 Go to previous messageGo to next message
Michael Williams is currently offline Michael WilliamsFriend
Messages: 1663
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

Add interactivity, scheduling, sharing, live Excel export, and JS integration to your BIRT app with the new, free BIRT server, BIRT iHub F-Type.
Re: Fixed structure of rows [message #1031115 is a reply to message #1029535] Mon, 01 April 2013 07:45 Go to previous messageGo to next message
Igor Wagner is currently offline Igor WagnerFriend
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)
Re: Fixed structure of rows [message #1031868 is a reply to message #1031115] Tue, 02 April 2013 09:59 Go to previous messageGo to next message
Tomas Greif is currently offline Tomas GreifFriend
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 Go to previous messageGo to next message
Michael Williams is currently offline Michael WilliamsFriend
Messages: 1663
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

Add interactivity, scheduling, sharing, live Excel export, and JS integration to your BIRT app with the new, free BIRT server, BIRT iHub F-Type.
Re: Fixed structure of rows [message #1032559 is a reply to message #1027513] Wed, 03 April 2013 06:30 Go to previous message
Igor Wagner is currently offline Igor WagnerFriend
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.



Previous Topic:How to generate multiple reports?
Next Topic:Get BIRT reports through the web service BIRT
Goto Forum:
  


Current Time: Wed Nov 26 04:17:21 GMT 2014

Powered by FUDForum. Page generated in 0.03887 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software