Macro - Store value in SQL Report

Answered

Carla van Zyl

• February 19, 2025 11:03

Good day, 

I have a macro, that clicks on a button that opens a SQL report. I want to store the value from the SQL report but when I add in the Store function(@STORE1=$[$BOY_1.CGIC Availability.0]; ), it store the text ($[$BOY_1.CGIC Availability.0]) and not the actual value (Number) displayed on the SQL Report. 

Is this at all possible to get the value and if so, how do I ammend my syntax. 

The SQL Report is very only returns one row with 8 columns. 

Vote

0

• 

  SSP Automation

  • February 19, 2025 11:30

  Thank you for your request. It has been scheduled for review by the development team that will get back to you should there be questions.
  (Please note that as we are user-driven we can't guarantee that your request will be met unless it gets many votes and/or fit the product vision)
  Read more about the Feature Request process here
  [Internal Id: 146771]
  
• 

  Ramon Duunk

  • February 19, 2025 13:52

  Pull the result directly from the macro instead of opening a sql report :
  
  
• 

  Dave Gutman

  • February 19, 2025 14:45

  Hi Carla, I've had similar challenges. In some cases, using either single or double quotes around the dynamic syntax works, not sure about in your case.

  Another thing that can help is to 'force' a syntax error and then look at the log files. This can give an idea on how B1UP parses the commands and dynamic syntax. 

  Best,

  Dave
• 

  Carla van Zyl

  • February 20, 2025 07:37

  Hi Dave and Ramon, 

  Thanks for the quick feedback. The SQL Seemed to work. I just needed to put the whole SQL Query in one line. 

  Thanks so much! 

   

Please sign in to leave a comment.