I have report. I am creating that report with the SQL query directly. I am not using any package. In that SQL I have WHERE conditions. Like date between 'FROM_DATE' and 'TO_DATE'
The FORM_DATE is fixed it won't be change.
The TO_DATE is vary. For this I had written on function to get the date dynamically.
So the report have the FROM_DATE and will take the TO_DATE dynamically and it will give the result.
My problem is I want to display the FROM_DATE and TO_DATE on the report page.
Here also FROM_DATE is fixed, but I want to get the TO_DATE dynamically (automatically). How it is.
Your help will be appriciated.
Thanks in advance
Sarayu
Quote from: Sarayucog on 26 Jul 2010 06:26:18 AMI have report. I am creating that report with the SQL query directly. I am not using any package.
Why would you cause yourself such headaches by doing this?
Quote from: Sarayucog on 26 Jul 2010 06:26:18 AMThe TO_DATE is vary. For this I had written on function to get the date dynamically.
So the report have the FROM_DATE and will take the TO_DATE dynamically and it will give the result.
Can you explain what you mean by this? Did you add a prompt macro to the SQL? Are you using any parameters?
Quote from: Sarayucog on 26 Jul 2010 06:26:18 AMMy problem is I want to display the FROM_DATE and TO_DATE on the report page.
Here also FROM_DATE is fixed, but I want to get the TO_DATE dynamically (automatically). How it is.
If you are using a prompt macro to inject TO_DATE, simply add a layout calculation that references the relevant parameter used in the prompt.
If not, add a singleton query that calls the same functionality as the main query to derive the TO_DATE.
MF.
Ur question is from_date is fixed and to_date should display in the report header automatically
s it is possible by using sysdate or report date from functions in the layout calculation in the place of to_date cal..........