AnsweredAssumed Answered

SQL dynamic queries in Advanced reports

Question asked by Joe Carter on Jan 6, 2017

Hi

I am trying to do a pivot query in Advanced Reports using MSSQL server which works fine.

 

I now need to use some variables in the query and have tested the query in Management Studio and it works fine but Sugar says it is invalid!

 

Is it even possible to use variables in the Custom Queries in Advanced Reports.

Outcomes