How to create a sort value on invoice records, then re-sort report on value?
How to create a sort value on invoice records, then re-sort report on value?
(OP)
I have multiple records on invoices. I need to extract a value from the first record on each invoice, then add it to the other records on that invoice, then re-sort the report on that value.
How do I do this?
My thought is to create a shared variable for the extracted value from the first record and add it to the other records on that invoice, then run a second pass that sorts on that value. However, I am not sure how to do this.
How do I do this?
My thought is to create a shared variable for the extracted value from the first record and add it to the other records on that invoice, then run a second pass that sorts on that value. However, I am not sure how to do this.
RE: How to create a sort value on invoice records, then re-sort report on value?
-LB
RE: How to create a sort value on invoice records, then re-sort report on value?
I cannot find a way to do this with Crystal Reports reading the posted data, so I exported transactions to Excel and used formulas to create the driver code for all invoice lines, then used Crystal Reports to read the Excel file. That worked great, until I had to re-create my Excel file from another export. Now I cannot read my Excel file!
RE: How to create a sort value on invoice records, then re-sort report on value?
-LB
RE: How to create a sort value on invoice records, then re-sort report on value?
If the table you added twice was linked to the item master you might need to add a second instance of that table as well to decode the Item ID into the actual driver.
Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guides to Formulas, Parameters, Subreports, Cross-tabs, VB, Tips and Tricks
http://www.kenhamady.com/