Home » Archived » BIRT » CSV output
| CSV output [message #239670] |
Wed, 23 May 2007 16:04  |
Eclipse User |
|
|
|
Originally posted by: xxx.xxx.com
Jason, I can see your answer on how to export output to CSV as follows
but it didnt say anything about how to do that.If you can put some code
snippets, that would be perfect.
Thank You
From: Jason Weathersby <jasonweathersby@xxxxxxxxxx>
Date: Tue, 03 Apr 2007 19:53:00 -0700
Newsgroups: eclipse.birt
Organization: EclipseCorner
User-agent: Thunderbird 1.5.0.10 (Windows/20070221)
This definitely could be done using the report engine api.
To do this with the viewer will require that you mod the viewer code or
the ajax code that displays the export.
Jason
Joseph Hurley wrote:
Hello,
Currently, the BIRT web viewer will allow you to export tables into csv
format. However, if your report has multiple table objects, you need to
export each table separately. Is there a way to export multiple tables
at one time? Our situation is that we have several tables in the same
format, but with certain criteria changes (work based on labor,
materials, equipment, etc). We'd like the user to be able to export all
these tables at once,if possible. Thanks.
|
|
|
| Re: CSV output [message #239779 is a reply to message #239670] |
Thu, 24 May 2007 11:15  |
| Eclipse User |
|
|
|
Originally posted by: jasonweathersby.alltel.net
Kris,
Look at this example. This uses the RE API.
http://wiki.eclipse.org/index.php/Data_Extract
Jason
Kris wrote:
> Jason, I can see your answer on how to export output to CSV as follows
> but it didnt say anything about how to do that.If you can put some code
> snippets, that would be perfect.
>
> Thank You
>
> From: Jason Weathersby <jasonweathersby@xxxxxxxxxx>
> Date: Tue, 03 Apr 2007 19:53:00 -0700
> Newsgroups: eclipse.birt
> Organization: EclipseCorner
> User-agent: Thunderbird 1.5.0.10 (Windows/20070221)
>
> This definitely could be done using the report engine api.
> To do this with the viewer will require that you mod the viewer code or
> the ajax code that displays the export.
>
>
> Jason
>
>
> Joseph Hurley wrote:
> Hello,
>
> Currently, the BIRT web viewer will allow you to export tables into csv
> format. However, if your report has multiple table objects, you need to
> export each table separately. Is there a way to export multiple tables
> at one time? Our situation is that we have several tables in the same
> format, but with certain criteria changes (work based on labor,
> materials, equipment, etc). We'd like the user to be able to export all
> these tables at once,if possible. Thanks.
>
|
|
|
| Re: CSV output [message #239867 is a reply to message #239779] |
Thu, 24 May 2007 18:45 |
| Eclipse User |
|
|
|
Originally posted by: xxx.xxx.com
Jason, I tried this and it worked like a charm - thanks very much.
Right now, the resultset list extracted are a collection of resultset
for each column in the report. So when I printed, it didnt print in rows
but in columns.
Report data looks as follows
-------
11 12 13 14 15
21 22 23 24 25
31 32 33 34 35
The printing occurred as follows
-----
11 21 31
12 22 32
13 23 33
14 24 34
15 25 35
Is there any straight forward way to extract data and use the result set
in a row fashion?
Thanks
Jason Weathersby wrote:
> Kris,
>
> Look at this example. This uses the RE API.
>
> http://wiki.eclipse.org/index.php/Data_Extract
>
> Jason
>
> Kris wrote:
>> Jason, I can see your answer on how to export output to CSV as follows
>> but it didnt say anything about how to do that.If you can put some
>> code snippets, that would be perfect.
>>
>> Thank You
>>
>> From: Jason Weathersby <jasonweathersby@xxxxxxxxxx>
>> Date: Tue, 03 Apr 2007 19:53:00 -0700
>> Newsgroups: eclipse.birt
>> Organization: EclipseCorner
>> User-agent: Thunderbird 1.5.0.10 (Windows/20070221)
>>
>> This definitely could be done using the report engine api.
>> To do this with the viewer will require that you mod the viewer code or
>> the ajax code that displays the export.
>>
>>
>> Jason
>>
>>
>> Joseph Hurley wrote:
>> Hello,
>>
>> Currently, the BIRT web viewer will allow you to export tables into
>> csv format. However, if your report has multiple table objects, you
>> need to export each table separately. Is there a way to export
>> multiple tables at one time? Our situation is that we have several
>> tables in the same format, but with certain criteria changes (work
>> based on labor, materials, equipment, etc). We'd like the user to be
>> able to export all these tables at once,if possible. Thanks.
>>
|
|
|
| Re: CSV output [message #240178 is a reply to message #239867] |
Tue, 29 May 2007 11:02 |
| Eclipse User |
|
|
|
Originally posted by: jasonweathersby.alltel.net
Kris,
Is you data in one table? If you used the example and exported just
that table it should have retrieved just like your table data. If your
data is in multiple tables and you want one combined output, you will
need to store the data in a hash in your code and print it out when you
are finished. Another option is to make a new report and use the Joint
Data Set to combine your data sets, and add this new joint ds to a table
in the report.
Jason
Kris wrote:
> Jason, I tried this and it worked like a charm - thanks very much.
>
> Right now, the resultset list extracted are a collection of resultset
> for each column in the report. So when I printed, it didnt print in rows
> but in columns.
>
> Report data looks as follows
> -------
> 11 12 13 14 15
> 21 22 23 24 25
> 31 32 33 34 35
>
> The printing occurred as follows
> -----
> 11 21 31
> 12 22 32
> 13 23 33
> 14 24 34
> 15 25 35
>
> Is there any straight forward way to extract data and use the result set
> in a row fashion?
>
> Thanks
>
>
> Jason Weathersby wrote:
>> Kris,
>>
>> Look at this example. This uses the RE API.
>>
>> http://wiki.eclipse.org/index.php/Data_Extract
>>
>> Jason
>>
>> Kris wrote:
>>> Jason, I can see your answer on how to export output to CSV as
>>> follows but it didnt say anything about how to do that.If you can put
>>> some code snippets, that would be perfect.
>>>
>>> Thank You
>>>
>>> From: Jason Weathersby <jasonweathersby@xxxxxxxxxx>
>>> Date: Tue, 03 Apr 2007 19:53:00 -0700
>>> Newsgroups: eclipse.birt
>>> Organization: EclipseCorner
>>> User-agent: Thunderbird 1.5.0.10 (Windows/20070221)
>>>
>>> This definitely could be done using the report engine api.
>>> To do this with the viewer will require that you mod the viewer code or
>>> the ajax code that displays the export.
>>>
>>>
>>> Jason
>>>
>>>
>>> Joseph Hurley wrote:
>>> Hello,
>>>
>>> Currently, the BIRT web viewer will allow you to export tables into
>>> csv format. However, if your report has multiple table objects, you
>>> need to export each table separately. Is there a way to export
>>> multiple tables at one time? Our situation is that we have several
>>> tables in the same format, but with certain criteria changes (work
>>> based on labor, materials, equipment, etc). We'd like the user to be
>>> able to export all these tables at once,if possible. Thanks.
>>>
|
|
|
| Re: CSV output [message #240199 is a reply to message #240178] |
Tue, 29 May 2007 11:48 |
| Eclipse User |
|
|
|
Originally posted by: xxx.xxx.com
Jason, today I found an interesting thing on this behavior. The
different behavior I have been experiencing is attributed to the
component I was using to display data.I was using a grid before and when
I changed that to a table, it worked as expected. (So, it looks like
each grid column is treated as a separate "table".)
Thanks
Jason Weathersby wrote:
> Kris,
>
> Is you data in one table? If you used the example and exported just
> that table it should have retrieved just like your table data. If your
> data is in multiple tables and you want one combined output, you will
> need to store the data in a hash in your code and print it out when you
> are finished. Another option is to make a new report and use the Joint
> Data Set to combine your data sets, and add this new joint ds to a table
> in the report.
>
> Jason
>
> Kris wrote:
>> Jason, I tried this and it worked like a charm - thanks very much.
>>
>> Right now, the resultset list extracted are a collection of resultset
>> for each column in the report. So when I printed, it didnt print in
>> rows but in columns.
>>
>> Report data looks as follows
>> -------
>> 11 12 13 14 15
>> 21 22 23 24 25
>> 31 32 33 34 35
>>
>> The printing occurred as follows
>> -----
>> 11 21 31
>> 12 22 32
>> 13 23 33
>> 14 24 34
>> 15 25 35
>>
>> Is there any straight forward way to extract data and use the result
>> set in a row fashion?
>>
>> Thanks
>>
>>
>> Jason Weathersby wrote:
>>> Kris,
>>>
>>> Look at this example. This uses the RE API.
>>>
>>> http://wiki.eclipse.org/index.php/Data_Extract
>>>
>>> Jason
>>>
>>> Kris wrote:
>>>> Jason, I can see your answer on how to export output to CSV as
>>>> follows but it didnt say anything about how to do that.If you can
>>>> put some code snippets, that would be perfect.
>>>>
>>>> Thank You
>>>>
>>>> From: Jason Weathersby <jasonweathersby@xxxxxxxxxx>
>>>> Date: Tue, 03 Apr 2007 19:53:00 -0700
>>>> Newsgroups: eclipse.birt
>>>> Organization: EclipseCorner
>>>> User-agent: Thunderbird 1.5.0.10 (Windows/20070221)
>>>>
>>>> This definitely could be done using the report engine api.
>>>> To do this with the viewer will require that you mod the viewer code or
>>>> the ajax code that displays the export.
>>>>
>>>>
>>>> Jason
>>>>
>>>>
>>>> Joseph Hurley wrote:
>>>> Hello,
>>>>
>>>> Currently, the BIRT web viewer will allow you to export tables into
>>>> csv format. However, if your report has multiple table objects, you
>>>> need to export each table separately. Is there a way to export
>>>> multiple tables at one time? Our situation is that we have several
>>>> tables in the same format, but with certain criteria changes (work
>>>> based on labor, materials, equipment, etc). We'd like the user to be
>>>> able to export all these tables at once,if possible. Thanks.
>>>>
|
|
|
| Re: CSV output [message #240214 is a reply to message #240199] |
Tue, 29 May 2007 14:08 |
| Eclipse User |
|
|
|
Originally posted by: jasonweathersby.alltel.net
Kris
This is due to the fact that the grid is individually bound per cell.
Jason
Kris wrote:
> Jason, today I found an interesting thing on this behavior. The
> different behavior I have been experiencing is attributed to the
> component I was using to display data.I was using a grid before and when
> I changed that to a table, it worked as expected. (So, it looks like
> each grid column is treated as a separate "table".)
>
> Thanks
>
> Jason Weathersby wrote:
>> Kris,
>>
>> Is you data in one table? If you used the example and exported just
>> that table it should have retrieved just like your table data. If
>> your data is in multiple tables and you want one combined output, you
>> will need to store the data in a hash in your code and print it out
>> when you are finished. Another option is to make a new report and use
>> the Joint Data Set to combine your data sets, and add this new joint
>> ds to a table in the report.
>>
>> Jason
>>
>> Kris wrote:
>>> Jason, I tried this and it worked like a charm - thanks very much.
>>>
>>> Right now, the resultset list extracted are a collection of resultset
>>> for each column in the report. So when I printed, it didnt print in
>>> rows but in columns.
>>>
>>> Report data looks as follows
>>> -------
>>> 11 12 13 14 15
>>> 21 22 23 24 25
>>> 31 32 33 34 35
>>>
>>> The printing occurred as follows
>>> -----
>>> 11 21 31
>>> 12 22 32
>>> 13 23 33
>>> 14 24 34
>>> 15 25 35
>>>
>>> Is there any straight forward way to extract data and use the result
>>> set in a row fashion?
>>>
>>> Thanks
>>>
>>>
>>> Jason Weathersby wrote:
>>>> Kris,
>>>>
>>>> Look at this example. This uses the RE API.
>>>>
>>>> http://wiki.eclipse.org/index.php/Data_Extract
>>>>
>>>> Jason
>>>>
>>>> Kris wrote:
>>>>> Jason, I can see your answer on how to export output to CSV as
>>>>> follows but it didnt say anything about how to do that.If you can
>>>>> put some code snippets, that would be perfect.
>>>>>
>>>>> Thank You
>>>>>
>>>>> From: Jason Weathersby <jasonweathersby@xxxxxxxxxx>
>>>>> Date: Tue, 03 Apr 2007 19:53:00 -0700
>>>>> Newsgroups: eclipse.birt
>>>>> Organization: EclipseCorner
>>>>> User-agent: Thunderbird 1.5.0.10 (Windows/20070221)
>>>>>
>>>>> This definitely could be done using the report engine api.
>>>>> To do this with the viewer will require that you mod the viewer
>>>>> code or
>>>>> the ajax code that displays the export.
>>>>>
>>>>>
>>>>> Jason
>>>>>
>>>>>
>>>>> Joseph Hurley wrote:
>>>>> Hello,
>>>>>
>>>>> Currently, the BIRT web viewer will allow you to export tables into
>>>>> csv format. However, if your report has multiple table objects, you
>>>>> need to export each table separately. Is there a way to export
>>>>> multiple tables at one time? Our situation is that we have several
>>>>> tables in the same format, but with certain criteria changes (work
>>>>> based on labor, materials, equipment, etc). We'd like the user to
>>>>> be able to export all these tables at once,if possible. Thanks.
>>>>>
|
|
|
Goto Forum:
Current Time: Fri Nov 07 23:56:37 EST 2025
Powered by FUDForum. Page generated in 0.06020 seconds |
Home