HowTo: Create param with sql to retrieve valu

[2006 IR Open Discussion]

By: pea - misterpea

HowTo: Create param with sql to retrieve valu

2006-05-21 23:37

Hi All,

 

I have a parent report, which contains a few subreports.

The parent report and subreports all contain parameters fromDate and toDate. All data is retrieved based on the fromDate and toDate criteria.

 

I want to use the parent report to run on a weekly schedule, so instead of allowing the user to input the fromDate and toDate values, I want to use SQL to use as values for these parameters.

 

That is ...

 

fromDate = select to_char(TRUNC(SYSDATE -2) + 00/24, 'dd-mm-yyyy hh24:mi') from dual;

 

toDate = select to_char(TRUNC(SYSDATE)+ 00/24, 'dd-mm-yyyy hh24:mi') from dual;

 

How do I do this?

I've read these posts:

 

http://sourceforge.net/forum/message.php?msg_id=3041269

 

http://sourceforge.net/forum/message.php?msg_id=3733276

 

But they don't say how.

I've also read the iReport manual (the big one!) but haven't found a solution yet :(

 

Anyone tried this before?

 

Nic

 

 

By: pea - misterpea

RE: HowTo: Create param with sql to retrieve

2006-05-22 18:04

ignore!

 

i'm using OpenReports in conjuction with iReports.

OpenReports allows me to create parameters, which values are retrieved from a database.

 

sorry! :$

 

nic