Multiple horizontal lines from table

This is the first report using BIRT and am just stupified as to how to create it.
I have created the basic simple table layout reports described in the BOOK, BIRT - A Field Guide To Reporting.

I have a data table that needs to be laid out as follows, grouped by Domain number and sorted by Domain# and Seq#:
==========================================
Domain #: 1 [Mental Status]
(header) Seq# Ques# Req: Age ****
(Data) 1 23 N 9 M
(text) Question:
(Data) [Question]
(text) Pre-req. Ques: [0]
________________________________________

(header) Seq# Ques# Req: Age ****
(Data) 2 19 N 5 F
(text) Question:
(Data) [Question]
(text) Pre-req. Ques: [1]
________________________________________

(header) Seq# Ques# Req: Age ****
(Data) 3 43 N 12 F
(text) Question:
(Data) [Question]
(text) Pre-req. Ques: [0]
________________________________________

Domain #: 2 [Psych Eval]
(header) Seq# Ques# Req: Age ****
(Data) 1 4 N 14 M
(text) Question:
(Data) [Question]
(text) Pre-req. Ques: [0]

If someone could just point me in the right direction, I can probably figure this out. The problem is This report must be completed in the next day or so after only 2 days working with the actual BIRT software. Any help would be greatly appreciated.

Find more posts tagged with

Comments

mwilliams

jjkky01,

Is all of the data that is grouped under each sequence in your example above in one row in the dataSet? If so, you just need to create a table grouped on Domain, have that group sorted by sequence, and then stack your data items to appear how you want them or create multiple detail lines to make them look the way you want. Let me know if you have questions. If you provide a small csv file of data, I can set up what I'm saying real quick if need be.

jjkky01

Thanks mwilliams - I've attached a small csv data file - Jim

mwilliams

Jim,

One more quick question. What version of BIRT are you using?

jjkky01

Eclipse BIRT Designer Version 2.2.2.r222_v20071226 Build <2.2.2.v20080131-1102> Jim

mwilliams

Jim,

Here's a report design set up roughly how you want it using groups. You don't need the group on sequence. I just did that to use the header row to only have one header per sequence. You could just put the "header" row in the detail row to be repeated for each question. Let me know if you have questions.

Be sure to change the file location in the dataSource to the location that you save this text file to.

jjkky01

Thanks Michael! I hope to test this out today. I really appreciate your help on this. Jim

mwilliams

Jim,

No problem. Let us know if you have any other questions.

jjkky01

Thanks Michael! I got it working but had to put my data elements in the group rows instead of the detail rows. At any rate, I got it working with the exception of the PDF printout which has a font size of about 3 and is printing way to small. All other print formats seem to be normal. Jim

mwilliams

Jim,

I don't see the issue in PDF that you're seeing, at least not with this report. Is it with your own report that you're seeing the issues? Or the one that we're using as a sample in here? Let me know.