Save Query to Report Button?

[2004 IR Help]

By: mir_shajahan - comp_shajahan

Save Query to Report Button?

2004-10-20 20:34

Hello all...

 

I am just trying to follow the interactive tutorial on pasing parameter in iReport. I am using iReport 0.4

 

In the tutorial (Report Query Window) there is a button called [save Query to Report] and in iReport 0.4 it is [send to Clipboard].

 

In my Report Query Window, I have the following SQL:-

 

SELECT * FROM C_Project

 

It works fine. But when I add in the following SQL:-

 

SELECT * FROM C_Project

WHERE C_Project_ID = $P{C_Project_ID)

 

it give me this error:

 

SQL problems:Non supported SQL92 token at position: 60: C_Project_ID

 

and i cannot click [save query to Report] because that button does not exist and replace with [send to Clipboard] button. Is this button are the same function?

 

Even I cannot click OK button, and have to remove the where clause to continue...thus I cannot create a parameter in my report. What should I do? Can anybody help me on this matter.

 

Thank you...

 

< aMir >>

 

 

 

 

By: mir_shajahan - comp_shajahan

RE: Save Query to Report Button?

2004-10-20 21:07

Hai...

 

I test the following SQL code in Report Query Window and it works:-

 

SELECT * FROM C_Project

WHERE C_Project.C_Project_ID = 1000014

 

But when I want to make the like this:-

WHERE C_Project.C_Project_ID = $P{C_Project_ID}

 

It wont works and give the follwing error:-

SQLproblems:Non supported SQL92 token at position 70: C_Project_ID

 

The same thing happening...how can I solve this?

 

 

 

 

By: birdz - birdz

RE: Save Query to Report Button?

2004-10-22 04:34

Hi,

 

I think you have to put a "Default value expression" for your parameter. For example : new Double(1.0).

I had the same problem (SQL92 token at position...) and now it works...