uouser
-
Posts
29 -
Joined
-
Last visited
Content Type
Profiles
Forum
Events
Featured Visualizations
Knowledge Base
Documentation (PDF Downloads)
Blog
Documentation (Test Area)
Documentation
Dr. Jaspersoft Webinar Series
Security Advisories
Downloads
Everything posted by uouser
-
I am trying to run a query in which my parameter is used in the select clause of the query. The query i am using is similar to the one i have pasted in code area. Anybody having a clue how to use parameter in select clause? When i read fields, it puts null instead of the parameter value. The query is parsed successfully and when i run the report i got error while filling the report which is "Unknown column name : if(date_of_invoice >= null, '1', '0')"Please help. Thanks. Code:SELECT if(date_of_invoice >= $P{para}, '1', '0')FROM supplier_payment_invoicesWHEREBlock_ID = 10
-
Hi, I have created two reports. One is master report and one is subreport. I have created 3 parameters in master report and 3 in subreport. 1 is Integer and 2 are java.util.Date. The database query i use in master report uses integer parameter and i want to pass the same parameters to subreport to generate my main data in details section of the master report. when i run the report i got error like: I use ireport wizard for my subreport and map subreport parameters to the parameters of my master report. The error i got is in code section. Please help :). Thanks. Sumair. Code:
