deepapriyan

Hi, We are trying to run report using jasper's REST api (PUT method). We got 'HTTP/1.1 400 Bad Request' as response. URL: http://localhost:8080/jasperserver-pro/rest/resource/reports/samples/MyReport?RUN_OUTPUT_FORMAT=PDF ResourceDescriptor : ------------------------- PFA Document Request Header: ------------------------ PFA Document Response : ------------------------ PFA Document Here the report is a static report so the "ResourceDescriptor" is not containing any parameters. Could you please give us an example for PUT request? Thanks,

Hi I have attached the piece of code. Thanks Deepa

Hi PFB the piece of code in jrxml componentElement reportElement uuid="20608f50-48df-4c52-9498-f431ed7ec34a" key="table" style="table" x="0" y="0" width="1051" height="345" isPrintInFirstWholeBand="true"> Thanks Deepa

Hi I am generating a jrxml with a table component and providing the property for the table as follows :- But when I search for this id in the div element created for this table,I cannot see the id attribute.I need to use this id attribute for further customization. The same property if given for a static text or any column inside the table,it is shown in the HTML elements in UI.Can someone tell me how I can provide a Id attribiute for the table div element in UI? ThanksDeepa

Hi I am trying to make some changes and customize my UI of Jaspersoft in Liferay.Could any you help me in finding out where I could get the source code for JasperReportsServer-portlet-4.7.0? Thanks Deepa

Hi I am trying to make some changes and customize my UI of Jaspersoft in Liferay.Could any you help me in finding out where I could get the source code for JasperReportsServer-portlet-4.7.0? Thanks Deepa

Hi Thanks for the reply. In my case i am trying to add an extra condition to where clause of a query based on whether my date field is empty or not. So my conditional query is formed like this:- <parameter name="FromDate_SQL" class="java.lang.String"> <defaultValueExpression><![CDATA[$P{FromDate}==null?"and s.time_slot >= to_date('2012-06-30','YYYY-MM-DD')" : "and s.time_slot >= to_date('2012-07-02','YYYY-MM-DD')"]]></defaultValueExpression> </parameter> Later in my actual query am doing the following : <queryString> <![CDATA[select * from detailTable where detailId =1 $P!{FromDate_SQL}]]> </queryString> My problem out here is for checking whether the $P{FromDate} has some value entered or not or checking if there is a default value.In the conditional query that I am creating,I am always getting the value of $P{FromDate} as null. Please help. Thanks Deepa

Hi I have created a report which take From Date as an input Control Value.While declaring the dataType for this field gave the type as "Date".In my jrxml I have created a parameter $P{FromDate} as follows <parameter name="FromDate" class="java.util.Date"/> This field is not a mandatory field and can be left blank.If the user enters some value,based on that Date value I need to filter out my data and show in the report.So I am creating a conditional query statement to be added to my basic query. My problem is I am not able to check for the condition in the query whether $P{FromDate} is null or empty or have a value and form my query.Please help.This is urgent. Thanks In Advance Deepa

Hi I have created a report which take From Date as an input Control Value.While declaring the dataType for this field gave the type as "Date".In my jrxml I have created a parameter $P{FromDate} as follows <parameter name="FromDate" class="java.util.Date"/> This field is not a mandatory field and can be left blank.If the user enters some value,based on that Date value I need to filter out my data and show in the report.So I am creating a conditional query statement to be added to my basic query. My problem is I am not able to check for the condition in the query whether $P{FromDate} is null or empty or have a value and form my query.Please help.This is urgent. Thanks In Advance Deepa

Hi I have created a report which take From Date as an input Control Value.While declaring the dataType for this field gave the type as "Date".In my jrxml I have created a parameter $P{FromDate} as follows <parameter name="FromDate" class="java.util.Date"/> This field is not a mandatory field and can be left blank.If the user enters some value,based on that Date value I need to filter out my data and show in the report.So I am creating a conditional query statement to be added to my basic query. My problem is I am not able to check for the condition in the query whether $P{FromDate} is null or empty or have a value and form my query.Please help.This is urgent. Thanks In Advance Deepa

Hi I have created a report using the Fusion charts.I want to export the data to an excel.So I go to the Export >> As excel option and try to create the excel.The excel was blank.From the forums, I found that we need to set the "ignoreGraphics" property of xlsExportParameters to false in applicationContext.xml for the graphic images to be exported to excel.I did the same and restarted my server.When I click on Export as excel , the message that i get is "Flash Component". I have used Fusion charts integrated with javascript (Highcharts ) option.Even with plugins disabled,I am unable to create the excel contents. Please help. Thanks In Advance Deepa

Hi I added a Stacked bar chart in my desginer from Chart-pro.The orientation of the stacks are horizontal.Could you please guide me on how i can make the orientation of Stacks to vertical? Its kind of urgent ...please help Thanks Deepa

Hi I have got a bar chart with date values on 'X-Axis' and number values on Y Axis.What i want to do is,when I click on one bar in the main graph,I need to display a child graph with more details about the clicked bar .In short,different different graph needs to be displayed beside the main graph based on the datapoint that I click.I read about the subreports,but creating subreports for each datapoint in the same page (this is important) as the main graph was not possible.Please help. Thanks In Advance Deepa

Hi I am using iReport professional 4.5.1 and Jasperserver version 4.5.1.I have the jasperserver running in one of the machine with DS authentication enabled in it for login.So as guessed ,we need to use SSL (https:// ) for accessing the jasperserver UI.When I try to access this repository from iReport,I first get the following message :- Unknown certificate: The servers host key is not cached in iReport. Please check the attachment of the same.I get the option to either Accept the certificate permanently or for the current session of iReport or do not accept at all.I select the option for selecting certificate for the current session of iReport and when i continue get the following message : Error: nested exception is : org.xml.sax.SaxException:Bad envelope tag : html As suggested in many discussions and forums,we modified the applicationContext-security-web.xml to include the uploadMultipartFilter.But still facing the same issue. Could you please guide me on how i can configure my Jasperserver repository with secured connection in iReport. Thanks In Advance Deepa

Thanks Olga ... But i guess it would be great if we could upload the theme as a zip file because it would reduce the manual effort in creating the folders and then moving the new images or css if any... Am still not able to figure out how the folder should be zipped and uploaded so that i don't get the subfolders. Tried adding .data and .xml files for all the images and css files and then upload to the repository..but did not work :(

Hi I am new to Jasperserver.Am working on the community version of Jasperserver and needs few UI customization. As suggested in many forums and documents available, i tried to create a new theme.First downloaded and existing theme then made modifications to the css files and images and compressed the folder with a new name.After that uploaded this newly created theme as a zip folder.But when I expand the newly added theme folder ,can see a subfolder with the same name as theme folder and on clicking "Set As Active theme " option for this get the following exception :- Error Messagecom.jaspersoft.jasperserver.api.JSDuplicateResourceException: jsexception.folder.already.exists Error Tracecom.jaspersoft.jasperserver.api.JSDuplicateResourceException: jsexception.folder.already.exists at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryServiceImpl$11.execute(HibernateRepositoryServiceImpl.java:314) at com.jaspersoft.jasperserver.api.metadata.common.service.impl.HibernateDaoImpl.executeWriteCallback(HibernateDaoImpl.java:73) at com.jaspersoft.jasperserver.api.metadata.common.service.impl.HibernateDaoImpl.executeWriteCallback(HibernateDaoImpl.java:64) at Please help. Thanks In Advance Deepa