I'm trying to pass a parameter to a Jasper report through ART but I can't get the report to recognize it. Has anyone successfully done this? I have the parameter defined in ART in the same case as I have it defined in the report. Is there a setting somewhere I'm missing?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Thanks, the demo database and sample reports helped me find out what I was doing wrong. I was listing the parameters in the source, but I didn't have them surrounded by '#'. Once I did that, it works now.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I'm trying to pass a parameter to a Jasper report through ART but I can't get the report to recognize it. Has anyone successfully done this? I have the parameter defined in ART in the same case as I have it defined in the report. Is there a setting somewhere I'm missing?
This does work. You can check the sample/demo database, I believe at least one of the jasper report samples should have a parameter.
If you still can't get it to work, you'd need to provide more details on the ART query and jasper report to help troubleshoot.
Thanks, the demo database and sample reports helped me find out what I was doing wrong. I was listing the parameters in the source, but I didn't have them surrounded by '#'. Once I did that, it works now.
Glad to hear.
Where did you surrond parameters? Are you in jasper defined parameters with #?
No. Surround parameters with # within ART.
Tnx. I dinn't know that I have to write SQL code (write just parameters) although use jasper report