Variable/Parameter reuse in Reports

[Matt Symes]

Hi there,

Thanks for all the great work you guys do developing and supporting PL/SQL Developer.

I want to write a report where I reuse a user entered variable but I can't work out how to do it. In my particular case I want to use the same parameter in the SELECT xxx part and the GROUP BY xxx part.

Can this be accomplished and if not can it go on the enhancements list.

Thanks again,

- Matt

 

[Marco Kalter]

This is indeed possible. For example:

select &<name="Column" hint="Employee column name to group by">, sum(sal) saltotal
from emp
group by &<name="Column">

Note that you only need to specify any options for the first occurrence. For the second occurrence you only need to specify the name. The user will be prompted for only one "Column" in this example.