Parameter Field in Subreport

[cabrera01]

I currently have a report that is pulling information off a 2005 SQL Server. I am trying to get the total number of tickets and work-orders for a given department. I have all the information I need for the tickets in the main report and all the information for the work orders in the subreport. My problem is that I'm trying to get all the tickets and work orders within a specific date range.

Whether it is a ticker or work order, each one has an open date and a closed dated. In the main report I created 2 parameters; Opened Tickets and Closed Tickets; and used this code to retrieve through a date range:
{Ticket.Open Date & Time} in {?Opened Tickets} to {?Closed Tickets}.

I go to the subreport links and link the ticket.open datetime to the work_order.datetime. This just gives me all the work orders that were opened on the days that tickets were opened and nothing else when I run it.

How can I properly link the subreport to the main report so that I can prompt the user once for a Begin and End date range and get all the information I need?

 

[lbass]

Create the same parameters within the sub, and then link them to the main report parameters, by using the dropdown in the lower left of the linking screen to select {?Opened Tickets} instead of the default {?pm-?Opened Tickets}. Link both parameters, and then in the sub, create a record selection formula similar to that in the main report, just using the workorder dates.

-LB