hi

i have a report that i want to add a sub report to which will run with the primary report and return results based on the Sales order number in the primary report..

the sub report also contains a field called sales order number and is a standalone report that i have created - i have simply added a pre existing report as the sub report..

in the primary report i have linked the sub report by right clicking on the sub report box and selecting "Change sub report links" - here i have selected sales order from the primary and the corresponding sales order in the sub report - but the sub report returns nothing!?

if i manually pass a variable to the sub report it will run fine

any one any ideas?

Try adding formula in select expert in sub-report something like below:
{Table.Sales_order_number} = {?Pm-Table.Sales_order_number}

If not try:
change subreport links-> Uncheck select data in sub report based on field
and follow the first step..

That's odd... It shouldn't make a difference.  Which version of Crystal are you using?

Edited by hilfy - 16 Oct 2012 at 6:09am