Click to See Complete Forum and Search --> : Passing Value into Sub Report


cmptrnerd9
August 1st, 2007, 02:19 PM
What is the best way to pass a value from the main report into a subreport, so it can be used in a formula field?

Ned Pepper
August 3rd, 2007, 03:35 PM
USE SHARED VARIABLES IN FORMULAS. I LIKE BASIC SYNTAX....

IN MAIN, REPORT A FORMULA THAT COLLECTS A VALUE AND DISPLAYS NOTHING
Shared MyVar as number
MyVar = {Table.Field}
Formula = ""

IN THE SUB REPORT, A FORMULA THAT MANIPULATES THE COLLECTED VALUE AND DISPLAYS THE RESULT
Shared MyVar as Number
MyVar = MyVar * .0775
Formula = MyVar

NOTE: SHARED VARIABLES ARE ONLY ACCESSABLE WhilePrintingRecords