SQL Report - Report Update

Carlos Schonenberg

• July 28, 2022 06:57
• Edited

Hello.

This is Carlos.

I would like to ask if it is possible the following:

Once executed a SQL report, with a multi button I would like to select which data should be shown (kind of a filter) without closing the actual screen. If not possible, is there an alternative way to do it?

This is a simple explanation and the image of the scenario.

There is a column with batch numbers (U_BatchNo) registration.

IF the multi button is YES select only registered batch data. (See blue mark fields)

IF the multi button is NO select only unregistered data. (See red mark fields)

Kind regards.

Vote

1

• 

  Nick Jones

  • August 07, 2022 23:52

  Hi Carlos,

  You could have separate SQL reports, one that shows all the data,one that shows registered batch data, and one that shows the unregistered batch data.

  Then, put a validation configuration on the multi button selection so that once you have made your selection it closes the existing SQL report and shows the report based on the drop-down selection.

  Alternatively, an this is just an untested theory, you could have the multibutton selection be stored into a @STORE variable, then have the SQL for the report be dynamic so that the code changes depending on which value is stored.

  Dropdown selected > Store value > Refresh SQL report (i presume by activating a click command on the refresh button).

  Hope this helps or at least leads you down a path which works for you.

  Nick
• 

  Carlos Schonenberg

  • August 08, 2022 09:22

  Hello Nick,

  I appreciate your kind explanation.
  I was able to show the reports in different screens based on what you said.
  I opted for the @STORE variable using macros and inside the macro code called the SQL reports with an UF command, for batched and non batched respectively.

  Thank you.

  Carlos

Please sign in to leave a comment.