I 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. However, I cannot find the shared variable listed in the Formula Editor's list when I go to create the Select statement in the second subreport. (I display the field's value in both subreports just to ensure the share works and it looks OK.)
Can anyone shed any light on what I am doing wrong?
Can you use a shared variable in a Select statement?