Can we use macro variables in a SQL report?

Comments

1 comment

  • Avatar
    Dave Gutman, Advantage ERP Group

    Hi Mark,

    I tried this a few ways and no-go here also. 

    Would this work?  Create a Macro UF that runs before your SQL Report, and finishes by calling the report.  So the macro UF is called that from your screen, and in it use the SET command to put the value of the @STOREx variable into a blank field on the screen.  After it does that the Macro would call the SQL Report UF and use dynamic syntax to get the value of the @STOREx variable that you dropped in the field.  Yeah, that's pretty convoluted but might work if you have a spare field that wouldn't have a risk of being updated.

    Comment actions Permalink

Please sign in to leave a comment.