Solved

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

Posted on 2013-01-23
1
275 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
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

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
eclipse giving error when test program exits 6 138
maven import project error 7 130
Aptana 3.6 Preview Problem On Mac 35 124
debug as  junit test 4 80
Programmer's Notepad is, one of the best free text editing tools available, simply because the developers appear to have second-guessed every weird problem or issue a programmer is likely to run into. One of these problems is selecting and deletiā€¦
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.
This tutorial covers a step-by-step guide to install VisualVM launcher in eclipse.
THe viewer will learn how to use NetBeans IDE 8.0 for Windows to perform CRUD operations on a MySql database.

805 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