Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Archived » BIRT » Accessing Dataset Mappings Via Java API(BIRT, Report Engine, dataset mapping)
Accessing Dataset Mappings Via Java API [message #1568180] Fri, 16 January 2015 20:22 Go to next message
andy rush is currently offline andy rushFriend
Messages: 15
Registered: July 2014
Junior Member
I'm working on a project to develop a report wrapper that leverages BIRT's Java API as the underlying generation tool. The underlying queries in the report sometimes result in datasets holding data that is not always displayed in the same manner (or at all) when output. For example, i might get a row that looks like:

"2014-01-01";"2014-01-14";"653443118056";"1";"$3 CROSSWORD TICKET";189;538.650;567.00;0.0500

While the display output of the row is:

$3 CROSSWORD TICKET 653443118056-1 198 $564.30 $594.00 $29.70 5.00%

In the generated output, no dates are displayed in the row and two result set columns are concatenated into a single display column.

One of the project specs is the ability to export to CSV with accurate header information. Unfortunately, the display headers are complex with nested rows and columns (and there may be more headers than columns), so the headers generated by the emitter do not properly align with the data fields.

I have managed to retrieve the database column names by obtaining a CachedMetaDataHandle and iterating the columns, but this seems to only contain the database columns name. What (i think) i need is to programmatically retrieve the metadata used to bind the result set to the display table prior to output. When i try Google, i find lots of information about obtainingg the mapping data using the JavaScript API, but not so much about using the Java API. Can it be done using just the Java API? If so, how? If not, is there some kind of workaround other than creating the mappings for each report manually?
Re: Accessing Dataset Mappings Via Java API [message #1579790 is a reply to message #1568180] Fri, 23 January 2015 05:25 Go to previous message
Michael Williams is currently offline Michael WilliamsFriend
Messages: 1925
Registered: July 2009
Senior Member

I've been working with you on this over on the BIRT Developer Center, so I'll go ahead and post a link to the discussion we started over there:

http://developer.actuate.com/community/forum/index.php?/topic/35833-programmatically-retrieve-dataset-mapping-with-java-api/


Michael

Developer Evangelist, Silanis
Previous Topic:How to define different library data sources in reports
Next Topic:[NEWBIE]: Help on making a template
Goto Forum:
  


Current Time: Sun Jul 14 05:05:29 GMT 2024

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

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

Back to the top