Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: multiple values in a sub report Post Reply Post New Topic
Author Message
chrisfaw
Newbie
Newbie
Avatar

Joined: 26 Apr 2016
Online Status: Offline
Posts: 13
Quote chrisfaw Replybullet Topic: multiple values in a sub report
    Posted: 24 Oct 2016 at 3:12am
Hi CR Experts

Is it possible to return multiple values in a sub report from the detailed section of the main report.  I have a report which looks something like the below.  I need to be able to set a parameter to return multiple values from the main report.  I have linked the fields no problems and cheeked the allow multiple values check box in the sub report parameter but the report only return the last record.

Many Thanks

Chris :-)

main report parameter assembly 1




assembly  component  component type  sub assembly 
1 1 1
1 2 1
1 3 1
1 4 1
1 5 2 5
1 6 2 6








sub report needs to return sub assembly 5 & 6




assembly  component  component type  sub assembly 
5 1 1
5 2 1
5 3 1




assembly  component  component type  sub assembly 
6 1 1
6 2 1
6 3 1

IP IP Logged
chrisfaw
Newbie
Newbie
Avatar

Joined: 26 Apr 2016
Online Status: Offline
Posts: 13
Quote chrisfaw Replybullet Posted: 24 Oct 2016 at 3:28am
Sorry found the answer to this.

The sub report needs to be in the detailed section on the main report.  If it is in the footer section it will only return the last record and therefore only filter by the last record in the sub report parameter field.


IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.030 seconds.