sugita

Hi, What do you mean by closing a line. Do you want to put a separator at the end of detail band? If you want to add a line as separator, you can do so by addding it at the beginning of summary page. Regards, Sugita

Hi Anushka, Do you mean that you have to create two prompts or a single prompt? What do you mean by start and end date tab? please explain. Regards, Sugita

The column size depends on the data coming in database. There are few columns, the size of whose exceeds 255 bytes. How to handle these scenarios.

I am working on designing Standard Code Review Checklist for Jasper Reports and Jasper Server. Please provide your inputs or share if you have any existing Checklist for the same.

Hi, I am making changes in the report query and the report is not getting opened when I save and reopen it. The Error I get it: Error loading the report template: org.xml.sax.SAXParseException: Invalid byte 1 of 1-byte UTF-8 sequence. Please let me know what can be the issue. Regards, Sugita

Thanks for the clarification. But this didn't solve my problem as it becomes a Merged Cell and throws error while using sort feature of the Excel.

Thanks for your response. This feature does the same function as "Stretch with Overflow" Property of the field. The moment data exceeds more than the column height, it becomes a Merged Cell and throws error while using sort feature of the Excel.

The problem we are facing is the Merged Cell when we do Stretch with Overflow and if we don't do stretch with Overflow the data gets truncated. So finally we are looking for a feature to be used in Excel Report which allows the data exported in Excel to be sorted and not truncated. I tried increasing the size of the column to get this working but as soon as the larger data value gets it, ut gets truncated. Please let me know how to resolve this.

Hi Ahmed, Please check if the Property of the Report "Summary on a new page" is checked. Regards, Sugita

Hi, I am unable to find out the js-import.sh and js-export.sh. Do I need to unzip any war file to get this. I have JasperServer Professional installed on Unix integrated with Oracle EBS instance. Please let me know the default location. Regards, Sugita

Hi, Now when I am executing the command, I am getting the below mentioned error. Error occurred during initialization of VM. Could not reserve enough space for object heap Do I need to change some settings. Please help. Regards, Sugita

Hi, I am executing js-export command on Unix Server. The Error I am getting is: Exception in thread "main" java.lang.NoClassDefFoundError: com/jaspersoft/jasperserver/export/ExportCommand Please help. Regards, Sugita

I was not able to understand whats the issue exactly. If you are having the Parameter Prompts as Start Date and End Date then in the Report Query you can add this condition in Where Clause.(... where.....and <date Column anme> between $P{Start_Date} and $p{End_Date}. ) Are you looking for all the Dates between these two dates from DUAL table or any other table?

Check if in the Subreport Property- Title on New Page is Checked. This will lead to the the title getting displayed as blank page even if the content might not be there. If this is not the issue, can you paste the JRXMLs here.

Hi, On JasperServer, based on parameter when the report is generated, using the icon on the top, we export it to desired format(PDF, Excel, Flast...etc). When we click on certain icon, it gets exported to that format and on clicking "Save As" gives a default file name. I want to get this FILE NAME changed based on the Parameter Value. As far as I understand now, it cannot be changed as it is static. Please let me know if we can. Sorry, I was not able to explain it properly.I don't want the Report Title or Header in the contents to change. Regards, Sugita