rodonell
-
Posts
2 -
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
Posts posted by rodonell
-
-
I'm using the latest version of Jasper Server and I'm trying to setup multiple input controls for the reports, but I can't seem to get one control to reference another. For example, I'm creating a report which will list information on a particular employee, so one control will be a Single-Select Query which will grab all possible department names from a table, and the second will be another Single-Select Query which will list all employee names based on the department chosen from the first control. I tried to reference the direct name, so the query would have "WHERE department_name = P_Department_Name" (where P_Department_Name is what I called the first control), I also tried to refence it as $P{P_Department_Name} like iReports but no go. Is this currently possible in JasperServer? Thanks for your time.
Sincerely,
Ricardo O'Donell
Single select querry
in Products
Posted
I'm having the opposite problem, when you don't click on something in the drop-box box it doesn't display anything. How did you structure your WHERE statement and parameter to get that to happen? Thanks.