Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Adhoc Reporting in Open Source BIRT
Adhoc Reporting in Open Source BIRT [message #724824] Tue, 13 September 2011 05:57 Go to next message
sam va is currently offline sam va
Messages: 121
Registered: July 2011
Senior Member
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 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

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 Go to previous messageGo to next message
sam va is currently offline sam va
Messages: 121
Registered: July 2011
Senior Member
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 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

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 Go to previous messageGo to next message
sam va is currently offline sam va
Messages: 121
Registered: July 2011
Senior Member
Definitely
Re: Adhoc Reporting in Open Source BIRT [message #725348 is a reply to message #725152] Wed, 14 September 2011 10:53 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

Sam,

Take a look at some of these.

Jason

On 9/14/2011 1:52 AM, sam wrote:
> Definitely
Re: Adhoc Reporting in Open Source BIRT [message #725744 is a reply to message #725348] Thu, 15 September 2011 12:28 Go to previous messageGo to next message
sam va is currently offline sam va
Messages: 121
Registered: July 2011
Senior Member
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 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

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 Go to previous messageGo to next message
Suresh Martha is currently offline Suresh Martha
Messages: 1
Registered: July 2012
Junior Member
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 Go to previous message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

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:
  


Current Time: Fri Jul 25 16:41:56 EDT 2014

Powered by FUDForum. Page generated in 0.01831 seconds