You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@wicket.apache.org by Douglas Ferguson <do...@douglasferguson.us> on 2009/10/14 18:08:26 UTC
Reporting Framework & Wicket
Hey,
I'm starting to look into reporting frameworks and was curious if
anybody had successfully integrated with wicket?
Are there any "off the shelf" integrations or will I have to roll my
own?
D/
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@wicket.apache.org
For additional commands, e-mail: users-help@wicket.apache.org
Re: Reporting Framework & Wicket
Posted by Ernesto Reinaldo Barreiro <re...@gmail.com>.
Just one caveat about the article: as far as I remember creating a platform
and report engine were costly operations. I do not have the code at hand but
I remember we created some kind of singleton that was used to launch the
reports. Additionally we added some logic that would:
1-scan report for parameters and generate an UI based on that. 2-replace
"design" data-sources for "production" data-sources.
3-For images and other resources there was some interface you could
implement so that reports could be able to call-back to the server and get
them served. We rolled out our own implementation and plugged it into BIRTs
machinery.
Ernesto
On Thu, Oct 15, 2009 at 9:57 AM, Peter Thomas <pt...@gmail.com> wrote:
> there was this article on DZone recently on integrating BIRT with Wicket,
> may be useful
>
> http://java.dzone.com/articles/integrating-birt-your-wicket
>
>
> On Thu, Oct 15, 2009 at 12:48 PM, Ernesto Reinaldo Barreiro <
> reiern70@gmail.com> wrote:
>
> > I have used it in combination with BIRT. But, there was nothing special
> on
> > the Wicket side, except for:
> > 1-some logic that would read REPORT parameters and dynamically build a
> form
> > allowing to fill in those.
> > 2-extended BIRT with some classes, implementing some BIRT interfaces,
> that
> > would stream back images
> > when rendering HTML reports.
> >
> > Best,
> >
> > Ernesto
> >
> > On Wed, Oct 14, 2009 at 6:08 PM, Douglas Ferguson <
> > douglas@douglasferguson.us> wrote:
> >
> > > Hey,
> > >
> > > I'm starting to look into reporting frameworks and was curious if
> > > anybody had successfully integrated with wicket?
> > >
> > > Are there any "off the shelf" integrations or will I have to roll my
> > > own?
> > >
> > > D/
> > >
> > > ---------------------------------------------------------------------
> > > To unsubscribe, e-mail: users-unsubscribe@wicket.apache.org
> > > For additional commands, e-mail: users-help@wicket.apache.org
> > >
> > >
> >
>
Re: Reporting Framework & Wicket
Posted by Peter Thomas <pt...@gmail.com>.
there was this article on DZone recently on integrating BIRT with Wicket,
may be useful
http://java.dzone.com/articles/integrating-birt-your-wicket
On Thu, Oct 15, 2009 at 12:48 PM, Ernesto Reinaldo Barreiro <
reiern70@gmail.com> wrote:
> I have used it in combination with BIRT. But, there was nothing special on
> the Wicket side, except for:
> 1-some logic that would read REPORT parameters and dynamically build a form
> allowing to fill in those.
> 2-extended BIRT with some classes, implementing some BIRT interfaces, that
> would stream back images
> when rendering HTML reports.
>
> Best,
>
> Ernesto
>
> On Wed, Oct 14, 2009 at 6:08 PM, Douglas Ferguson <
> douglas@douglasferguson.us> wrote:
>
> > Hey,
> >
> > I'm starting to look into reporting frameworks and was curious if
> > anybody had successfully integrated with wicket?
> >
> > Are there any "off the shelf" integrations or will I have to roll my
> > own?
> >
> > D/
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: users-unsubscribe@wicket.apache.org
> > For additional commands, e-mail: users-help@wicket.apache.org
> >
> >
>
Re: Reporting Framework & Wicket
Posted by Ernesto Reinaldo Barreiro <re...@gmail.com>.
I have used it in combination with BIRT. But, there was nothing special on
the Wicket side, except for:
1-some logic that would read REPORT parameters and dynamically build a form
allowing to fill in those.
2-extended BIRT with some classes, implementing some BIRT interfaces, that
would stream back images
when rendering HTML reports.
Best,
Ernesto
On Wed, Oct 14, 2009 at 6:08 PM, Douglas Ferguson <
douglas@douglasferguson.us> wrote:
> Hey,
>
> I'm starting to look into reporting frameworks and was curious if
> anybody had successfully integrated with wicket?
>
> Are there any "off the shelf" integrations or will I have to roll my
> own?
>
> D/
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@wicket.apache.org
> For additional commands, e-mail: users-help@wicket.apache.org
>
>
Re: Reporting Framework & Wicket
Posted by Douglas Ferguson <do...@douglasferguson.us>.
Does this resource link lock the pagemap?
D/
On Oct 15, 2009, at 1:06 AM, Pieter Degraeuwe wrote:
> I had used JasperReports in de near past and was very happy with it.
> The fact that you want to use it with Wicket doesn't actually
> matter. Just
> generate a PDF/Excel with jasper and make it avilable with a
> DynamicWebResource.
>
> A sample of a DynamicWebResource can you find at
> http://www.jointeffort.nl/content/index.php?option=com_content&view=article&id=54:streaming-pdf&catid=38:wicket&Itemid=56
>
> (this is not a sample of myself, I just fount it an easy
> understandable
> sample...)
>
> On Wed, Oct 14, 2009 at 6:08 PM, Douglas Ferguson <
> douglas@douglasferguson.us> wrote:
>
>> Hey,
>>
>> I'm starting to look into reporting frameworks and was curious if
>> anybody had successfully integrated with wicket?
>>
>> Are there any "off the shelf" integrations or will I have to roll my
>> own?
>>
>> D/
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: users-unsubscribe@wicket.apache.org
>> For additional commands, e-mail: users-help@wicket.apache.org
>>
>>
>
>
> --
> Pieter Degraeuwe
> Systemworks bvba
> Belgiëlaan 61
> 9070 Destelbergen
> GSM: +32 (0)485/68.60.85
> Email: pieter.degraeuwe@systemworks.be
> visit us at http://www.systemworks.be
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@wicket.apache.org
For additional commands, e-mail: users-help@wicket.apache.org
Re: Reporting Framework & Wicket
Posted by Pieter Degraeuwe <pi...@systemworks.be>.
I had used JasperReports in de near past and was very happy with it.
The fact that you want to use it with Wicket doesn't actually matter. Just
generate a PDF/Excel with jasper and make it avilable with a
DynamicWebResource.
A sample of a DynamicWebResource can you find at
http://www.jointeffort.nl/content/index.php?option=com_content&view=article&id=54:streaming-pdf&catid=38:wicket&Itemid=56
(this is not a sample of myself, I just fount it an easy understandable
sample...)
On Wed, Oct 14, 2009 at 6:08 PM, Douglas Ferguson <
douglas@douglasferguson.us> wrote:
> Hey,
>
> I'm starting to look into reporting frameworks and was curious if
> anybody had successfully integrated with wicket?
>
> Are there any "off the shelf" integrations or will I have to roll my
> own?
>
> D/
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@wicket.apache.org
> For additional commands, e-mail: users-help@wicket.apache.org
>
>
--
Pieter Degraeuwe
Systemworks bvba
Belgiëlaan 61
9070 Destelbergen
GSM: +32 (0)485/68.60.85
Email: pieter.degraeuwe@systemworks.be
visit us at http://www.systemworks.be
Re: Reporting Framework & Wicket
Posted by nino martinez wael <ni...@gmail.com>.
True, Jfreechart only can produce images.. So it depends on your use case.
2009/10/18 Douglas Ferguson <do...@douglasferguson.us>
> I thought it also brought the capability to generate pdf and word
> docs, which I don't think JFreeChart can do..
>
> D
>
> On Oct 17, 2009, at 1:42 PM, nino martinez wael wrote:
>
> > As I see it jasper reports are just a configurable way of using
> > jfreecharts,
> > not sure it that brings more understanding though :)
> >
> >
> http://images.google.dk/images?client=firefox-a&rls=org.mozilla%3Aen-US%3Aofficial&hl=da&source=hp&q=jfreecharts&btnG=S%C3%B8g+i+billeder&gbv=2&aq=f&oq=
> >
> > 2009/10/17 Douglas Ferguson <do...@douglasferguson.us>
> >
> >> I have to admit, I've never used Jasper or NexReports, so I'm not
> >> sure
> >> I follow all of this..
> >>
> >>
> >> On Oct 15, 2009, at 10:14 AM, Decebal Suiu wrote:
> >>
> >>>
> >>> Hello,
> >>>
> >>> We use Wicket with NextReports (http://www.next-reports.com/) and
> >>> Jasper.
> >>> Basically, in Wicket you will have logic for the form that will fill
> >>> report
> >>> parameters. For Jasper we
> >>> also have a logic for edit parameters (we added more functionality
> >>> to
> >>> parameter definition that we could not find in any jasper designer
> >>> tool).
> >>>
> >>> Depending on how parameters are defined (in your report designer
> >>> tool) you
> >>> may have to add the following business :
> >>> - chained parameters (to fill children parameters if parent
> >>> parameters are
> >>> selected)
> >>> - default values (fill default values for parameters)
> >>> - hidden parameters (parameters which are substituted with their
> >>> values when
> >>> the report is ran by human process or by scheduler process)
> >>>
> >>> After the parameter values selection process , you will just have to
> >>> use the
> >>> api offered by your reporting framework.
> >>>
> >>> For example in Next it is simple as this :
> >>>
> >>> FluentReportRunner.report(report)
> >>> .connectTo(connection)
> >>> .withQueryTimeout(60)
> >>> .withParameterValues(createParameterValues())
> >>> .formatAs(ReportRunner.HTML_FORMAT)
> >>> .run(stream);
> >>>
> >>>
> >>> Douglas Ferguson-2 wrote:
> >>>>
> >>>> Hey,
> >>>>
> >>>> I'm starting to look into reporting frameworks and was curious if
> >>>> anybody had successfully integrated with wicket?
> >>>>
> >>>> Are there any "off the shelf" integrations or will I have to roll
> >>>> my
> >>>> own?
> >>>>
> >>>> D/
> >>>>
> >>>> ---------------------------------------------------------------------
> >>>> To unsubscribe, e-mail: users-unsubscribe@wicket.apache.org
> >>>> For additional commands, e-mail: users-help@wicket.apache.org
> >>>>
> >>>>
> >>>>
> >>>
> >>> --
> >>> View this message in context:
> >>
> http://www.nabble.com/Reporting-Framework---Wicket-tp25894303p25910426.html
> >>> Sent from the Wicket - User mailing list archive at Nabble.com.
> >>>
> >>>
> >>> ---------------------------------------------------------------------
> >>> To unsubscribe, e-mail: users-unsubscribe@wicket.apache.org
> >>> For additional commands, e-mail: users-help@wicket.apache.org
> >>>
> >>
> >>
> >> ---------------------------------------------------------------------
> >> To unsubscribe, e-mail: users-unsubscribe@wicket.apache.org
> >> For additional commands, e-mail: users-help@wicket.apache.org
> >>
> >>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@wicket.apache.org
> For additional commands, e-mail: users-help@wicket.apache.org
>
>
Re: Reporting Framework & Wicket
Posted by Douglas Ferguson <do...@douglasferguson.us>.
I thought it also brought the capability to generate pdf and word
docs, which I don't think JFreeChart can do..
D
On Oct 17, 2009, at 1:42 PM, nino martinez wael wrote:
> As I see it jasper reports are just a configurable way of using
> jfreecharts,
> not sure it that brings more understanding though :)
>
> http://images.google.dk/images?client=firefox-a&rls=org.mozilla%3Aen-US%3Aofficial&hl=da&source=hp&q=jfreecharts&btnG=S%C3%B8g+i+billeder&gbv=2&aq=f&oq=
>
> 2009/10/17 Douglas Ferguson <do...@douglasferguson.us>
>
>> I have to admit, I've never used Jasper or NexReports, so I'm not
>> sure
>> I follow all of this..
>>
>>
>> On Oct 15, 2009, at 10:14 AM, Decebal Suiu wrote:
>>
>>>
>>> Hello,
>>>
>>> We use Wicket with NextReports (http://www.next-reports.com/) and
>>> Jasper.
>>> Basically, in Wicket you will have logic for the form that will fill
>>> report
>>> parameters. For Jasper we
>>> also have a logic for edit parameters (we added more functionality
>>> to
>>> parameter definition that we could not find in any jasper designer
>>> tool).
>>>
>>> Depending on how parameters are defined (in your report designer
>>> tool) you
>>> may have to add the following business :
>>> - chained parameters (to fill children parameters if parent
>>> parameters are
>>> selected)
>>> - default values (fill default values for parameters)
>>> - hidden parameters (parameters which are substituted with their
>>> values when
>>> the report is ran by human process or by scheduler process)
>>>
>>> After the parameter values selection process , you will just have to
>>> use the
>>> api offered by your reporting framework.
>>>
>>> For example in Next it is simple as this :
>>>
>>> FluentReportRunner.report(report)
>>> .connectTo(connection)
>>> .withQueryTimeout(60)
>>> .withParameterValues(createParameterValues())
>>> .formatAs(ReportRunner.HTML_FORMAT)
>>> .run(stream);
>>>
>>>
>>> Douglas Ferguson-2 wrote:
>>>>
>>>> Hey,
>>>>
>>>> I'm starting to look into reporting frameworks and was curious if
>>>> anybody had successfully integrated with wicket?
>>>>
>>>> Are there any "off the shelf" integrations or will I have to roll
>>>> my
>>>> own?
>>>>
>>>> D/
>>>>
>>>> ---------------------------------------------------------------------
>>>> To unsubscribe, e-mail: users-unsubscribe@wicket.apache.org
>>>> For additional commands, e-mail: users-help@wicket.apache.org
>>>>
>>>>
>>>>
>>>
>>> --
>>> View this message in context:
>> http://www.nabble.com/Reporting-Framework---Wicket-tp25894303p25910426.html
>>> Sent from the Wicket - User mailing list archive at Nabble.com.
>>>
>>>
>>> ---------------------------------------------------------------------
>>> To unsubscribe, e-mail: users-unsubscribe@wicket.apache.org
>>> For additional commands, e-mail: users-help@wicket.apache.org
>>>
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: users-unsubscribe@wicket.apache.org
>> For additional commands, e-mail: users-help@wicket.apache.org
>>
>>
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@wicket.apache.org
For additional commands, e-mail: users-help@wicket.apache.org
Re: Reporting Framework & Wicket
Posted by nino martinez wael <ni...@gmail.com>.
As I see it jasper reports are just a configurable way of using jfreecharts,
not sure it that brings more understanding though :)
http://images.google.dk/images?client=firefox-a&rls=org.mozilla%3Aen-US%3Aofficial&hl=da&source=hp&q=jfreecharts&btnG=S%C3%B8g+i+billeder&gbv=2&aq=f&oq=
2009/10/17 Douglas Ferguson <do...@douglasferguson.us>
> I have to admit, I've never used Jasper or NexReports, so I'm not sure
> I follow all of this..
>
>
> On Oct 15, 2009, at 10:14 AM, Decebal Suiu wrote:
>
> >
> > Hello,
> >
> > We use Wicket with NextReports (http://www.next-reports.com/) and
> > Jasper.
> > Basically, in Wicket you will have logic for the form that will fill
> > report
> > parameters. For Jasper we
> > also have a logic for edit parameters (we added more functionality to
> > parameter definition that we could not find in any jasper designer
> > tool).
> >
> > Depending on how parameters are defined (in your report designer
> > tool) you
> > may have to add the following business :
> > - chained parameters (to fill children parameters if parent
> > parameters are
> > selected)
> > - default values (fill default values for parameters)
> > - hidden parameters (parameters which are substituted with their
> > values when
> > the report is ran by human process or by scheduler process)
> >
> > After the parameter values selection process , you will just have to
> > use the
> > api offered by your reporting framework.
> >
> > For example in Next it is simple as this :
> >
> > FluentReportRunner.report(report)
> > .connectTo(connection)
> > .withQueryTimeout(60)
> > .withParameterValues(createParameterValues())
> > .formatAs(ReportRunner.HTML_FORMAT)
> > .run(stream);
> >
> >
> > Douglas Ferguson-2 wrote:
> >>
> >> Hey,
> >>
> >> I'm starting to look into reporting frameworks and was curious if
> >> anybody had successfully integrated with wicket?
> >>
> >> Are there any "off the shelf" integrations or will I have to roll my
> >> own?
> >>
> >> D/
> >>
> >> ---------------------------------------------------------------------
> >> To unsubscribe, e-mail: users-unsubscribe@wicket.apache.org
> >> For additional commands, e-mail: users-help@wicket.apache.org
> >>
> >>
> >>
> >
> > --
> > View this message in context:
> http://www.nabble.com/Reporting-Framework---Wicket-tp25894303p25910426.html
> > Sent from the Wicket - User mailing list archive at Nabble.com.
> >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: users-unsubscribe@wicket.apache.org
> > For additional commands, e-mail: users-help@wicket.apache.org
> >
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@wicket.apache.org
> For additional commands, e-mail: users-help@wicket.apache.org
>
>
Re: Reporting Framework & Wicket
Posted by Douglas Ferguson <do...@douglasferguson.us>.
I have to admit, I've never used Jasper or NexReports, so I'm not sure
I follow all of this..
On Oct 15, 2009, at 10:14 AM, Decebal Suiu wrote:
>
> Hello,
>
> We use Wicket with NextReports (http://www.next-reports.com/) and
> Jasper.
> Basically, in Wicket you will have logic for the form that will fill
> report
> parameters. For Jasper we
> also have a logic for edit parameters (we added more functionality to
> parameter definition that we could not find in any jasper designer
> tool).
>
> Depending on how parameters are defined (in your report designer
> tool) you
> may have to add the following business :
> - chained parameters (to fill children parameters if parent
> parameters are
> selected)
> - default values (fill default values for parameters)
> - hidden parameters (parameters which are substituted with their
> values when
> the report is ran by human process or by scheduler process)
>
> After the parameter values selection process , you will just have to
> use the
> api offered by your reporting framework.
>
> For example in Next it is simple as this :
>
> FluentReportRunner.report(report)
> .connectTo(connection)
> .withQueryTimeout(60)
> .withParameterValues(createParameterValues())
> .formatAs(ReportRunner.HTML_FORMAT)
> .run(stream);
>
>
> Douglas Ferguson-2 wrote:
>>
>> Hey,
>>
>> I'm starting to look into reporting frameworks and was curious if
>> anybody had successfully integrated with wicket?
>>
>> Are there any "off the shelf" integrations or will I have to roll my
>> own?
>>
>> D/
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: users-unsubscribe@wicket.apache.org
>> For additional commands, e-mail: users-help@wicket.apache.org
>>
>>
>>
>
> --
> View this message in context: http://www.nabble.com/Reporting-Framework---Wicket-tp25894303p25910426.html
> Sent from the Wicket - User mailing list archive at Nabble.com.
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@wicket.apache.org
> For additional commands, e-mail: users-help@wicket.apache.org
>
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@wicket.apache.org
For additional commands, e-mail: users-help@wicket.apache.org
Re: Reporting Framework & Wicket
Posted by Decebal Suiu <de...@gmail.com>.
Hello,
We use Wicket with NextReports (http://www.next-reports.com/) and Jasper.
Basically, in Wicket you will have logic for the form that will fill report
parameters. For Jasper we
also have a logic for edit parameters (we added more functionality to
parameter definition that we could not find in any jasper designer tool).
Depending on how parameters are defined (in your report designer tool) you
may have to add the following business :
- chained parameters (to fill children parameters if parent parameters are
selected)
- default values (fill default values for parameters)
- hidden parameters (parameters which are substituted with their values when
the report is ran by human process or by scheduler process)
After the parameter values selection process , you will just have to use the
api offered by your reporting framework.
For example in Next it is simple as this :
FluentReportRunner.report(report)
.connectTo(connection)
.withQueryTimeout(60)
.withParameterValues(createParameterValues())
.formatAs(ReportRunner.HTML_FORMAT)
.run(stream);
Douglas Ferguson-2 wrote:
>
> Hey,
>
> I'm starting to look into reporting frameworks and was curious if
> anybody had successfully integrated with wicket?
>
> Are there any "off the shelf" integrations or will I have to roll my
> own?
>
> D/
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@wicket.apache.org
> For additional commands, e-mail: users-help@wicket.apache.org
>
>
>
--
View this message in context: http://www.nabble.com/Reporting-Framework---Wicket-tp25894303p25910426.html
Sent from the Wicket - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@wicket.apache.org
For additional commands, e-mail: users-help@wicket.apache.org
Re: Reporting Framework & Wicket
Posted by nino martinez wael <ni...@gmail.com>.
I've been using jasper reports, in conjunction with ireport
http://jasperforge.org/plugins/mwiki/index.php/Ireport/Product_Tour . Giving
a powerful combo, you can give the possibility to let your users design
their own reports. Almost in line with some of the software from SAS
Institute (though it depends on your backing service). For simpler stuff I
just use jfreechart. Like here
http://exerciselog.eu/products/cache/true/locale/en/ it's really simple and
have a lot of different charts.
2009/10/14 Douglas Ferguson <do...@douglasferguson.us>
> Hey,
>
> I'm starting to look into reporting frameworks and was curious if
> anybody had successfully integrated with wicket?
>
> Are there any "off the shelf" integrations or will I have to roll my
> own?
>
> D/
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@wicket.apache.org
> For additional commands, e-mail: users-help@wicket.apache.org
>
>