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.

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?

and it's most likely currently not possible.

Best Regards
Francesco Chiossi

Your answer

Register or to post your answer.