Really.................,
 
I Do really appreciate for entire Jasper team sending me the the vital clues & notes shared by gloabal
developers while empowering their skill by adopting Jasper as a big reporting tool for genearting varous 
report on different platform.
 
 
Thanks a Lot,
 
Deepak Sharma
09213467885
 
On 3/26/10, jasperreports-questions-request@lists.sourceforge.net <jasperreports-questions-request@lists.sourceforge.net> wrote:
Send jasperreports-questions mailing list submissions to
       jasperreports-questions@lists.sourceforge.net

To subscribe or unsubscribe via the World Wide Web, visit
       https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
or, via email, send a message with subject or body 'help' to
       jasperreports-questions-request@lists.sourceforge.net

You can reach the person managing the list at
       jasperreports-questions-owner@lists.sourceforge.net

When replying, please edit your Subject line so it is more specific
than "Re: Contents of jasperreports-questions digest..."


Today's Topics:

  1. Re: Problem with subreport (kapv)
  2. Re porting from the Cloud? (The Service Manager)
  3. Re: Problem with subreport (Davinir F Campos Jr)
  4.  two graph (Billa007)
  5. Jasper report execution in java with      parametrized query at
     run time (Abhijit Kamatkar)
  6. Re: Jasper report execution in java with  parametrized query
     at run time (Rajesh Pandian M)
  7. Re: Jasper report execution in java with  parametrized query
     at run time (David Bolen)


----------------------------------------------------------------------

Message: 1
Date: Mon, 22 Feb 2010 04:52:12 -0800 (PST)
From: kapv <pavel@kangin.org>
Subject: Re: [jasperreports-questions] Problem with subreport
To: jasperreports-questions@lists.sourceforge.net
Message-ID: <27686750.post@talk.nabble.com>
Content-Type: text/plain; charset=us-ascii




kapv wrote:
>
> Hello!
>
> I have master report that contains only details band. In this band I put
> subreport, and when I generate subreport separatly it works fine and
> subreport fit whole page and page footer at bottom. When I generate master
> report, subreport footer doesn`t fit bottom page.
>
> How to fit subreport footer to the bottom of master report datails band?
>

Problem resolved!
--
View this message in context: http://old.nabble.com/Problem-with-subreport-tp27685878p27686750.html
Sent from the jasperreports-questions mailing list archive at Nabble.com.




------------------------------

Message: 2
Date: Thu, 25 Feb 2010 14:56:15 -0800 (PST)
From: The Service Manager <david@theservicemanager.com>
Subject: [jasperreports-questions] Re porting from the Cloud?
To: jasperreports-questions@lists.sourceforge.net
Message-ID: <27714545.post@talk.nabble.com>
Content-Type: text/plain; charset=us-ascii


Hi,

I am new to Jasper so perhaps what I am asking is obvoius but I have the
following scenario and want to know how to go about implementing it:

1. Hosted cloud computing commercial (not inhouse) application with
monolithic secure database serving multiple companies written in Servoy.

2. Each company must only see their own data.

3. Must allow any user to report on data from our application

4. Users are able to customise their reports some how from the server.

So,

- How do they get to the report to customise?

- How do they send the customisations back to the server?

- Where do we store the customisations inluding logos etc?

- What are the security implications?

- Do they need to load iReports or something else locally to do the
customisations or can we access something on the cloud for a secure rpeort
customisation envuironment?

- How do we pass over the database schema etc in order for them to customise
the reports?

- And finally, these users are not Jasper experts so I would ideally like to
provide a canned , simplified environment for them to make these
customisations.

I would imagine the above to be a typical example of reporting issues being
faced by any company hosting a multi-copany commercial application in the
cloud that requires user customisable reporting.

Hope someone can help.

Cheers

David Younger
david@theservicemanager.com
+61403392363



--
View this message in context: http://old.nabble.com/Reporting-from-the-Cloud--tp27714545p27714545.html
Sent from the jasperreports-questions mailing list archive at Nabble.com.




------------------------------

Message: 3
Date: Mon, 15 Mar 2010 09:47:01 -0300
From: Davinir F Campos Jr <davinir.jr@gmail.com>
Subject: Re: [jasperreports-questions] Problem with subreport
To: jasperreports-questions@lists.sourceforge.net
Message-ID:
       <8848afa01003150547q66d324a5r82ded0bef34538ba@mail.gmail.com>
Content-Type: text/plain; charset="iso-8859-1"

Could you post the solution, please?

Someone may need the answer, and posting keep things registered.

Thanks,
Davinir

2010/2/22 kapv <pavel@kangin.org>

>
>
>
> kapv wrote:
> >
> > Hello!
> >
> > I have master report that contains only details band. In this band I put
> > subreport, and when I generate subreport separatly it works fine and
> > subreport fit whole page and page footer at bottom. When I generate
> master
> > report, subreport footer doesn`t fit bottom page.
> >
> > How to fit subreport footer to the bottom of master report datails band?
> >
>
> Problem resolved!
> --
> View this message in context:
> http://old.nabble.com/Problem-with-subreport-tp27685878p27686750.html
> Sent from the jasperreports-questions mailing list archive at Nabble.com.
>
>
>
> ------------------------------------------------------------------------------
> Download Intel&#174; Parallel Studio Eval
> Try the new software tools for yourself. Speed compiling, find bugs
> proactively, and fine-tune applications for parallel performance.
> See why Intel Parallel Studio got high marks during beta.
> http://p.sf.net/sfu/intel-sw-dev
> _______________________________________________
> jasperreports-questions mailing list
> jasperreports-questions@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
>
-------------- next part --------------
An HTML attachment was scrubbed...

------------------------------

Message: 4
Date: Wed, 17 Mar 2010 11:03:13 -0700 (PDT)
From: Billa007 <thasan_m@hotmail.com>
Subject: [jasperreports-questions]  two graph
To: jasperreports-questions@lists.sourceforge.net
Message-ID: <27933829.post@talk.nabble.com>
Content-Type: text/plain; charset=us-ascii


Hi All,

I have problem displaying two html reports in one page.

I have 2 jasper report graphs and in my html page
I have 2 iframes to display both graphs.

but the image of the graph seem to be the same for both reports, yet if I
refresh iframe then I get the correct graph.

the problem seem to be that both get invoke using the same servlet at the
same time.. so it's getting the same image for both graphs.

http://domain.com/serlimage?type=agraph1&time=1268848064395&image=img_0_0_0

http://domain.com/serlimage?type=agraph2&time=1268848064470&image=img_0_0_0

can some please help me resolve this.

THank you,
--
View this message in context: http://old.nabble.com/two-graph-tp27933829p27933829.html
Sent from the jasperreports-questions mailing list archive at Nabble.com.




------------------------------

Message: 5
Date: Thu, 25 Mar 2010 12:50:48 +0530
From: Abhijit Kamatkar <abhijitkamatkar@gmail.com>
Subject: [jasperreports-questions] Jasper report execution in java
       with    parametrized query at run time
To: jasperreports-questions@lists.sourceforge.net
Message-ID:
       <1506ecf61003250020y10fbcafeuf8351b536f051995@mail.gmail.com>
Content-Type: text/plain; charset="iso-8859-1"

Hello,

I have been working on Jasper Reports. I have created few reports using
ireport and I was able to export these reports within java. Of course these
reports were simple. Now I want to get deeper in Jasper reports. I want to
know how one can execute jasper report in java with parametrized query at
run time. Has anyone worked on similar module? Do we need to create any .xml
at runtime for this? Right now the Jrxml file contains the query which was
written in the context while designing the report. Now, I want to run the
query dynamically. I am looking forward for your suggestions and advices.
Thank you in advance.

Best regards.
-------------- next part --------------
An HTML attachment was scrubbed...

------------------------------

Message: 6
Date: Fri, 26 Mar 2010 00:56:09 +0530
From: Rajesh Pandian M <mrpraj@gmail.com>
Subject: Re: [jasperreports-questions] Jasper report execution in java
       with    parametrized query at run time
To: Abhijit Kamatkar <abhijitkamatkar@gmail.com>
Cc: jasperreports-questions@lists.sourceforge.net
Message-ID:
       <606a3ec11003251226x33a40295kc2dc335e61bdb6c6@mail.gmail.com>
Content-Type: text/plain; charset="iso-8859-1"

On Thu, Mar 25, 2010 at 12:50 PM, Abhijit Kamatkar <
abhijitkamatkar@gmail.com> wrote:

> Hello,
>
> I have been working on Jasper Reports. I have created few reports using
> ireport and I was able to export these reports within java. Of course these
> reports were simple. Now I want to get deeper in Jasper reports. I want to
> know how one can execute jasper report in java with parametrized query at
> run time. Has anyone worked on similar module? Do we need to create any .xml
> at runtime for this?

Right now the Jrxml file contains the query which was written in the context
> while designing the report. Now, I want to run the query dynamically. I am
> looking forward for your suggestions and advices. Thank you in advance.
>

AFAIK it not necessary to create an xml file.
there are two options,
1. have the query executed before going to jrxml file and get the resultset
instance, wrap it with jrresultsetdatasource. then create report
2. have the query in jrxml file itself. and just pass the Hash Map instance
of all the parametrized[dynamic] values to jrxml

--
Rajesh Pandian M
http://mrprajesh.blogspot.com/
http://twitter.com/mrprajesh
-------------- next part --------------
An HTML attachment was scrubbed...

------------------------------

Message: 7
Date: Thu, 25 Mar 2010 15:41:43 -0400
From: David Bolen <db3l.net@gmail.com>
Subject: Re: [jasperreports-questions] Jasper report execution in java
       with    parametrized query at run time
To: jasperreports-questions@lists.sourceforge.net
Message-ID: <m2iq8kjiiw.fsf@valheru.db3l.homeip.net>
Content-Type: text/plain; charset=us-ascii

Abhijit Kamatkar <abhijitkamatkar@gmail.com> writes:

> I have been working on Jasper Reports. I have created few reports using
> ireport and I was able to export these reports within java. Of course these
> reports were simple. Now I want to get deeper in Jasper reports. I want to
> know how one can execute jasper report in java with parametrized query at
> run time. Has anyone worked on similar module?

If you've already gotten the basics of running the report from within
a piece of Java code then you're most of the way there.

All you need to do to add parameter support to your existing code is
to supply any necessary parameters (as a java.util.Map) to
JasperFillManager.fillReport, and those parameters will be available
to the report.

How you go about obtaining those parameters is very dependent on the
environment in which your Java code is running.  If it's a command
line application you might take parameters from the command line,
whereas a web server might take it from the URL or form data.  You
could opt to have some way of referring to an input file containing
the parameters, whether in XML or some other format.  But in any case,
and via any mechanism you prefer, you're responsible for obtaining the
parameters and turning them into the Map that you give to
fillReport().

As an example, to support my own use of JasperReports (a back-end PDF
report generator for a web application), I implemented a small web
application - that I run beneath Jetty - that listened on an internal
loopback port.  My main application isn't in Java, so I needed some
clean way for it to use the report server to generate reports when
needed.

I initial experimented with a command line utility but the web
application avoids the overhead of loading the Java runtime and
establish the database connections for each report request.  As it is
the Jetty-based report server has a footprint several times larger
than my entire main application, though I'm not complaining since it
does the reporting job well.

My main web application internally generates web requests (essentially
does its own GETs from localhost) to the report server, and the report
server's GET handler then:

1. Uses the last segment of the URL to identify the report name.
2. Identifies the jrxml and jasper files for that report (from a
    configured filesystem root location)
3. If the jrxml is later than the jasper, recompiles the report
    (JasperCompileManager.compileReportToFile).
4. Takes any query parameters from the URL and turns them into a
    HashMap.  For simplicity all parameters are passed on to
    fillReport as a string.
5. Fills the report (including the parameter map)
6. Streams the result back to the requester as a PDF using
    JasperExportManager.exportReportToPdfStream.  The main application
    typically just passes this stream right back to the client.

During initial experimentation, I simplified things a little by
skipping step 3 and just directly loading jasper files built in
iReport.  This works as long as your iReport and JasperReports library
versions are reasonably in sync.

Note also that, in general, step 4 could be an opening to a SQL
injection attack depending on how parameters are supplied and used.
In my case, the only client to the reporting server is my own web
application which has either generated the parameters internally, or
already sanitized/validated any parameters from the client browser.

I found it easier to implement all parameters as strings since that
simplified the URL needed to the reporting server.  But if I had
needed accurate type information I could have encoded that in the URL
and then instantiated appropriately typed objects to supply as
parameters.

-- David






------------------------------

------------------------------------------------------------------------------
Download Intel&#174; Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev

------------------------------

_______________________________________________
jasperreports-questions mailing list
jasperreports-questions@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jasperreports-questions


End of jasperreports-questions Digest, Vol 41, Issue 2
******************************************************