WebI am using Crystal Reports XI and have run into a problem with shared variables. I have multiple subreports in the main report and need to use the shared variable from an earlier subreport in a Select statement in a later subreport. The Select statement will test to see if the ID field in table c equals the shared variable. WebInsert a Subreport in Page Header. Create a Formula to calculate any value (for e.g. sum of all Last Year Sales from Customer Table) and scope of that variable should be Shared. …
How to get formula field value from Subreport to main report
WebRemarks. Shared variables allow values to be used at any point in the processing of the report. Similar to a global variable, the shared values can also be accessed by subreports. This allows for a more direct method of comparison and allows the developer to circumvent the strict nature of the top-to-bottom report evaluation. A shared variable ... WebNov 6, 2011 · 1) Create a parameter in sub-report. 2) In main report right click on sub-report and click “Change Sub report link” 3) Select a data field (or a parameter value or a formula field) from main report which we want … gran torino american dream
1535232 - Shared variable returning zero values in crystal reports
WebShared variables are even more general than global variables. To use a shared variable, declare it in a formula in the main report −. Shared NumberVar Z := 10; To use shared … WebShared CurrencyVar myTotal := Sum ( {Gift.Gift Amount}) 2. Place this formula in the Report Footer of your subreport. 3. In the main report, create a formula that declares the same variable name: //@MainFormula. //Returns the value that was stored in the shared currency variable called myTotal in the subreport. WebHow to Pass the Data. In the subreport, do all your necessary calculations in a Formula Field, which should be added into the Report Footer. Add the following code into the … gran torino awards