[Rest API issue while running a report using PUT request]

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,
 

[Provide the html id for table element]

Hi

I have attached the piece of code.

 

Thanks

Deepa

[Provide the html id for table element]

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

[Provide the html id for table element]

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?

 

Thanks

Deepa

 

 

[JasperReportsServer-portlet-4.7.0 soruce code location]

 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

[MOVED:JasperReportsServer-portlet-4.7.0 soruce code location]

 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

[Date parameter not getting picked properly]

 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

[Issue in generating conditional query with Date field parameter]

  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

[MOVED:Issue in generating conditional query with Date field parameter]

  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

[Date parameter not getting picked properly]

 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

[Export As excel option not working for Fusion Chart reports]

 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

[Change the orientation of Stacked bar charts added from Charts-pro in iReport]

 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

 

 

[Creating sub reports on click of each data point in the graph.]

 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

[Issue in setting up Jasperserver repository with DS Authentication enabled in iReport]

 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

 

 

 

 

[Issue in new theme activation]

 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 :(

 

 

[Issue in new theme activation]

 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 Message

com.jaspersoft.jasperserver.api.JSDuplicateResourceException: jsexception.folder.already.exists

Error Trace

com.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