How to use the drill down arrow for multiple document types

142 Views

Dear Experts,

I have created a Crysta Report which lists my open, and closed Sales Orders, Delivery, and AR/Invoices.

It is grouped by:

Group1: Customer Group

Group2: Customer

Group3 Document type (Sales Order, Delivery, Invoice)

Details section: Document number, Docentry, DocDate, Amount

See in picture:

My question is how to use the drill down arrow to point to the Document in SAP Business One.

In case I have only one document type in the row the golden arrow works fine, I am using this hyperlink:

'http://$b1$/link?table=ORDR&key='+totext({QC002_Vevoegyenlegek.Docentry},0,"","")

But i need different hyperlinks for ORDR, ODLN, OINV, and I can only insert one Arrow in the details section.

Can you please give me some hints on this?

Thank you in advance,

Regards,

Ottó

Attachments

CR.png (31.0 kB)