[Total page problem (a bit urgent, but simple)]

Hi all!

 

I have a problem trying to add Total Page variable on report.

 

Variable $V{PAGE_NUMBER} defined as total number of pages in Library window, always returns current page.

 

Where can be a problem with that? Am I using vrong variable?

 

 

Thank you in advance!

[How can I suggest reports Print Name?]

Hi all!

 

I can create nice report with jasperReports, and to preview it before printing.

 

How can I suggest report file name and extension, when I want to save it from PrintPreviw layout? I wolud like to have a suggestion, and to set default type as pdf.

 

Thank you in advance!

Post edited by: booyeeka, at: 2006/10/29 10:45

[Parametar from subreport on main report]

Hi all!

 

Can you help me how to use a value (ie. ID of selected record in subquery), in a main report? How to pass that data from subreport to main report?

 

 

Thank you in advance!

[howto submit entire query as parameter?]

Hey Sven!

 

I did manage to solve our problem.

 

You can check my post here:

 

http://www.jasperforge.org/index.php?option=com_joomlaboard&Itemid=215&func=post

[Sending SQL query from Java application]

It looks like I did manage to solve my problem.

 

In Jasper Report Query, I defined parameter as :

 

$P!{EMPID}

 

 

... and it works good.

 

 

I post this, because I noticed that a lot of JasperReports user have same problem.

 

But BTW, JasperReports really rocks!

[howto submit entire query as parameter?]

Hello Sven,

 

I have the same problem.... Did you manage to find the solution for this?

 

 

Thank you in advance!

[Sending SQL query from Java application]

Hi all!

 

Can you help me how to send complete SQL query into JasperReports, from Java code.

 

If in Java code I send (put) one parameter, like:

 

Code:

String empid = "3";
reportParam.put("EMPID", empid);

 

... this example works, by a simple call of next query in Jasper's XML file:

 

Code:

[code] select * from employees where Employee_ID = $P{EMPID}

 

BUT, when I try to call query in java file like :

 

Code:

[code] String empid = "select * from employees where Employee_ID = 3"; reportParam.put("EMPID", empid);

 

... with $P{EMPID} only defined in jasper file, I get the following error:

 

Code:

[code] java.lang.NullPointerException

 

 

Can you tell me where is my mistake?

 

Thank you in advance!