Multiple detail 1

[paulcedarhill]

My problem,

I need seperate, multiple lines of data from 2 different tables, selected by 3 teirs of groups.

basically:
Group 1= Region id
Group2 = sales rep id
Group3 = project id
detail a = all records in table.activities
detail b = all records in table.specifications

right now the report duplicates detail b for every change in detail a.

What am I doing wrong?

tech info:
I am using Crystal Reports Pro 9.20 pulling data through an ODBC connection from an ACCESS dba with sql database on an NT4 box.

I run Crystal on a terminal server running windows 2000. SP3

 

[kskid]

Just create another group for {Table.activities}, move everything from Detail a to group4 and delete detail section a. Format group4 section to underlay the following section or detail a which now has {table.specifications}.

Cheers,
-LW

 

[lbass]

I think you would have to use detail_a for the fields from the Activities table, and then insert a subreport that uses the Specifications table, place it in the group footer #3, and link it to the main report on the three group fields.

-LB

 

[paulcedarhill]

KSkid,

I have tried the 4 group option without success. That gave me the same duplicate detail as the current configuration.

lbass,

how do you link the subreport to the main report on the 3 group fields? I have never done a sub report.

 

[lbass]

In the main report, go to edit->edit subreport links->select the group #1 field from the top left and move it to the right. Then the group #2 and Group #3. The corresponding fields from the subreport should automatically prefill.

-LB

 

[paulcedarhill]

lbass,

that got the result I needed thanks very much.

One new question, is there a better way to update a subreport that as been changed than the method I used which was to delete it then re-insert it?

 

[lbass]

If you create a subreport while in the main report, then to make changes, use the edit subreport option.

If you have imported a report to act as your subreport, and then you want the subreport to reflect changes made in that report, then try right clicking on the subreport->reimport subreport. Make sure any changes you made in the original report you are using for the subreport have been saved before reimporting.

-LB