Can u please suggest some documentation to look at for deploying the
jasperreports. I am new to ofbiz and that would be greatly helpful.
Regards,
Ravi.
On Fri, 2008-01-18 at 05:09 -0800, Mathius Allo wrote:
> You can either query and prepare the data in OFBiz (this is what i'm
> currently doing) and then pass it to JasperReport or you can pass your query
> parameters to JasperReport then use them to query your datasource from
> JasperReport.
>
> ----- Original Message ----
> From: Ravi Subramanian <[EMAIL PROTECTED]>
> To: user@ofbiz.apache.org
> Sent: Friday, January 18, 2008 6:30:36 PM
> Subject: Re: Deploy custom jasperreports in ofbiz
>
> Thanks for that information Mathius.
>
> I have a query and i need to execute it to get the dataset. How can i do
> that?
>
> Thanks,
> Ravi.
>
>
> On Fri, 2008-01-18 at 00:20 -0800, Mathius Allo wrote:
> > As per the documentation, you need to put a jrDataSource into the request
> > as an attribute. If you need to pass parameters to your report then you
> > would also need to put a jrParameters into the request.
> >
> > Whether you are using java or beanshell you need to put the following into
> > request:
> > request.setAttribute("jrDataSource", jrDataSource);
> > request.setAttribute("jrParameters", jrParameters);
> >
> > How I do it java:
> > ...........
> > // pass parameters to report
> > Map jrParameters = new HashMap();
> >
> > jrParameters.put("author", userLoginId);
> >
> >
> >
> > // in this case, i'm trying to pass list of projects to my jasper
> > report
> > JRDataSource jrDataSource = null;
> >
> > if(projects != null && projects.size() > 0) {
> > // i'm using JRMapCollectionDataSource
> >
> > jrDataSource = new JRMapCollectionDataSource(projects);
> >
> > }
> >
> > request.setAttribute("jrDataSource", jrDataSource);
> >
> > request.setAttribute("jrParameters", jrParameters);
> >
> > You may also want to check out the following code to give you better
> > understanding:
> > 1. JasperReportsPdfViewHandler.java
> > 2. JREntityListIteratorDataSource.java
> > 3. JRMapCollectionDataSource.java
> >
> > Regards,
> > Mathius Allo
> >
> > ----- Original Message ----
> > From: Ravi Subramanian <[EMAIL PROTECTED]>
> > To: user@ofbiz.apache.org
> > Sent: Friday, January 18, 2008 1:32:56 PM
> > Subject: Re: Deploy custom jasperreports in ofbiz
> >
> >
> > I have not prepared the data. There is a query in the JRXML and i
> > thought it gets executed and the data is retreived.
> >
> > Now i checked on the document
> >
> > http://www.opentaps.org/docs/index.php/Using_JasperReports_with_opentaps
> >
> > and it says I need to prepare the data using a beanshell script. I
> > looked at some of the reports in the order application and i couldnt
> > make out what the code does. Can u please help me by providing some
> > documentation on how to populate the data using the beanshell script or
> > with java.
> >
> > Thanks,
> > Ravi.
> >
> >
> >
> >
> >
> >
> >
> >
> > ____________________________________________________________________________________
> > Looking for last minute shopping deals?
> > Find them fast with Yahoo! Search.
> > http://tools.search.yahoo.com/newsearch/category.php?category=shopping
>
>
>
> ____________________________________________________________________________________
> Looking for last minute shopping deals?
> Find them fast with Yahoo! Search.
> http://tools.search.yahoo.com/newsearch/category.php?category=shopping
