More queries in the same report?

[pool]

Hi all, I need to design such a report:

- Report Title: Activities from start_date to end_date
- Report details: Name , Activity_description , total number of those activities performed in the dates interval

The problem I cannot solve is that start_date and end_date are stored in a parameters_table.

So I have such a query:
select Name , activity_description , count(*) from activities
where activity_date between parameters_table.start_date and parameters_table.end_date
group by Activity_description

In this way I don't have the fields start_date and end_date that I should use in the report title. I need one more query:

select start_date , end_date from parameters_table

to define these fields. How may I do it?
I cannot use parameters, because I need to schedule the report and I have no users to input parameters values; the dates interval must be stored in the parameters table.

Thank you for your help.

Andrea
 

 

 

[chenny]

Andrea,

Just modify your sql query into query within query.

Rgds