Print Page | Close Window

Create new report based on existing report

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=11054
Printed Date: 04 May 2024 at 3:35am


Topic: Create new report based on existing report
Posted By: wisdom
Subject: Create new report based on existing report
Date Posted: 07 Sep 2010 at 5:54am

Using ver 8.5

 
Hi I developed a solution through MS Access where I have a query running over another query result to get the result consistently.  Now I wanted to do the same for Crystal report.
 
I thought about using existing report and add a sub report - establishing which table/field as the link to the main report.  However, I need guidance as I am not familiar with Crystal report, but you can imagine I have two MS Access query - the first one produce the first result.  The 2nd query is then based on the 1st one with additional tables added on.  This is what I want to achieve on Crystal report 8.5.
 
Please can someone help.  Thanks


Replies:
Posted By: wisdom
Date Posted: 12 Sep 2010 at 11:50am

perhaps I rephrase the question differently.

Suppose I have a report with the data but then I want to use existing result and build further tables from the result using existing report.  Is this possible? and how do I use this?   Sorry if it wasn't clear but perhaps it's not possible from an expert point of view!?

Posted By: DBlank
Date Posted: 12 Sep 2010 at 3:26pm
you can create sub reports and use an item from the main report as a param to partially filter the data but this is likely not what you want to do. you can still use a query that uses a query as your source or write a more complex command object to do something similar


Print Page | Close Window