Report Output Not Showing Properly

I have an SQL query, in which contains a rule specifies that a CLAIM_ID may have up to two Risk Codes applicable to that ID. The query result is grouped by the ID number.

What I had in mind ( the report output) is something like this:

| | RISK CODE 1 (R) | RISK CODE 2 (V) |

| CID | R1 R2 R3 | V1 V2 V3 |

The problem I face is now is that I'm not sure whether it is possible to show the values simultaneously since each half (in the example above) is a different Risk Code. Is there any special thing that I need to implement in the layout design? Or is it actually a limitation for the current version of BIRT?

Find more posts tagged with

Comments

mwilliams

Hi mmah,

Can you post some example data of what your dataSet data looks like and then show how you want that data to look in your report so I have a better idea of what you're looking for? Thanks.

mmah

Hi Michael,

The sample data output (a piece of it)

FS011 On Building 12800000000 172411
FS012 On Machinery and Equipment 32000000000 172411

ID number is 172411.

The output would be like:

| | On Building | On Machinery and Equipment |

| FLEX_DESC | 24 128000000 R3 | 5 3200000000 V3 |

24 and 5 represents the number of IDs that has that On Building Risk Code or the On Machinery Risk Code

Please do let me know if you need additional info.

[Add] - Attach herewith is the wip of the report with the query. I would want to show two Risks at the same time.

Thanks.

Melvin

mwilliams

Melvin,<br />
<br />
It looks like you'll probably have to do a parallel type report and maybe some grouping to get this type of output. Here is a link to some help on parallel style reports from the devShare:<br />
<br />
<a class='bbc_url' href='http://www.birt-exchange.com/devshare/?filtercontent=parallel&contenttype=-1&date=-2year&rating=0&results=10&cid=0'>All Topics - BIRT Exchange</a>