I am creating scripts with two bind variables to produce year end or month end reports for our Finance area. The reporting tool that we've used for years is being desupported, so we are moving all those reports to TDP. Almost all these reports prompt for a fiscal year and/or fiscal period (month).
In TDP I created the bind variable in the where clause with the ':'. Such as, field name = :FISCAL_YEAR and field name = :FISCAL_PERIOD.
The problem that I've ran into after recreating about 15 of these reports using sql editor is that when I click run, using either Run SQL or Run Script (I've tried both), and the bind variable window pops up TDP will freeze if I try to change either of the variables. I have to go to Task Manager and force TDP to close.
Is this because I'm using the same variable in all these reports (:FISCAL_YEAR and :FISCAL_PERIOD)?
Several of these reports I've put to Automation and the first activity is the Set Variable. When running in Automation, I don't have this same issue.