Copy field from dashboard sql report

Answered

jonathan crawford

• February 05, 2018 11:51

I have a dashboard UF item with a SQL report that shows a list of open stock counting documents. I want to be able to click a golden arrow that opens the relevant stock counting document. Golden arrows do not support stock counting documents yet so I am trying to do create the functionality manually. 

I was trying to use another macro UF to open a stock counting, activate find mode and insert the docnum from the sql report.

The problem is I can't figure out how to get the data (docnum) from the original SQL report and transfer to the new window. There are no system references on dashboard items. 

Any suggestions?

Thanks. 

 

Vote

0

• Official comment

  

  Yaremi Miranda Lopez

  • February 09, 2018 15:27

  Hello Jonathan,

   

  You do it just like you would as the SQL Report was a normal SAP Window =)
  
  For example:

  
  $[$BOY_1.<ColumnName>.0]
  
• 

  Tobias Walter

  • May 30, 2018 07:54

  Good Morning,

  I think I do have a similar problem, but I can not solve it by using the mentioned solution.

  I created a dashboard that displays the open customer-orders. The data is provided by a query, of course. I do have to be able to read - for instance - the itemcode of the selected line and put this value into a variable of a c#-code or in a @STORE-Variable of a macro. I don´t get it how to do this by using the mentioned syntax. Problem starts when trying to identify the technical name of the dashboard (I tried the displayed name of the dashboard without success). The macro tells me that it is unable to find the object. Somehow I feel to be on the wrong path (I started with B1UP a month ago and therefore I not very much experienced till now....).

  Could anyone support me with some hints on how to get a solution? Thank you very much in advance.

  Kind Regards, Toby
• 

  Tobias Walter

  • May 30, 2018 08:20

  Good Morning again,

  I got it. I mean I can read the desired value into a macro-variable :-)

  Is there any chance of getting these values in a c#-code? Of course the debugger shows an error when using $[$B1DASHBOARDVALUE.STRING]......

  Thank you

  Toby

   
• 

  Yaremi Miranda Lopez

  • May 31, 2018 16:51

  Hello Tobias,

  This is more a development question, please contact your Partner so they can help you with this advance question. =)

Please sign in to leave a comment.