Linking Created Tables in CR 8.0

[ppatel2]

I'm trying to link two created tables in Crystal (8.0). The tables are Peoplesoft queries. Every time I try this in Crystal I get a message saying that I can't link SQL stored procedures.

I'm trying to create a report based on somewhat of a cross tabbed report. 5 out of the 6 columns of information come out of one table. The sixth column of information comes out of a second table. How can I set up the report so that the second table will be grouped by the same field the first table is grouped by without redundancy.

Example below.

ID LIKE IT TO LOOK LIKE THIS

Line 1 x y z a
Line 2 x y z a
Line 3 x y z a
Line 4 x y z a
Line 5 x y z a


INSTEAD OF LIKE THIS

Line 1 x y z
Line 1 a
Line 2 x y z
Line 2 a
Line 3 x y z
Line 3 a
Line 4 x y z
Line 4 a
Line 5 x y z
Line 5 a

 

[synapsevampire]

One means would be to group by a like entity, right click the group header and select insert section below, then in the lower group header place a subreport which is linked via the common entity and within the subreport create a shared variable formula to return the value to the main report.

You'll end up using 3 formulas:

Main Report upper Group header:
whileprintingrecords;
shared stringvar MyValue:=""

Subreport formula:
whileprintingrecords;
shared stringvar MyValue:={table.field}

MainReport Group Footer formula (where you display everything, suppress the details):
whileprintingrecords;
shared stringvar MyValue

Better still would be to create a single query to return everything.

-k