ananth890

HI Gurus, I have created Jaspeer studio report with main and table . ( i mean calling table in main report) it is working fine locally but after uploading in to server it is showing only null values . i think parameters are not accepting values . ( but same parameters are working locally with out any issue). please can you help . Thank you

Hi Gurus My requirement is we have report with oracle database only but we want to getting parameter values from CSV file is it possible? I mean , we are getting some IDs from user in CSV file. we have to use those values as input parameter to craete report every month. we are using Jasper 6.1 is it possible? Thanks for your time.

Hi Gurus, My requirment is User want to enter multi values in paramter to get report. I created report with parameter . using where condition IN $X . it is working fine on studio but we have to ADD one after one values then we have to run report. it looks good. i uploaded this report in server and created input comtrol with multi value option. but i am unable to enter values there. Could you please let me know where i am doing worng and let if we ahve any document for thsi scenario ? Thank you very much for your support.

Hi Gurus, We are scheduling reports. Users are getting links and if they click then they will review report. But users doesn’t want to click and review report whenever there is no data in Report . ( They do not want waste time to click and review empty report). My question is, Is it possible to send any message along with schedule report link if there is no data or count of records. So user will come to know is report empty or not. It will save user time. I mean User will get report link along with message as count of number of records. so user will come to know either report has data or not before they click on the link. is it possible in jasper report schedule.? if yes any idea how can i achive this one? please help me . Thanks in advance for your time.

Thank you very much for yopur support. it is working perfectly

Hi Gurus, I am creating simple report, I would like to pass multi values in parameter . I am using Jasper studio 6.1.1. so i created one parameter and updated query select company_id,Legal_Name, Created_Date,Fed_Tax_Id_Nbr,Membership_Id,Phone_Nbr,Company_Status_Codefrom companywhere $X{IN,Legal_Name,LegName} class type : java.util.Collections it is not prompting parameter ( i cecked is prompt option) report is displaying all records. I mean parameter is skipping . if i convert that parameter to single value then it is working like where Legal_name = $P{LegName} I am not sure why it is happening please help me .here is jrxml code ?xml version="1.0" encoding="UTF-8"?><!-- Created with Jaspersoft Studio version 6.1.1.final using JasperReports Library version 6.1.1 --><!-- 2016-11-10T12:14:14 --><jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="Test Report 1" pageWidth="842" pageHeight="595" orientation="Landscape" columnWidth="802" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="f5743a28-35ba-4336-b309-c06e22d06154"><property name="com.jaspersoft.studio.data.sql.tables" value=""/><property name="com.jaspersoft.studio.data.defaultdataadapter" value="DEV4"/><property name="ireport.jasperserver.url" value="https://pmx-dev4-jasper.saas-n.com/jasperserver-pro/"/><property name="ireport.jasperserver.user" value="superuser"/><property name="ireport.jasperserver.report.resource" value="/organizations/PaymodeX/SandBox/Test_Report_1_files/main_jrxml"/><property name="ireport.jasperserver.reportUnit" value="/organizations/PaymodeX/SandBox/Test_Report_1"/><parameter name="LegName" class="java.util.Collections" nestedType="java.lang.String"/><queryString><![CDATA[select company_id,Legal_Name, Created_Date,Fed_Tax_Id_Nbr,Membership_Id,Phone_Nbr,Company_Status_Codefrom companywhere $X{IN,Legal_Name,LegName}]]></queryString><field name="COMPANY_ID" class="java.math.BigDecimal"/><field name="LEGAL_NAME" class="java.lang.String"/><field name="CREATED_DATE" class="java.sql.Timestamp"/><field name="FED_TAX_ID_NBR" class="java.lang.String"/><field name="MEMBERSHIP_ID" class="java.math.BigDecimal"/><field name="PHONE_NBR" class="java.lang.String"/><field name="COMPANY_STATUS_CODE" class="java.math.BigDecimal"/><background><band splitType="Stretch"/></background><title><band height="26" splitType="Stretch"/></title><pageHeader><band height="35" splitType="Stretch"/></pageHeader><columnHeader><band height="37" splitType="Stretch"><staticText><reportElement x="8" y="0" width="100" height="30" uuid="7a692544-26bd-4ad1-b2b3-f8ba3ce03097"/><text><![CDATA[COMPANY_ID]]></text></staticText><staticText><reportElement x="111" y="0" width="100" height="30" uuid="72436c9c-90d2-406f-9edd-04a7a11f8512"/><text><![CDATA[LEGAL_NAME]]></text></staticText><staticText><reportElement x="215" y="0" width="100" height="30" uuid="720e8de8-71e3-45e6-b25a-108b627055c1"/><text><![CDATA[CREATED_DATE]]></text></staticText><staticText><reportElement x="322" y="0" width="100" height="30" uuid="b9f7dcd8-645e-44b1-a881-fade1ef2ba50"/><text><![CDATA[FED_TAX_ID_NBR]]></text></staticText><staticText><reportElement x="425" y="0" width="100" height="30" uuid="74e6cda1-f321-4210-8ad6-e8d2c343ed48"/><text><![CDATA[memberSHIP_ID]]></text></staticText><staticText><reportElement x="532" y="0" width="100" height="30" uuid="eb715224-3153-44e4-aae8-b15eadd6c1f6"/><text><![CDATA[PHONE_NBR]]></text></staticText><staticText><reportElement x="638" y="0" width="100" height="30" uuid="a412c34f-f2e6-44e4-815a-9fb2fde1ba26"/><text><![CDATA[COMPANY_STATUS_CODE]]></text></staticText></band></columnHeader><detail><band height="46" splitType="Stretch"><textField><reportElement x="8" y="5" width="100" height="30" uuid="0e153bfa-2576-4a7a-a504-c8f249cca914"/><textFieldExpression><![CDATA[$F{COMPANY_ID}]]></textFieldExpression></textField><textField><reportElement x="111" y="4" width="100" height="30" uuid="38aac2c9-7d52-48ca-983e-d79afdbed2aa"/><textFieldExpression><![CDATA[$F{LEGAL_NAME}]]></textFieldExpression></textField><textField><reportElement x="215" y="7" width="100" height="30" uuid="1ff64753-98a7-40e1-85cb-96f537f3d9be"/><textFieldExpression><![CDATA[$F{CREATED_DATE}]]></textFieldExpression></textField><textField><reportElement x="322" y="4" width="100" height="30" uuid="3be2e29f-4593-4006-bb58-016bbd80cb50"/><textFieldExpression><![CDATA[$F{FED_TAX_ID_NBR}]]></textFieldExpression></textField><textField><reportElement x="425" y="3" width="100" height="30" uuid="d6325bc2-fbc4-4e94-8db5-2562bc6b4928"/><textFieldExpression><![CDATA[$F{MEMBERSHIP_ID}]]></textFieldExpression></textField><textField><reportElement x="532" y="5" width="100" height="30" uuid="0f6f0103-c6e4-4792-9c31-a599eda6d9a5"/><textFieldExpression><![CDATA[$F{PHONE_NBR}]]></textFieldExpression></textField><textField><reportElement x="638" y="8" width="100" height="30" uuid="d09c2cdf-49a6-4d50-8a92-94e3bd8e5ba6"/><textFieldExpression><![CDATA[$F{COMPANY_STATUS_CODE}]]></textFieldExpression></textField></band></detail><columnFooter><band height="15" splitType="Stretch"/></columnFooter><pageFooter><band height="7" splitType="Stretch"/></pageFooter><summary><band height="20" splitType="Stretch"/></summary></jasperReport> Thanks in advance for your support.

Hi All, We would like to disable Include report files as attachments option whenever we schedule report. Due to company security policy user should not attach any output to Email. could you please let me know how can i disable or hide Include report files as attachments option in notification section of report scheduler. Thank you very much for your support in advance

HI Gurus, i am creating Domain using SQL (Derived tables) . i have RTRIM(XMLAGG(XMLELEMENT(E,ven.consolidated_vendor_nbr,',').EXTRACT('//text()')).GetClobVal(),',') as vendor_numbers in select statement. after creating table i could not see Vendor number column ( I think Because i am using XML Type) . in TABLE but I can see all other columns except this columns. How can I solve this issue. Thanks in advance for your support.