pass variable values as parameter values in sql query -HOW?

[raparlasiva]

 Hi,

 

I have created four parameters in my ireport

1. calendar

2.  week  --->Prompt

3. year  ---> Prompt

4. formatter

I have calculated the date range using the 4 above parameters ('startDate' , 'endDate')

 

My report lets  the users see the number of orders from  week number and year they choose from the dropdown box.

. My issue is  now how to  pass the variable values of 'startDate'  and'endDate'  to the sql query i.e, the stored procedure

(call stored_procedure('startDate' , 'endDate')

 

 

Post Edited by raparlasiva at 09/10/2012 19:40

[marianol]

 I'm assuming you calculated your dates in new report parameters, and those parameters are named  'startDate' , 'endDate'.

So for using them in your query you need to use the $P{param_name} syntax. In your case:

call stored_procedure($P{startDate} , $P{endDate})

See: http://jasperforge.org/website/ireportwebsite/IR%20Website/ir_using_parameters.html?header=project&target=ireport

 

Mariano

[raparlasiva]

calculated the date range using the below link

http://type-exit.org/adventures-with-open-source-bi/2010/06/date-calculation-in-ireport/

 

'startDate' , 'endDate' ---> variable names and not parameters.

[marianol]

Sorry I did not read your post correctly. You are saying that you've calculated those dates in Variables, Variables scope starts after the query has been executed and may have evaluation times.

 

In your case you will need to do the calculation of your dates in Parameters using the parameter default expression property. Also check the ORDER of the parameter sin the Report Inspector because iReport will execute them in that order. So your StartDate and EndDate parameters should be the last ones.

[raparlasiva]

ur so awesome..It worked..Thanks a lot for your support. Ur so awesome..thank you again..it worked..thank GOD!

[raparlasiva]

 i have two parameters

1. week and

2. year

both use as prompt on ireport.

But when I add a single value input control and run the same report on jasper server, the single value input control is  not visible and only a pop up window is opening up.

I want to know why my single value input control not showing up when I am running the report on jasper server ?

 

thanks

Siva

 

 

[sumayya.sultana]

you have to add the input controls as per the name you have given to the parameters ,then it works.

[sumayya.sultana]

can you eloborate how you are giving it.if you give the input controls with the same name you define a parameters with case senstivie then it works