Criteria page in JaspreIntelligence

Posted on November 6, 2006 at 10:31am
Hello,

I have a criteria page with an input control(dropdown list), which links to the report. So when I select a value from the drop down, I get the report with the data matching the criteria. So far I am able to hard code the values into drop down list. Is there any way I can get the values from the table into the drop down list? Can anyone please help me?

Thanks in advance,
MohanRao.
JasperReports® Server
MohanRao's picture
MohanRao
51
Joined: Nov 5 2006 - 7:25pm
Last seen: 16 years 11 months ago

4 Answers:

Posted on November 6, 2006 at 1:10pm
When you add the input control specify the type as single select query.
rx7haze's picture
rx7haze
37
Joined: Oct 6 2006 - 3:11am
Last seen: 16 years 12 months ago
Posted on November 6, 2006 at 2:09pm
Hi Thanks a lot. I am able to get the values from the database.

rx7haze wrote:
When you add the input control specify the type as single select query.
MohanRao's picture
MohanRao
51
Joined: Nov 5 2006 - 7:25pm
Last seen: 16 years 11 months ago
Posted on May 17, 2012 at 2:44am

 Hi..

I am using single select query input control.It seems that it is filling with values from database but the values displayed are either [NULL] or Blank.

 

Please help me knowing problem and its solution..Its really very urgent.

 

Thanks in Advance.

Mandeep

ermandeep_singh's picture
ermandeep_singh
182
Joined: May 14 2012 - 8:39am
Last seen: 11 years 4 months ago
Posted on May 17, 2012 at 8:10am

 ermandeep_singh,

I posted an answer in the thread you created, http://jasperforge.org/plugins/espforum/view.php?group_id=112&forumid=102&topicid=98127.

For information on creating input controls from the JasperServer UI check the Jasper Reports User Guide section 3.3.2 http://jasperforge.org/espdocs/docsbrowse.php?id=87&type=docs&group_id=112&fid=365

 

Mariano

marianol's picture
marianol
17634
Joined: Sep 13 2011 - 8:04am
Last seen: 4 years 12 months ago
Feedback
randomness