Can you create a local variable in JRS?
Hi,
I've been working with editing the SQL Query in JRS to create a more advanced report. I've been looking online but haven't found anything on this topic - I apologize if I missed something. I was wondering if there was a way to define a local variable inside the SQL query in JRS. I get a lexical error when I try to use an "@" sign, and continue to get errors with anything else I try. I am trying to use this variable in a CASE statement. Please let me know if there is a way to successfully define this.
Thank you!
I've been working with editing the SQL Query in JRS to create a more advanced report. I've been looking online but haven't found anything on this topic - I apologize if I missed something. I was wondering if there was a way to define a local variable inside the SQL query in JRS. I get a lexical error when I try to use an "@" sign, and continue to get errors with anything else I try. I am trying to use this variable in a CASE statement. Please let me know if there is a way to successfully define this.
Thank you!
One answer
Hello Sarah,
this sounds similar to what was discussed in this thread:
How can I declare a temporary table in the Jazz Reporting Service?
https://jazz.net/forum/questions/218354/how-can-i-declare-a-temporary-table-in-the-jazz-reporting-service
and it's most likely currently not possible.
Best Regards
Francesco Chiossi
this sounds similar to what was discussed in this thread:
How can I declare a temporary table in the Jazz Reporting Service?
https://jazz.net/forum/questions/218354/how-can-i-declare-a-temporary-table-in-the-jazz-reporting-service
and it's most likely currently not possible.
Best Regards
Francesco Chiossi