Displaying Columns as Rows..PLEASE HELP

friends
I have a table which has got just one row but many columns
eg
datetime signal1 signal2 signal3 signal4 signal5
12-02-09 123445.1 133445.1 143445.1 173445.1 196445.1
i want to display it in the report as
datetime 12-02--09
signal1 123445.1
signal2 133445.1
signal3 143445.1
signal4 173445.1.
signal5 196445.1
But iam not able to do this rather the table is displayed as such.
Is there any way out to meet my need?

Any quick help is appreciated
Thanks

Find more posts tagged with

Comments

mwilliams

Hi alpha,

Do you have a fixed number of columns? Will you always know how many "signals" there are? If so, You could just group your table by the date, put the date in the group header and put all the "signal" data items stacked in the detail row or add multiple detail rows and put each in their own. You'd be able to put the label "Signal x" in the first column and the actual data item in the second column. That should do it. Let me know if you have any questions or if I'm not answering your question.

alpha

hi
yes i have fixed number of columns and only one record in the table always
By default when you drag a table from the palette to the BIRT report
It has 3 parts the header ,detail and the footer

and now if i drag a column from the dataset to the detail,automatically the column name gets displayed in the header above with the value in the detail...In this case I don't have to create a separate label to display the column name.

Now i don't want data to be displayed column wise but row wise with automatic label for the column.

eg
_______________
by default it is
header: signal1
detail: 123.45
______________
but i want
signal1 123.45

Pl.Note:i have a lot of columns,so cannot add labels manually for each column.

and how can i change the height or width of the report page.
Thanks

mwilliams

alpha,

You can just drag the entire dataset over. It'll make a label and data item for each field in the dataset. Then you can add rows as needed and drag around the labels and data items to where you want them. Then just delete the extra columns from the table.

You can change the page size, margins, etc. on the "master page" tab.

alpha

michael

your suggestion is quite fine
but i have a dataset with 160 columns
It is a big and tedious job to drag the entire dataset and then drag the labels and data part to wherever i want
is there any way to tranpose rows and columns so that it gets displayed as i want?
if iam not clear please do tell ill explain.

and please tell me if it is possible to print(send it to the printer) a generated PDF report from my java code using the report engine API or some other API.

thanks

mwilliams

alpha,<br />
<br />
Unfortunately, I don't think there is currently a way to do this with a table. This is something you could definitely suggest as an enhancement. You can do that at <a class='bbc_url' href='http://www.eclipse.org/birt/phoenix/reportabug.php'>BIRT: Reporting Bugs and Requesting Enhancements</a>.<br />
<br />
To my knowledge, BIRT doesn't have a way to send a pdf output to the printer. BIRT does have the ablility to create a post script output to send to the printer. You may be able to use the JAVA API external to BIRT to send a pdf file to the printer.