Save Query to Report Button?

0
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...
2004 IR Help's picture
Joined: Aug 17 2006 - 3:49am
Last seen: 8 years 3 months ago

Answers:

No answers yet
Feedback