Date Selection

[pomster]

I have a report looking at @customers (Group 1) and @Contract (Group 2)

I need to select Customers based on a Contract Start Month. A Customer with multiple Contracts may have Contracts starting in different months.

If one of a Customers Contracts starts in a given month, I want to return all Contracts for that Customer.

Thanks in advance..



regards,


David

CRXIR2 with CRXIR2 server and SQL 2005
CR2008 with CR2008V1 Server and SQL 2005

 

[Charliy]

I would set up a main report that selects {table.contract_start} in {?Begin Date} to {?End Date}
Then set up a subreport, linked on Customer ID, to show all the contracts for that customer.