well, if you just want to notify, you could build add a formula in the subreport that would check if the ticket number from the main report matched in the subreport.
using shared variables, this isn't too bad...
in the subreport you would have something like:
shared booleanvar ticketHere;
if {table.field} = {?parameter} then
ticketHere := true;
"" //will hide the output.
in the main report your formula would start:
shared booleanvar ticketHere;
//insert your logic for the message.
now the caveats:
1) you need to run the subreport in a section before the main report's formula for the message is run.
2) if you don't want to display the subreport, you need to have it display no fields, just a blank report...the formulas will run and the data will be read, but nothing will be displayed. Then back inthe main report, SectionExpert you need to select Suppress if Blank. This way the subreport will run, but nothing will be displayed in the main report.
HTH...or least points the way
IP Logged
