Launching a new report depending on results of sql - Crystal Reports

I want the user to enter an order number into a report and then depending on what customer that order is associated to print one of 10 different report layouts. Is there a way to do that in crystal reports?

For example of the user enters 4311a (this is a sales order number) then the report file 1 would be displayed because customer 999 is associated to format 1.  The relationship between the order, the customer and the report format are in the database. I don't know if an .rpt file can call a new .rpt file.

Who is Participating?
vastoConnect With a Mentor Commented:
You can create one main report and to add multiple subreports inside. Then create a sql which will return some flags to hide all the subreports not related to the parameter value
So if the user inserts 4311a  your sql will return 1 for all flags except for the one supressing subreport 1.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.