can you link a subreport on a formula from the main report?

[mwhalen]

does anyone know? It's different than a shared variable. I don't want to do anything with the formula within the subreport just reference the value in the formula to the link on the subreport.

 

[bjrollet]

Have you tried to change the sub-report link? Click on 'Edit' on the menu bar, then choose 'Subreport Links'. You should get a window that allows you to change the link. You should now be able to select the formula field(allowing it is on your report).

If you just want to reference the value, and not link your subreport on it, than use a shared variable.

 

[Ngolem]

I think creating a shared variable on a link isn't really necessary...A linked value shouldn't change...therefore you already know the value on both sides via the linked fields...a shared variable would be redundant at best.

If you cannot see your formula in the choices to link then remove any functions like Whileprintingrecords or evaluateafter...then the formula should work. Jim
JimBroadbent@Hotmail.com

 

[bjrollet]

I only suggested creating the shared variable if you do NOT want to link on the formula. Of course you could reference the value if it was linked. I think he doesn't want to link, only reference.

 

[Ngolem]

yes...but you cannot use a shared variable in a record select...so if you are using that value to narrow choices in a subreport a shared variable (unless you want to use it to suppress values) is not the way to go. Jim
JimBroadbent@Hotmail.com