asked on

Link a subreport in Crystal to Details a and b in Main Report

I need a subreport where a StockCode in Details B and Operation in Details ...I have placed a Subreport in Details A

My sub report has @Initialize

WhilePrintingRecords;
Shared StringVar StockCode:={WipMaster.StockCode};
Shared StringVar Operation:={@@Operation};
Shared StringVar WorkCenter:={WipJobAllLab.WorkCentre};
Shared StringVar Narration:={WipJobAllLab.Narration};

I am linking to StockCode, Operation, and WorkCenter

and trying to get the result in Details D from subreport but it is not coming out

formula for @Narration that I want to see in Details D

Shared StringVar StockCode;
Shared StringVar Operation;
Shared StringVar WorkCenter;
Shared StringVar Narration;

if StockCode = {WIPJobStatusQuery/JobStatus/Job.StockCode}
and Operation = {WIPJobStatusQuery/JobStatus/Job/MaterialOperation.Operation}
and WorkCenter = {WIPJobStatusQuery/JobStatus/Job/MaterialOperation.WorkCentre}
then Narration

Else ''

What am I doing wrong??

ASKER CERTIFIED SOLUTION

Mike McCracken

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Michael Katz

ASKER

I will double check the link.. but do I have the concept right on my shared variable and placement of the sub report??

Mike McCracken

It sounds like it. But since it isn't working, either there is no data or you have it implemented wrong in some way.

If you want upload the report file and I'll look at it.

mlmcc