First of all sorry if the question is dumb or if the syntax/vocabulary is not right (still kinda new to CR)

Here is my case:

I have a report, with one data source.

Within this report I need to list some numbers (basically just a count) of a number of objects within 2 given dates (so far, easy)

When I build my first query, the start date and end date are both parameters that are provided by the user.

Basically I need to use the same dates for all my counts (joining tables is not really an option):

in other words:

select count(documents) from Documents where date between 'start' and 'end'

select count (ticket) from Tickets where date between 'start' and 'end'

I want to avoid having the user input the same values twice.

I'm thinking this case must have stroke someone before and I'm looking on advice on the best way to proceed.

Thanks in advance.

T.

Are you suing subreports or not here?