Need help in Crystal

building reports crystal reports
1

Hi,

  1. How to use two tables ( queries ) from the same datasource in one report.
    both the tables have the same characteristics but have different measures.

  2. How to filter the reports based on a characteristic (eg plant).
    The report should be in such a way that it the filters are in different sheets .

ie sheet 1 should have data based on Plant A
Sheet 2 should have data based on Plant B.

  1. Is it possible to combine both the above requirements into one
    ie sheet 1 having filtered data by plant A for both the tables 1 and 2.
    Sheet 2 having been filtered by Plant B for both the tables 1 and 2.

Thanks in advance

Regards
Harish

harishreddy :india: (BOB member since 2006-05-11)

2

The easiest way is with sub reports.

Create a report for each data set

Create a new master report, grouped by Plant

In this master report, add a details section so you have “Details a” and “Details b”.

Insert a sub report into each detail section and link the reports to filter by Plant.

If you have any problems, Post back.

Obiron

obiron (BOB member since 2008-01-10)

3

Obiron,

I have created a master report and added two group headers A and Group Header B,
I have created in the group header as my reports are Crosstabs.

Then i selected the Plant in Group Header A and and clicked on the Filter tab ( select expert --Record) and then filtered the first Group Header with Plant A.Then i selected the Group Header B and and cliked on the Filter tab and then filtered the first Group Header with Plant B.

when i go the preview i see the two sections but both the sections have data of one plant only.

  1. Is it that i have to create two different reports with the filter Plant A and another report with Filter Plant B.?

  2. In the select expert is there any option where i select more than one value for a plant.?

  3. should both the Group header A and Group Header B be sub reports.?

Regards
Harish

harishreddy :india: (BOB member since 2006-05-11)

4

Group header A and Group header B are both part of the same group header, so will contain data for the same criteria.

In design view do you see this?

GH1a ----- Sub report 1
GH1b ----- Sub report 2
Details —
GF1 -------

If so, then in report view you get

GH1a ---- Plant 1 subreport 1 (plant 1)
GH1b ---- Plant 1 Subreport 2 (plant 2)
Details —
GF1
GH1a ---- Plant 2 subreport 1 (plant 1)
GH1b ---- Plant 2 subreport 2 (plant 2)
Details
GF1

What you want is

GH1 ---- Plant 1
Detailsa – Subreport 1 (filtered by plant)
Detailsb – Subreport 2 (filtered by plant)
GF1
GH1 ---- Plant 2
Detailsa – Subreport 1 (filtered by plant)
Detailsb – Subreport 2 (filtered by plant)
GF1

obiron (BOB member since 2008-01-10)