How can I reuse a parameter?

alyates

Hey,

I have a question that seems simple enough but i've been wracking my brain for 2 days on this.

I have a simple query:

select 'January' Period,'Completed' Task,count(id) as Count from jbpm_flow
where to_char(start_,'YYYY') = ? and to_char(start_,'MM') ='01' and status='Completed'

union select 'January' Period,'Cancelled' Task,count(id) as Count from jbpm_flow
where to_char(start_,'YYYY') = ? and to_char(start_,'MM') ='01' and status='Cancelled'

My problem is this. I want to ask a user for a single parameter and reuse that parameter for each of the places it appears in my query.

Anyone have any idea how I can do this?

alyates

I figured as soon as I posted here I would figure it out.

Here is my solution, for those who are interested:

In the Data Set, i defined all of the parameters that I needed but instead of linking each of those to a new parameter I used the "Link to Report Parameter" drop down to link it to the single input value given by the user.

So simple, I'm surprised I missed it.