Solved

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

Posted on 2013-01-23
1
286 Views
Last Modified: 2013-01-25
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.

Thanks
0
Comment
Question by:bmorriso99
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 18

Accepted Solution

by:
vasto earned 500 total points
ID: 38811734
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.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In our object-oriented world the class is a minimal unit, a brick for constructing our applications. It is an abstraction and we know well how to use it. In well-designed software we are not usually interested in knowing how objects look in memory. …
Jaspersoft Studio is a plugin for Eclipse that lets you create reports from a datasource.  In this article, we'll go over creating a report from a default template and setting up a datasource that connects to your database.
The viewer will learn how to use and create keystrokes in Netbeans IDE 8.0 for Windows.
The viewer will learn how to use and create new code templates in NetBeans IDE 8.0 for Windows.

729 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question