Referencing field in subreport - how?

[Former Member]

Post Author: sandro.an

CA Forum: Formula

Hi!

I have a report with two subreports (subA and subB).

In SubA, I have a field with "Sum of tb.totfat"

In SubB, I need to create a formula using the value showing SubA (sum of tb.totfat).

How I do this???

[Former Member]

Post Author: yangster

CA Forum: Formula

not sure why you would want to reference a field from a subreport as it would be a lot easier to just include the field in your main reportif you really wanted to reference a single field from the subreport just change the variable to reflect that field and not a formula or sum or anything else

[Former Member]

Post Author: sandro.an

CA Forum: Formula

Thanks.

I use Crystal 8.5 with VB6.

I'll try shared variables... but... Is not possible referencing a field into a subreport, as like... subreport! ??

Sandro

[Former Member]

Post Author: synapsevampire

CA Forum: Formula

Use shared variables to pass values.

In the future post your crystal version and the contents of your formula for accurate answers.

Example of formula in SUB A:

whileprintingrecords;shared numbervar MyTotal := sum({table.field})

Using it in SUB B:

whileprintingrecords;shared numbervar MyTotal;"Total was :" & MyTotal

-k