Jump to content
We've recently updated our Privacy Statement, available here ×

kmn

Members
  • Posts

    19
  • Joined

  • Last visited

Community Answers

  1. kmn's post in Report which works in jasperstudio is not working in server was marked as the answer   
    There was no logical problem in this.

    I deleted Parameters in jasper studio and created again and then published in server and now it works.

  2. kmn's post in Variable in jasper studio was marked as the answer   
    i used it in query instead of a variable
     
    select  DISTINCT pm.plan_id,mp.DISENROLLMENT_REASON_CODE ,a.member_member_id,mp.plan_start_date,mp.plan_end_date,a.APPLICATION_STATUS,a.application_type,CASE WHEN a.application_Status='CMSAPPR' AND a.APPLICATION_TYPE= 'CANDISENR' THEN 'Disenrollment Cancelled' ELSE '' END  AS DISENROLLMENTSTATUS from applications a,member_plans mp,product_master pmWHERE a.member_member_id =mp.member_member_idAND a.customer_id=pm.customer_idAND $X{IN,PLAN_ID,PlanID}UNION select  DISTINCT pm.plan_id,mp.DISENROLLMENT_REASON_CODE ,a.member_member_id,mp.plan_start_date,mp.plan_end_date,a.APPLICATION_STATUS,a.application_type,CASE WHEN a.application_Status<>'CMSAPPR' AND a.APPLICATION_TYPE= 'CANDISENR' THEN 'Disenrollment Cancellation In Progress' ELSE '' END  AS DISENROLLMENTSTATUS from applications a,member_plans mp,product_master pm WHERE a.member_member_id =mp.member_member_idAND a.customer_id=pm.customer_id 
  3. kmn's post in Report is not working in server but is working in studio was marked as the answer   
    found the solution
     
    It was because of those brackets in sql query
×
×
  • Create New...