rpayyavula

Is it possible to create Multiselect Prompt(Inputcontrol) in Jasperserver?

I am trying to deploy a jasperreport with a subreport in jasperserver and use as expression for accessing subreport something like: "repo:Reportname". The normal reports without subreport work perfectly. When i run this report in Jasperserver, i am getting error as follows. If i run this report in IReport designer changing the subreport expression to the local path where that subreport is existing, then it works. I am getting the following error message. org.springframework.webflow.ActionExecutionException: Exception thrown executing [AnnotatedAction@f755b7 targetAction = com.jaspersoft.jasperserver.war.action.ViewReportAction@1c88db, attributes = map[[empty]]] in state 'verifyData' of flow 'viewReportFlow'; nested exception is net.sf.jasperreports.engine.JRRuntimeException: net.sf.jasperreports.engine.JRException: Error preparing statement for executing the report query : select distinct "SCC_CONTACT"."CREATE_DT" AS "Create_Date", "SCC_CONTACT"."CONTACT_ID" AS "Contact_ID", "SCC_CONTACT_TYPE"."CONTACT_TYPE_NAME" AS "Contact_Type", "SCC_CONTACT"."CONTACT_TITLE" AS "Contact_Title", "SCC_CONTACT"."PERSON_ID" AS "Person_ID", "SCC_PERSON"."LAST_NAME_DISPLAY"+', '+"SCC_PERSON"."FIRST_NAME_DISPLAY" AS "Full_Name__Last__First_", "SCC_PERSON"."NICK_NAME" AS "Nick_Name", "SCC_PERSON"."DOB_DT" AS "Date_of_Birth", "SCC_PERSON"."GENDER" AS "Gender", "Contact_Eaddress_Exist"."Contact Eaddress Exist" AS "Contact_Eaddress_Exist", "Contact_GeoAddress_Exist"."Contact Geoaddress Exist" AS "Contact_Geoaddress_Exist", "Contact_Activities_Exist"."Contact Activities Exist" AS "Contact_Activities_Exist", "Contact_CA_Exist"."Contact CA Exist" AS "Contact_CA_Exist" from "SCC_CONTACT" "SCC_CONTACT", "SCC_CONTACT_TYPE" "SCC_CONTACT_TYPE", "SCC_PERSON" "SCC_PERSON", ( select distinct "T1"."C0" AS "Contact ID", "T0"."C1" AS "Contact Eaddress Exist" from ( select "SCC_CONTACT"."CONTACT_ID" AS "C0", max(case when NOT "SCC_CONTACT_EADDRESS"."EADDR_ID" is null then 'View EAddress' else null end ) AS "C1" from "SCC_CONTACT" "SCC_CONTACT" LEFT OUTER JOIN "SCC_CONTACT_EADDRESS" "SCC_CONTACT_EADDRESS" on "SCC_CONTACT"."CONTACT_ID" = "SCC_CONTACT_EADDRESS"."CONTACT_ID" group by "SCC_CONTACT"."CONTACT_ID") "T0", ( select "SCC_CONTACT"."CONTACT_ID" AS "C0" from "SCC_CONTACT" "SCC_CONTACT" LEFT OUTER JOIN "SCC_CONTACT_EADDRESS" "SCC_CONTACT_EADDRESS" on "SCC_CONTACT"."CONTACT_ID" = "SCC_CONTACT_EADDRESS"."CONTACT_ID") "T1" where "T1"."C0" = "T0"."C0") "Contact_Eaddress_Exist", ( select distinct "T1"."C0" AS "Contact ID", "T0"."C1" AS "Contact Geoaddress Exist" from ( select "SCC_CONTACT"."CONTACT_ID" AS "C0", max(case when NOT "SCC_CONTACT_GEOADDRESS"."GEOADDR_ID" is null then 'View GeoAddress' else null end ) AS "C1" from "SCC_CONTACT" "SCC_CONTACT" LEFT OUTER JOIN "SCC_CONTACT_GEOADDRESS" "SCC_CONTACT_GEOADDRESS" on "SCC_CONTACT"."CONTACT_ID" = "SCC_CONTACT_GEOADDRESS"."CONTACT_ID" group by "SCC_CONTACT"."CONTACT_ID") "T0", ( select "SCC_CONTACT"."CONTACT_ID" AS "C0" from "SCC_CONTACT" "SCC_CONTACT" LEFT OUTER JOIN "SCC_CONTACT_GEOADDRESS" "SCC_CONTACT_GEOADDRESS" on "SCC_CONTACT"."CONTACT_ID" = "SCC_CONTACT_GEOADDRESS"."CONTACT_ID") "T1" where "T1"."C0" = "T0"."C0") "Contact_GeoAddress_Exist", ( select distinct "T1"."C0" AS "Contact ID", "T0"."C1" AS "Contact Activities Exist" from ( select "SCC_CONTACT"."CONTACT_ID" AS "C0", max(case when NOT "SCC_CASE_CONTACT"."CASE_ID" is null then 'View Activities' else null end ) AS "C1" from "SCC_CONTACT" "SCC_CONTACT" LEFT OUTER JOIN "SCC_CASE_CONTACT" "SCC_CASE_CONTACT" on "SCC_CONTACT"."CONTACT_ID" = "SCC_CASE_CONTACT"."CONTACT_ID" group by "SCC_CONTACT"."CONTACT_ID") "T0", ( select "SCC_CONTACT"."CONTACT_ID" AS "C0" from "SCC_CONTACT" "SCC_CONTACT" LEFT OUTER JOIN "SCC_CASE_CONTACT" "SCC_CASE_CONTACT" on "SCC_CONTACT"."CONTACT_ID" = "SCC_CASE_CONTACT"."CONTACT_ID") "T1" where "T1"."C0" = "T0"."C0") "Contact_Activities_Exist", ( select distinct "T1"."C0" AS "Contact ID", "T0"."C1" AS "Contact CA Exist" from ( select "SCC_CONTACT"."CONTACT_ID" AS "C0", max(case when NOT "SCC_CONTACT_CA_DATA"."CONTACT_CA_ID" is null then 'View Contact CA' else null end ) AS "C1" from "SCC_CONTACT" "SCC_CONTACT" LEFT OUTER JOIN "SCC_CONTACT_CA_DATA" "SCC_CONTACT_CA_DATA" on "SCC_CONTACT"."CONTACT_ID" = "SCC_CONTACT_CA_DATA"."CONTACT_ID" group by "SCC_CONTACT"."CONTACT_ID") "T0", ( select "SCC_CONTACT"."CONTACT_ID" AS "C0" from "SCC_CONTACT" "SCC_CONTACT" LEFT OUTER JOIN "SCC_CONTACT_CA_DATA" "SCC_CONTACT_CA_DATA" on "SCC_CONTACT"."CONTACT_ID" = "SCC_CONTACT_CA_DATA"."CONTACT_ID") "T1" where "T1"."C0" = "T0"."C0") "Contact_CA_Exist" where "SCC_CONTACT"."ORG_ID" in (?) and "SCC_CONTACT"."PERSON_ID" 0 and "SCC_CONTACT"."CONTACT_TYPE_ID" = "SCC_CONTACT_TYPE"."CONTACT_TYPE_ID" and "SCC_CONTACT"."PERSON_ID" = "SCC_PERSON"."PERSON_ID" and "SCC_CONTACT"."CONTACT_ID" = "Contact_Eaddress_Exist"."Contact ID" and "SCC_CONTACT"."CONTACT_ID" = "Contact_GeoAddress_Exist"."Contact ID" and "SCC_CONTACT"."CONTACT_ID" = "Contact_CA_Exist"."Contact ID" and "SCC_CONTACT"."CONTACT_ID" = "Contact_Activities_Exist"."Contact ID"

I have included crosstab and pie chart in my report, in which i am getting correct data in crosstab. But in Pie chart, i am not getting accurate data. So i changed the chart properties by setting an AttributeÂ"evaluationTime"ÂwithÂvalueÂ"Auto". If i set this, i am getting error as "AttributeÂ"evaluationTime"ÂwithÂvalueÂ"Auto"ÂmustÂhaveÂaÂvalueÂfromÂtheÂlistÂ"NowÂReportÂPageÂColumnÂGroupÂBand". Can anyone suggest me how to resolve this error? Thanks in advance.. Radha Post edited by: rpayyavula, at: 2007/04/23 09:07

Place the Grand Total fields in Summary band.

Does IReport designer supports drillthrough feature, i.e., drillthrough from one report to another?