Renil Cheenan
asked on
Drilldown reports in crystal report (Call another report from crystal report)
I want to know how i can build drill down reports in crystal reports. For example i have report with following details
Invoice No | Invoice Date | Customer Name | GST No | Total Amount
-------------------------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- -------- ---
123 01 Jan 2018 John xxxxx 80.00
Now when i click on invoice number (123) i want show another report (another rpt file) which shows the invoice details as below
Serial No | Item Code | Item Name | Rate | Quantity | Amount
-------------------------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- -------
1 IT567 Pen 10.00 2 20.00
2 IT586 Book 20.00 3 60.00
-------------------------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- -------
Total Amount 80.00
Invoice No | Invoice Date | Customer Name | GST No | Total Amount
--------------------------
123 01 Jan 2018 John xxxxx 80.00
Now when i click on invoice number (123) i want show another report (another rpt file) which shows the invoice details as below
Serial No | Item Code | Item Name | Rate | Quantity | Amount
--------------------------
1 IT567 Pen 10.00 2 20.00
2 IT586 Book 20.00 3 60.00
--------------------------
Total Amount 80.00
I agree. You can have the invoice number click call the on demand report.
mlmcc
mlmcc
This question needs an answer!
Become an EE member today
7 DAY FREE TRIALMembers can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
If the called report must have its own subreport, there's a more advanced option. But first consider the simple approach above.