Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Help: Selection Criteria for all Details Post Reply Post New Topic
Author Message
stratosk17
Newbie
Newbie


Joined: 10 Jul 2012
Location: United States
Online Status: Offline
Posts: 3
Quote stratosk17 Replybullet Topic: Help: Selection Criteria for all Details
    Posted: 13 Jul 2012 at 8:49am

I would like to know if there is a way to display all the details for a shipment that I have, but only if a particular item exist in the shipment.

 
For example I have a 5 shipments each with approximately 200 various items in each of them.  2 of the 5 shipments have one particular item style that I am looking for.
 
When I enter {RECEIPT_DETAIL.ITEM_STYLE} = {?Item Style} in my report, I get the 2 shipments that I am looking for, but in the details it only displays the item style that I chose.  I want to be able to see all the styles in the 2 shipments that include that style.


Edited by stratosk17 - 13 Jul 2012 at 9:00am
IP IP Logged
Sastry
Moderator
Moderator
Avatar

Joined: 16 Jul 2012
Online Status: Offline
Posts: 537
Quote Sastry Replybullet Posted: 16 Jul 2012 at 6:17am
Hi
 
This can be achived using sub report.
 
--insert the same report as sub report in the main report report footer.
 
--Use the same filter condition on your main report.
 
-- Remove the paramter selection in your sub report.
 
--Link your sub report with main report using Shipment.
 
Your main report will filter required shipments and this will be linked to your sub report to get all details.
 
Thanks,
Sastry
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 17 Jul 2012 at 3:51am
you can also use group selection criteria (if you don't want to do this in a sql query as your source).
You need to create a formual to 'flag' the items you want to look for then sum the flag at the group level and use that result to limit your group results.
group on shipment number
create yuor flag formula
if {RECEIPT_DETAIL.ITEM_STYLE} = {?Item Style}  then 1 else 0
sum this at the group levl
SUM(@flag,shipment_num)
use that in the group select criteria
SUM(@flag,shipment_num)>0
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.031 seconds.