Link to home
Create AccountLog in
Avatar of Llacy80
Llacy80Flag for United States of America

asked on

Crystal Report - Parameter/ Ideas

Good morning. I am  trying to think of different ways to handle a report I created for commercial invoices. We have a field (COO - Country of Origin) that has to be typed in and for the most part works fine because it pulls the data for the COO from the DB. However, when there is a TBD or N/A in the field, it causes us an issue because obviously it will have to be hand written in which will cause it to be rejected at customs. I am thinking of the best way to handle this and the only thing I have come up with so far is to have users run the report as usual and in the event that the report returns data in the COO field that has TBD or NA, they then export the report to excel and then change the field by typing in the appropriate information.

Is there a way to create a formula that would allow the report to generate a parameter based off of the field data? Then from there they could actually select the COO from the list.

Any other ideas would be appreciated.
Avatar of Mike McCracken
Mike McCracken

Reports are not interactive.

You could provide a value that is substituted for all TBD/NA values.

Is there any way to determine what the value should be like a city or country field?

mlmcc
Avatar of Llacy80

ASKER

There would really be no logical way to determine with out human interaction to select from a list. That is why I was hoping I could somehow create a formula that would prompt if the COO field was TBD or NA so that the salesperson could just select from the list.
How do you run the report?
ASKER CERTIFIED SOLUTION
Avatar of vasto
vasto
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account