Select statements on shared data from a sub report

[Deano1976]

CR V8.5

I have passed through a value from a sub report to a main report and subsequently divided this value into a another value in my main report using a formula. I now want to do a select on the result of this formula, but Crystal is telling me the "formula cannot be used as it must be evaluated later".

So for example I have.

A field in my sub report called Weekly Sales Volume.
I have shared this field with my main report and also called it Weekly Sales Volume.
I have then created a formula called Remaining Stock, which divides a field in my main report called Closing Stock with the Weekly Sales Volume field.
I then want to be able to only select records where the result of this formula is less than a specified figure (1.5 for arguements sake).

Any ideas?

 

[Madawc]

Subreports are run only after all of the data has been selected. That's how Crystal works, the framework you code within.

One possible answer is to reverse the relationship of the main report and subreport. Have your existing subreport become the main and call what is now 'main'.

Another is to select the data and use group suppression.

Things can also be done in SQL, if you have it. SQL in 8.5 is awkward to use.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[Deano1976]

What do you mean by "Another is to select the data and use group suppression.

 

[Madawc]

Another option, another possible answer

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[lbass]

You will only be able to use section suppression. Go to the section expert->highlight the section you want suppressed and enter a formula into the formula area for suppress:

{@RemainingStock} > 1.5

You only be able to suppress those sections below the one in which the subreport is located.

-LB