Maintain the order of the static Parameter List in the output of the report
Hello,
This is a simple report where a driver enters his Invoice #s into the Static Parameter List. The report then outputs them.
The datasource is a SQL Command.
My need is to have the report print them in the order that they are entered. Does this require a formula? Does anyone have any ideas?
Thank you.
ROUTINGSHEET-US.rpt
This is a simple report where a driver enters his Invoice #s into the Static Parameter List. The report then outputs them.
The datasource is a SQL Command.
My need is to have the report print them in the order that they are entered. Does this require a formula? Does anyone have any ideas?
Thank you.
ROUTINGSHEET-US.rpt
Find your icon that looks like an A and Z with circular arrows (sort expert). Select your field: Command.ESCINO
Oh, sorry, misunderstood, don't they print in the order they were entered when you don't do anything?
ASKER
No, for some reason they don't...sometimes they will, but not always.
They will print in the order they are found in the database.
So you want the user to enter invoice numbers and then have the report show them in that order?
If the user enters this for one run
X101, D301, R401
Next run
D301, X101, R401
And you want the order to be different in the report?
mlmcc
So you want the user to enter invoice numbers and then have the report show them in that order?
If the user enters this for one run
X101, D301, R401
Next run
D301, X101, R401
And you want the order to be different in the report?
mlmcc
ASKER
That's correct. Someone is manually figuring out the most efficient route for the driver to stop by each Vendor to collect the Invoices. That user will enter the Invoices in that order.
If it will print this order out, the driver just goes down the list to pick up. Eventually, it will show the Vendor Details, ie. Address, City and so forth.
If it will print this order out, the driver just goes down the list to pick up. Eventually, it will show the Vendor Details, ie. Address, City and so forth.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
That worked like a charm! Thank you very much. Would you care to explain what it's doing? I noticed it doesn't use the WhilePrintingRecords or 'Reading...'. So, this is purely for the Sorting mechanism?
Multiple value parameters are treated as an array in Crystal so the idea was to search the array for the field and save the index.
Since you wanted it as a sort it can't use the WhilePrintingRecords but relies on Crystal to evaluate it when it is needed.
mlmcc
Since you wanted it as a sort it can't use the WhilePrintingRecords but relies on Crystal to evaluate it when it is needed.
mlmcc