default parameter from query for scheduler

[ddaly]

Hi,

 

I am trying to do something similiar to the problem and solution http://www.jasperforge.org/index.php?option=com_joomlaboard&Itemid=&func=view&catid=10&id=33938#33938

 

However, I need the default for the parameter to be the result of a database query. Instead of the current date, I am trying to default the current fiscal period. I can get this from the database with a query which returns the one value.

 

The basic problem is:

The report needs to have a parameter which allows the user to enter the fiscal period for the report. If the parameter is left blank, the report needs to assume the current period for the parameter. (When setting up the scheduled report the parameter would be left blank.)

 

Can this be done? If so how?

 

Thanks,

Daryl.