It's all about the answers!

Ask a question

Can you create a local variable in JRS?


Sarah Byrum (214) | asked Aug 03 '16, 9:01 a.m.
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!

One answer



permanent link
Francesco Chiossi (5.7k1719) | answered Aug 03 '16, 9:19 a.m.
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

Your answer


Register or to post your answer.