Eclipse Community Forums: BIRT » Is it possible to generate reports in Excel Format

Home » Archived » BIRT » Is it possible to generate reports in Excel Format

Is it possible to generate reports in Excel Format [message #163921]

Wed, 24 May 2006 00:59

Eclipse User

hi ,
As of now we are able to generate reports in two format HTML and PDF.
Now i have a requirement to generate reports in MS Excel Foratm.

Let me know is it possible to generate reports in othere than HTML and PDF
using BIRT.

and aslo let me know is it possible to generate reports in MS Excel format.

regards
venkata

Re: Is it possible to generate reports in Excel Format [message #164501 is a reply to message #163921]

Wed, 24 May 2006 22:24

Eclipse User

Originally posted by: qauck.msn.com

The answer is YES, venkata, check out
https://sourceforge.net/projects/tribix/ and good luck.

Shawn

venkata wrote:
> hi ,
> As of now we are able to generate reports in two format HTML and PDF.
> Now i have a requirement to generate reports in MS Excel Foratm.
>
> Let me know is it possible to generate reports in othere than HTML and
> PDF using BIRT.
>
> and aslo let me know is it possible to generate reports in MS Excel format.
>
>
> regards
> venkata
>

Re: Is it possible to generate reports in Excel Format [message #164525 is a reply to message #164501]

Thu, 25 May 2006 03:20

Eclipse User

hi , thanks for you reply,
let me know any example how to generate xls file at run time using
rptdesign file.

regards
venaktar

Re: Is it possible to generate reports in Excel Format [message #164761 is a reply to message #164525]

Thu, 25 May 2006 14:07

Eclipse User

I try it in it looks fine.
But there are some points witch I don't understand:
1. How can I use the range support? There is no parameter in the viewer
where I can set this value.
How can I see all the information in just one page.
2. How can I activate the show grind feature.
3. How can I activate the remove blank rows feature.

I try to look up the code, but without success.

Can anybody help me?

Thanks,
Carlos Dias

venkatar wrote:
> hi , thanks for you reply,
> let me know any example how to generate xls file at run time using
> rptdesign file.
>
> regards
> venaktar
>
>

Re: Is it possible to generate reports in Excel Format [message #164883 is a reply to message #164761]

Thu, 25 May 2006 22:23

Eclipse User

Originally posted by: qauck.msn.com

Meanwhile, the viewer doesn't expose any interface to pass any emitter
configuration in. You have to tweak the viewer source code to get this.

For use with standalone report engine, here is a doc decribes how to:
http://tribix.sourceforge.net/docs/How%20to%20use%20XLS%20em itter%20with%20BIRT%20runtime.htm

Carlos Dias wrote:
> I try it in it looks fine.
> But there are some points witch I don't understand:
> 1. How can I use the range support? There is no parameter in the viewer
> where I can set this value.
> How can I see all the information in just one page.
> 2. How can I activate the show grind feature.
> 3. How can I activate the remove blank rows feature.
>
> I try to look up the code, but without success.
>
> Can anybody help me?
>
> Thanks,
> Carlos Dias
>
> venkatar wrote:
>> hi , thanks for you reply,
>> let me know any example how to generate xls file at run time using
>> rptdesign file.
>>
>> regards
>> venaktar
>>
>>

Re: Is it possible to generate reports in Excel Format [message #165071 is a reply to message #163921]

Fri, 26 May 2006 15:17

Eclipse User

Venkata? are you the same person that has worked with Fleet Manager?

sorry for off topic, but was curious.

Re: Is it possible to generate reports in Excel Format [message #166856 is a reply to message #164883]

Fri, 02 June 2006 03:40

Eclipse User

Originally posted by: absrivas.yahoo.com

Hi,
for showing the gridlines you can use:

xlsConfig.put("show_grid_lines",new Boolean(true) );

there are other couple of propertirs we can set are

public static final String KEY_REMOVE_EMPTY_ROW = "remove_empty_row";
public static final String KEY_SHOW_GRID_LINES = "show_grid_lines";
public static final String KEY_PAGE_RANGE = "page_range";
public static final String KEY_FIXED_COLUMN_WIDTH =
"fixed_column_width";
public static final String ALL_ODD_PAGE = "odd";
public static final String ALL_EVEN_PAGE = "even";

I got these from XlsEmitterConfig class. I haev seen show_grid_lines works
fine but for others I am not sure.

Previous Topic:	getting Birt 2.1 RC4 to run on WebSphere
Next Topic:	mean chart question

Goto Forum:

-=] Back to Top [=-

Current Time: Wed Jul 23 11:17:14 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter