virenptl40

(new SimpleDateFormat("MMM dd, YYYY").format($P{REPORT_DATE})) This will work. SimpleDateFormat is case sensitive.

Thanks a lot for the reply. Exactly I am using one report per datasource. I have provided two different datasources for the two different report. But while executing this two reports in the same window, it is only referring one datasource for both the reports. And If I execute only single report then it works fine. Same I have tried with JNDI. I am not finding a way how to resolve this. May be this is a limitation for jasperserver.

I am not able to use diffrent datasouce for two same formatted report. It means it referes only last accessed report's datasource. I am not finding a way since last month. I am about to done with the development. Please help me. Thanks in advance.

Hi, Can you tell me how to use scriptlet in jasper server. Please help me i stuck in a middle of a report development. I am replacing parameter value in my query using scriptlet. It is possible with iReport but i have no idea how i can use scriptlet in jasperserver. Please help. Thanks in advance.

Hi, I have gone through the documentation and as per your solution I am fetching country, state using sql only. I have added .jar onto server under resources section but when i am trying to use its method it is saying that scriplet1_SCRIPLET parameter not found. Please give me solution to use this scriptlet in jasper server. Thanks for the reply.

I am using jasper server for input parameters. I have created cascading parameter. Now i want to use scriptlet in jasper server input parameter. e.g. Country,state,city in city i want to replace city using scriplet so that this output i can use in next parameter. I have added myscriplet.jar in resource but when i am going to use it with $P{MYSCRIPTLET_SCRIPTLET}.getCityName($P{City}) it is giving me error as MYSCRIPTLET_SCRIPTLET parameter is not defined. Please help i am not able to use scriplet in jasperserver. Please tell me with the steps to use scriplet.

Can you tell me the steps how i can add that variable in jasper server.?? because by $P{MYSCRIPTLET_SCRIPTLET}.methodToCall{ $P{ input_control_parameter } } it is giving me error as MYSCRIPTLET_SCRIPTLET parameter not found. please help.