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?
|
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 codeguru.com
Copyright WebMediaBrands Inc., All Rights Reserved. |