I need to generate a drill-down report with hyperlink. I have a column called Batch barcoce hosting different batch numbers and each batch barcode has multi samples barcode. I need to drill down the Batch barcode to a subreport containing sample barcode. I need to create a user input field in the main report so that the user can search with the sample barcode.
is it doable. what puzzles me is that the sample barcode data is in the subreport. If the user put a param value for sampl barcode in the main report, how will the data pull out from the subreport? I wish I make mysel clear.