Imbedding reports within a main report

[aries]

Good Day
I am very new at using Crystal Reports, but have had some experience with building queries in Access. We have recently converted our database from Access into Arcview. With this data base, we have a number of queries and reports that are required to be generated on a regular basis. My question is whether Crystal Reports has the ability to generate a variety of report options from one main template. For instance, I was wondering if the following outline for a query report would be possible:

Pull up main Crystal Report Template which would include all available fields in the design from two linked databases
(Each type of Report I would like to imbed would house the same fields, but each imbedded report would generate different information ( and formulas)
Eg:
Initial Parameter field, upon opening Crystal Report Template, will ask for Report name as follows:
Removals
Work Orders
Brace & Cable
Hydro
Contract
Planting
Stumps
If Removals is chosen, pick the removal formula for the report and apply: Meaning only Removal records under certain circumstances will be selected
If Work Order is chosen, pick the work order formula for the report and apply: Meaning only specific work orders under certain conditions will be selected.; Etc, down the list of imbedded or subreports
It is my intention to pull up one Report and give the user the ability to build their own report based on the criteria that I would build into the template.Also, is it possible to hide fields until they fit into a particular criteria category? For instance, if the above Template can be developed, I would not need the stump field to show unless the Stump Report option is chosen.
[sig][/sig]

 

[kenhamady]

You can do this if you like writing if-then-statements.

the report would prompt for one parameter and you would select the report type. You then use that one parameter to control three things (at least):

1) You have created a separate detail band for each report, and you only show the one you want by suppressing all of the others with a formula based on parameter selected.

2)You have a selection formula that has a long if-then for the criteria. That way the criteria is specific to the report you select.

3) Each formula can also use if-then logic to see what type of report was selected and provide the correct result.

All that being said, you are making a lot of work to avoid making 7 individual reports. They must all use the same tables and joins, which can't be made to rely on a parameter. [sig]<p>Ken Hamady<br><a href=mailto:ken@kenhamady.com>ken@kenhamady.com</a><br><a href=

http://www.kenhamady.com/>Crystal

Reports Training by Ken Hamady</a><br>[/sig]