Jasper Adhoc Reporting

[sivakumar_saas]

 

Dears,

     I have created a Domain for Adhoc Reporting. For some of the columns in the report, I have to use oracle function to get  desired output. Can anyone please tell me where I need to add this oracle function[Ex DECODE] when I create my domain.

Regards,

Siva

 

Example :

 

Desired Output Using Oracle Function: [decode(DUMMY,100,'Yes',0,'No')]

 

DUM
---
Yes
No

 

Output that i got by creating a Adhoc Report from the domain that i have created.

 

    DUMMY
---------
      100
        0

[swood]

You need to add the DECODE statement into a custom query in the domain. At the moment, you will need to edit the domain XML directly to do this. In the release at the end of the month, the domain editor can do this through the browser.

 

Sherman

Jaspersoft