Eclipse Community Forums: BIRT » Adhoc Reporting in Open Source BIRT

Home » Archived » BIRT » Adhoc Reporting in Open Source BIRT

Adhoc Reporting in Open Source BIRT [message #724824]

Tue, 13 September 2011 05:57

Eclipse User

Hi All

Here is my requirement.

I have a finite list of columns (say 30). Here are the steps the user might perform

1) Clicks a link.
2) App shows all the 30 columns and all the rows (page wise)
3) User can remove and later add columns to the results
4) User can apply filters
5) User can select a column to sort
6) User can select a column to group

req's 5/6 can be done later. But 1-4 are must.
I am looking at birt to help me achieve this.

I am thinking to do this. Once the user clicks on the main link, show all the data (page wise). At this point generate the rptDocument. And then, apply filters / add / remove columns over the rptDocument. My question is can we query over an existing rptDocument. Or add / remvoe columns in rptDocument.

Pl note that I am going to use an appserver and use RE API.

Is my thinking in the right direction. Pl let me know if there are any other options available.

Thanks

Re: Adhoc Reporting in Open Source BIRT [message #725027 is a reply to message #724824]

Tue, 13 September 2011 14:18

Eclipse User

Actuate's interactive viewer does items 1-6 in addition to adding charts
etc. It is not open source though, but will work with reports created
in open source.

Jason

On 9/13/2011 5:57 AM, sam wrote:
> Hi All
>
> Here is my requirement.
>
> I have a finite list of columns (say 30). Here are the steps the user
> might perform
>
> 1) Clicks a link. 2) App shows all the 30 columns and all the rows (page
> wise)
> 3) User can remove and later add columns to the results
> 4) User can apply filters
> 5) User can select a column to sort
> 6) User can select a column to group
>
> req's 5/6 can be done later. But 1-4 are must.
> I am looking at birt to help me achieve this.
>
> I am thinking to do this. Once the user clicks on the main link, show
> all the data (page wise). At this point generate the rptDocument. And
> then, apply filters / add / remove columns over the rptDocument. My
> question is can we query over an existing rptDocument. Or add / remvoe
> columns in rptDocument.
>
> Pl note that I am going to use an appserver and use RE API.
>
> Is my thinking in the right direction. Pl let me know if there are any
> other options available.
>
> Thanks
>

Re: Adhoc Reporting in Open Source BIRT [message #725124 is a reply to message #725027]

Tue, 13 September 2011 23:08

Eclipse User

Thanks Jason for the reply.
I understand Actuate Interactive Viewer has those features. I would like to know if we can achieve using ONLY open source. Thats our current requirement. I just need a direction.

Thanks

Re: Adhoc Reporting in Open Source BIRT [message #725139 is a reply to message #725124]

Wed, 14 September 2011 00:46

Eclipse User

Sam,

I have several example that apply filters and sorting using client side
script that re-run the reports. Would these be useful?

Jason

On 9/13/2011 11:08 PM, sam wrote:
> Thanks Jason for the reply.
> I understand Actuate Interactive Viewer has those features. I would like
> to know if we can achieve using ONLY open source. Thats our current
> requirement. I just need a direction.
>
> Thanks

Re: Adhoc Reporting in Open Source BIRT [message #725152 is a reply to message #725139]

Wed, 14 September 2011 01:52

Eclipse User

Definitely

Re: Adhoc Reporting in Open Source BIRT [message #725348 is a reply to message #725152]

Wed, 14 September 2011 10:53

Eclipse User

Sam,

Take a look at some of these.

Jason

On 9/14/2011 1:52 AM, sam wrote:
> Definitely

Attachment: VariousClientSideScriptExamples.zip
(Size: 25.50KB, Downloaded 366 times)

Re: Adhoc Reporting in Open Source BIRT [message #725744 is a reply to message #725348]

Thu, 15 September 2011 12:28

Eclipse User

Thank you for your examples.

I am thinking of the following approach. Our database is huge and regenerating the report from database may not be feasible.

The first time when the user clicks on the main screen, all the database rows (accessible by that user) will be shown with all the columns (30). We will generate this by Run + Render task. This will generate an rptdocument.

All the subsequent searches / filters / sorts / grouping will be in a new report, for which the backend will be the rptdocument created first. We will use scripted dataset for this and the filters / sorts / groups will be added dynamically to the table.

I have tested a basic flow with this and seems like it works.

Would there be any challenges in this approach with large amounts of data?

Thanks

Re: Adhoc Reporting in Open Source BIRT [message #726113 is a reply to message #725744]

Fri, 16 September 2011 11:38

Eclipse User

I am not certain. I have not tried this approach before.

Jason

On 9/15/2011 12:28 PM, vavesw wrote:
> Thank you for your examples.
>
> I am thinking of the following approach. Our database is huge and
> regenerating the report from database may not be feasible.
>
> The first time when the user clicks on the main screen, all the database
> rows (accessible by that user) will be shown with all the columns (30).
> We will generate this by Run + Render task. This will generate an
> rptdocument.
>
> All the subsequent searches / filters / sorts / grouping will be in a
> new report, for which the backend will be the rptdocument created first.
> We will use scripted dataset for this and the filters / sorts / groups
> will be added dynamically to the table.
>
> I have tested a basic flow with this and seems like it works.
>
> Would there be any challenges in this approach with large amounts of data?
>
> Thanks

Re: Adhoc Reporting in Open Source BIRT [message #894129 is a reply to message #725348]

Fri, 06 July 2012 15:04

Eclipse User

Hi,

filter doesnt filter data at the client side? AM I missing something?

Re: Adhoc Reporting in Open Source BIRT [message #894159 is a reply to message #894129]

Fri, 06 July 2012 23:17

Eclipse User

Filters modify the available data at run time on the server.

Jason

On 7/6/12 3:04 PM, Suresh Martha wrote:
> Hi,
>
> filter doesnt filter data at the client side? AM I missing something?

Previous Topic:	Output Format
Next Topic:	how to change export file name

Goto Forum:

-=] Back to Top [=-

Current Time: Tue Jul 15 12:46:52 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter