I need to generate a drill-down tabular report with the following requirements:
Here're the columns to be included in the main report:
status of batch
Number of samples
Location shipped from
Location shipped to
Date the batch created
Date the batch received
In the above columns Batch Barcode should be drilled down with a hyper-link to a sub-report which includes the following columns:
In the meantime, the report should provide the ability to query by the following inputs:
a. Batch Barcode
b. Sample Barcode
c. Date range (user specified start date and end date )
A.The report shall return an error message to the user if the range between the user entered start date and entered end date of shipping exceeds one year.
B. If the user set a start date and end date is not set the report shall display data from start date to one year after the start date.
C. If the user set a end date but not a start date the report shall display data from one year before the end date
D. If neither a start date nor a end date is specified the report shall display data starting one year before the date of querying.
It's straightforward to create a main report with a drill-down sub-report, however I'm kind of stuck at how to implement the query based on the three criteria (Batch code shown both in main report and sub-report, Sample barcode shown only in sub-report and the tough one will be the date range)
I'm the only one responsible for generating report in the group. Please help on that!
Thank you a whole bunch!