cmcconnell
-
Posts
1 -
Joined
-
Last visited
Content Type
Profiles
Forum
Events
Featured Visualizations
Knowledge Base
Documentation (PDF Downloads)
Blog
Documentation (Test Area)
Documentation
Dr. Jaspersoft Webinar Series
Downloads
Everything posted by cmcconnell
-
Selecting parameter from values of a SQL Query
cmcconnell replied to brommycanary's topic in Products
"The special $X{IN} syntax in your WHERE clause will help your query determine whether or not a specific companyTable.Id value should or should not be selected based on whether or not it is contained in that list in $P{companyList}." This report and $X{} parameter works wonderfully in iReports, but when uploaded to jasperreports I am getting error... java.lang.Exception: 1 - Incompatible java.lang.String value assigned to parameter 'name of parameter' in the 'name of report' dataset. I have changed the parameter (which is an ID field - math.bigDecimal) to string (to_char in query) and still get the same error. It is a simple report - with a simple single select query parameter. Basically just select customer name - value column is cust_id. Any ideas???
