kmn

There is requirement where in the user should be able to select atmost 120 values out of 1000's of particular input control in jasper server in multi select query.Can this be implemented??

For removing duplicate rows you can create a dummy group[Without any field and exclude Group header or Footer While Creating]. Select all the fields in Detail band and in print when expression give $V{DummyGroup_COUNT}.intValue()==1 This will eliminate duplicate values.

Hi , Give the paramter type as java.util.Collection.

Hi , Give the paramter type as java.util.Collection.

Hi All, How to implement the following array to a field in jasper Dim list As String List = TRIM(UCASE(TranStat))Dim array() As String Dim numberOfElements As Integer numberOfElements = ListToArray( list, array, "," )Dim text2 As String 'Dim temp As StringDim i As Integer If Trim(LANG) = "" OR Trim(LANG) = "ENG" ThenFor i = 1 To numberOfElements If array(i)= "CANCELED" Then text2 = text2 & "Canceled,"ElseIf array(i)= "EXECUTED" Then text2 = text2 & "Executed Orders,"ElseIf array(i)= "FAILING" Then text2 = text2 & "Failing,"ElseIf array(i)= "OPEN" Then text2 = text2 & "Open Orders,"ElseIf array(i)= "PENDFAIL" Then text2 = text2 & "Pending and Failing,"ElseIf array(i)= "PENDING" Then text2 = text2 & "Pending,"ElseIf array(i)= "UNVERIFIED" Then text2 = text2 & "Unverified,"ElseIf array(i)= "PENDCANC" Then text2 = text2 & "Pending Cancellation,"Else text2 = text2 & array(i)End If Next i text2 = Left(text2 ,(Len(text2 )-1)) Else For i = 1 To numberOfElements If array(i)= "CANCELED" Then text2 = text2 & "," & BtreeHelper.getTranslationNew("Canceled")ElseIf array(i)= "EXECUTED" Then text2 = text2 & "," & BtreeHelper.getTranslationNew("Executed Orders")ElseIf array(i)= "FAILING" Then text2 = text2 & "," & BtreeHelper.getTranslationNew("Failing")ElseIf array(i)= "OPEN" Then text2 = text2 & "," & BtreeHelper.getTranslationNew("Open Orders")ElseIf array(i)= "PENDFAIL" Then text2 = text2 & "," & BtreeHelper.getTranslationNew("Pending and Failing")ElseIf array(i)= "PENDING" Then text2 = text2 & "," & BtreeHelper.getTranslationNew("Pending")ElseIf array(i)= "UNVERIFIED" Then text2 = text2 & "," & BtreeHelper.getTranslationNew("Unverified") ElseIf array(i)= "PENDCANC" Then text2 = text2 & "," & BtreeHelper.getTranslationNew("Pending Cancellation") Else text2 = text2 & array(i)End If Next i text2 = Right(text2 ,(Len(text2)-1))End if

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.

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

found the solution It was because of those brackets in sql query

I'm getting this error The query which I'm using is (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_type = 'DISENR' ANDa.application_status <> 'CMSAPPR' THEN 'MCO Initiated/InProgress' 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 REQUESTED_EFFECTIVE_DATE <= sysdateAND $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_type = 'DISENR' ANDa.application_status = 'CMSAPPR' THEN 'MCO Initiated/Complete' 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 REQUESTED_EFFECTIVE_DATE <= sysdateAND $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 mp.plan_end_date <=sysdate THEN 'CMS Initiated/ Complete' ELSE 'CMS Initiated/ Inprogress' 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 mp.DISENROLLMENT_REASON_CODE IS NOT NULLAND $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 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_idAND $X{IN,PLAN_ID,PlanID}) is this because I'm using AND $X{IN,PLAN_ID,PlanID} several times

ya i know that but what should be the datatype of the paramter. when i create with date it will show the date picker which i dont want. but i should be able to select month and year

I want to implement this Also For DISENROLLMENT STATUS (DISENROLLED)- Only those members need to be displayed who are in APPLICATIONS table with APPLICATION_STATUS = CMSAPPR and APPLICATION_TYPE=DISENR For DISENROLLMENT STATUS(DISENROLLMENT INPROGRESS) – Display those members whose APPLICATION_STATUS not equal to CMSAPPR and APPLICATION_TYPE = DISENR WE need to add two more statuses 1. DISENROLLMENT CANCELLED – Display those members whose APPLICATION_STATUS is CMSAPPR and APPLICATION_TYPE=’CANDISENR’ 2. DISENROLLMENT CANCELLATION INPROGRESS – Display those members whose APPLCIATION_STATUS is not equal to CMSAPPR and APPLICATION_TYPE=’CANDISENR’ Variable added : Datatype: java.lang.Double ($F{APPLICATION_STATUS}.equals( "CMSAPPR " )&& $F{APPLICATION_TYPE}.equals( "DISENR" )?"DISENROLLED":"DISENROLLMENT INPROGRESS")||($F{APPLICATION_STATUS}.equals( "CMSAPPR " )&& $F{APPLICATION_TYPE}.equals( "CANDISENR" )?"DISENROLLMENT CANCELLED":"DDISENROLLMENT CANCELLATION INPROGRESS ") But this shows error : The operator || is undefined for the argument type java.lang.string

The parameters I will be passing is only Month and Year and not date.

Hi, I am giving a date range for a parameter like dis "where mp.created_date BETWEEN $P{FromDate} AND $P{ToDate} " this has 13 records in db for date between 1st june and 2nd june but in jaspersoft studio it s displaying only 8 records.

you can filter your reports either by using where condition in your query or create parameter for input level filters. I guess you cannot create checkbox filter in studio but the same can be done in server..after you publish the report from studio to server you can change the type for the input control.

(Giving my report Example) In Studio : Create parameter with data type as java.util.Collection (Ex : ParameterName: AppliactionStatus, Class :java.util.Collection) In Query builder : Give this condition WHERE $X{IN,APPLICATION_STATUS,ApplicationStatus} and execute , this will pick the status from DB. Publish in Server : Edit Report : Input controls :select ApplicationStatus and next step ,select type :Multi-select-List of values and the name and values. This will show as a multi select parameters.

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.

It is showing data in studio but in server it is showing no data available with the same datasource and parameters.

Hi all, Please let me know on the topics to be covered for jasper interview preparation. is knowledge on 1) jasperStudio,JasperServer,Oracle SQL sufficient?? or Oracle PL/SQL ,JAVA and any other is required.

Hi All, Can anybody please tell me how to create a gantt chart