Compare a field from main report against a field from a subreport on CRYSTAL REPORT

[Ajmal N]

I was wondering if there is a way for comparing a field from the main report against the a field from a subreport.
My main report is pointing to the current month data and the same report is pointing to the previous month data in the sub report.

I need to do something like:
IF SubReportStatus(previous month) = '1-30 days' AND MainReportStatus(Current month) = '31-60 days' THEN "Worse" ELSE IF
IF SubReportStatus(previous month) = '61-90 days' AND MainReportStatus(Current month) = '91+ days' THEN "Worse"

etc etc.

It would be really helpful and really appreciated to know if there's a way this can be done.

Many Thanks

 

[IdoMillet]

You can return info from the subreport to the main report via a shared variable.
Or you can pass information from the main report into the subreport using a subreport link.


view, export, burst, email, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[Ajmal N]

Hi Ido,

How would I go on about doing that?
I have tried a few ways, but what sort of shared variable and what would the steps be.
I want to be able to achieve the below and the outcome comes on the current month (main report):
IF SubReportStatus(previous month) = '1-30 days' AND MainReportStatus(Current month) = '31-60 days' THEN "Worse" ELSE IF
IF SubReportStatus(previous month) = '61-90 days' AND MainReportStatus(Current month) = '91+ days' THEN "Worse"

 

[dgillz]

1) Declare a shared variable in the subreport and assign it a value

2) in the main report, somewhere after the placement of the subreport, compare the shared variable to the main report value


Macola Software Veteran and SAP Business One Consultant on Training Wheels

Check out our Macola tools:

http://www.gainfocus.biz/exceladdin.html

 

[Ajmal N]

Hi Dgillz,

The field's I am trying to compare are text fields.
Can you please provide an example as to how I can declare this please?
I tried a few different ways but non worked.

Thanks

 

[dgillz]

In the subreport:

Shared Stringvar MyVar:={MySubreportField}

In the main report:

If Shared Stringvar MyVar<>{MyMainReportField} then.....

Macola Software Veteran and SAP Business One Consultant on Training Wheels

Check out our Macola tools:

http://www.gainfocus.biz/exceladdin.html