atmaling

HI, Can you tell, where is the attachment?

Hi, I want to hide 1st group header band on every page. I tried below: - I created a variable $V{group_no} with calculation type=count, reset type=page, variable expression=$F{group_field} and initial expression=0 - Then I printed this variable's value in Group header , so its printing the values as 0,1,2 (if three group headers on a page) in group headers on the page, like other pages. - So when I tried Group header Band's print when expression as : $V{group_no}>0, then its not hiding the first group header band of the page. - Don't know what's wrong , as it's printing correct values in Band but not working in the band's print when expression. Thanks in advance...!!!

Select the band which you want to hide, give the Print When Expression as "false".

Still didn't find any solution

Thanks Jeff.It's working fine. There is another requirement, I want to hide these columns only for normal users and show them to admin.Can I make this ?

Thanks Jeff. It's working fine. Can I make this as conditional such as hiding these columns only for normal users and showing for Administrator.

Hi, I want to customize the repository view of jasper-server. When we browse the JasperServer repository it shows below columns: Name, Description,Type, Created Date, Modified Date But I want to hide "Created Date" and "Modified Date" columns. I tried to edit the results.jsp file from WEB-INF/jsp/modules/search folder however I could hide the header of these columns but coudn't hide its values. I am using jasperserver-4.7 commercial edition. Kindly help me

JasperSoft has resolved this issue in the updated version of JasperMobile 1.7 app. It's working fine now for my android. Download it from Android Play Store.

Can you show your PrintWhen expression ?

Hi, I have installed JasperMobile on my Android phone. After giving server credentials I am able to connect to repository and view reports in folders.But when I clicked on Run Report button after selecting input controls.I got this message : "404-Not Found. The URI requested is invalid or the resource requested does not exists". My Jasperreports server version is : 4.7.1 and Android version is : 4.0 I also tested on other android device, getting same error.

Hi, I am not able to access the JasperServer repository from iReport. Before few days I was able to access this reporsitory without any problem, but don't know what happened now. Now I get following message when I try to connect repository from iReport: Error:; [/code]nested exception is:[/code]java.net.ConnectException: Connection timed out: connect[/code] But I am able to access this repository from my Browser (i.e. from JasperServer web app). As I am having large no. of reports which I have to deploy over the production from Local machine. Its very important for me to deploy from iReport. Is there anything like blocking of specific port in my network ? Please help me. Thanks in Advance..!!

With the Ignore_Pagination property, report is coming fine in CSV. But in PDF its coming in Single page. So how to Igonore pagination while exporting to CSV only ?

hi, Can u post some of ur database table entries and expected ouput with respect of that.

Hi, I want to hide crosstab headers (or show only once) while exporting to Excel or CSV. I applied following properties but its not working. Column Headers are repeating. net.sf.jasperreports.export.csv.exclude.origin.keep.first.band.1 =pageHeader net.sf.jasperreports.export.csv.exclude.origin.keep.first.band.2 =columnHeader Is there any other property so that Cross-Tab Column headers will be displayed only once in Excel/CSV . Thanks in Advance..!!!

Hi, I want to take sum of previous 2 rows and display it in 3rd row as below: Consider my query has three fields as Shop, Item and Stock as below, I want to take sum of stock and display it in 3rd row. Shop | Item | Stock Shop1 | Item1 | 10 Shop2 | Item1 | 20 Total | Item1 | 30 Shop1 | Item2 | 15 Shop2 | Item2 | 25 Total | Item2 | 40 How it's possible using scriptlets? or any other way ? As I couldn't find much more help on scriptlets on any site. Please help me... Thanks in Advance...!!!

Hi, I want to display the * (asterisk symbol) when the value of the Text field overflow. In iReport Stretch with overflow option is available.But there is not any option if we want to display some character when it's overflowed. I am using iReport 4.1.1 version. Thanks in Advance.

It worked as below: new Boolean(!($P{NO_DATA}.booleanValue()))

It worked as below: new Boolean(!($P{NO_DATA}.booleanValue()))

Hi All, I am using the following logical operator in print when expression. !$P{NO_DATA} where NO_DATA is a parameter of java.lang.Boolean But I am getting following error: The operator ! is undefined for the argument type(s) Boolean. However I run following sample java program successfully: public static void main(String[] args) { Boolean x=true; Boolean y=!x; System.out.println("X=="+x); System.out.println("Y=="+y); } Please help me

Hi All, I am using the following logical operator in print when expression. !$P{NO_DATA} where NO_DATA is a parameter of java.lang.Boolean But I am getting following error: The operator ! is undefined for the argument type(s) Boolean. However I run following sample java program successfully: public static void main(String[] args) { Boolean x=true; Boolean y=!x; System.out.println("X=="+x); System.out.println("Y=="+y); } Please help me

Solution found bcprov-jdk16-145.jar file was missing, downloaded from Include jar file in lib or classpath folder. Below is the list of all required jars jasperreports-3.7.0.1.jar commons-io-1.3.1.jar commons-logging-1.0.4.jar commons-collections-3.2.jar commons-digester-1.7.jar commons-beanutils-1.8.0.jar groovy-all-1.5.5.jar itext-2.1.0.jar bcprov-jdk16-145.jar Below find my code Code:Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection con=DriverManager.getConnection("jdbc:odbc:atm","uid","pwd"); JasperReport jr=JasperCompileManager.compileReport("E:\\Atmaling\\my_programs\\pwdReport.jrxml"); JasperPrint jp=JasperFillManager.fillReport(jr,new HashMap(),con); JRPdfExporter exporter = new JRPdfExporter(); exporter.setParameter(JRExporterParameter.JASPER_PRINT, jp); exporter.setParameter(JRExporterParameter.OUTPUT_FILE,new File("E:\\Atmaling\\my_programs\\pwdReport.pdf")); exporter.setParameter(JRPdfExporterParameter.OWNER_PASSWORD, "hi"); exporter.setParameter(JRPdfExporterParameter.USER_PASSWORD, "hi"); exporter.setParameter(JRPdfExporterParameter.IS_ENCRYPTED, Boolean.TRUE); exporter.exportReport();

Thanks, It worked for me. bcprov-jdk16-145.jar file was missing, downloaded from http://www.bouncycastle.org/latest_releases.html Include jar file in lib or classpath folder. Below is the list of all required jars jasperreports-3.7.0.1.jar commons-io-1.3.1.jar commons-logging-1.0.4.jar commons-collections-3.2.jar commons-digester-1.7.jar commons-beanutils-1.8.0.jar groovy-all-1.5.5.jar itext-2.1.0.jar bcprov-jdk16-145.jar Code: Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection con=DriverManager.getConnection("jdbc:odbc:atm","uid","pwd"); HashMap hm=new HashMap();JasperReport jr=JasperCompileManager.compileReport("E:\\Atmaling\\my_programs\\pwdReport.jrxml"); JasperPrint jp=JasperFillManager.fillReport(jr,new HashMap(),con); JRPdfExporter exporter = new JRPdfExporter(); exporter.setParameter(JRExporterParameter.JASPER_PRINT, jp); exporter.setParameter(JRExporterParameter.OUTPUT_FILE,new File("E:\\Atmaling\\my_programs\\pwdReport.pdf")); exporter.setParameter(JRPdfExporterParameter.OWNER_PASSWORD, "hi"); exporter.setParameter(JRPdfExporterParameter.USER_PASSWORD, "hi"); exporter.setParameter(JRPdfExporterParameter.IS_ENCRYPTED, Boolean.TRUE); exporter.exportReport();

Hi, How to create password protected PDF ?? I tried following code but got the Exception as : java.lang.NoClassDefFoundError: org/bouncycastle/asn1/ASN1OctetString JasperReport jr=JasperCompileManager.compileReport("E:\\report1.jrxml"); JasperPrint jp=JasperFillManager.fillReport(jr,new HashMap(),connection); JRPdfExporter exporter = new JRPdfExporter(); exporter.setParameter(JRExporterParameter.JASPER_PRINT, jp); exporter.setParameter(JRExporterParameter.OUTPUT_FILE,new File("E:\\report1.pdf")); exporter.setParameter(JRPdfExporterParameter.OWNER_PASSWORD, "hi"); exporter.setParameter(JRPdfExporterParameter.USER_PASSWORD, "hi"); exporter.setParameter(JRPdfExporterParameter.IS_ENCRYPTED, Boolean.TRUE); exporter.exportReport(); Having following jars iText-2.1.0.jar jasperreports-3.6.0.jar commons-beanutils.jar commons-collections.jar commons-digester.jar commons-digester-1.7.jar commons-logging.jar groovy-all-1.5.5.jar ojdbc14.jarNot getting more help from anywhere. Plzz help me. Thanks in Advance

Hi, How to create password protected PDF ?? I tried following code but got the Exception as : java.lang.NoClassDefFoundError: org/bouncycastle/asn1/ASN1OctetString JasperReport jr=JasperCompileManager.compileReport("E:\\report1.jrxml"); JasperPrint jp=JasperFillManager.fillReport(jr,new HashMap(),connection); JRPdfExporter exporter = new JRPdfExporter(); exporter.setParameter(JRExporterParameter.JASPER_PRINT, jp); exporter.setParameter(JRExporterParameter.OUTPUT_FILE,new File("E:\\report1.pdf")); exporter.setParameter(JRPdfExporterParameter.OWNER_PASSWORD, "hi"); exporter.setParameter(JRPdfExporterParameter.USER_PASSWORD, "hi"); exporter.setParameter(JRPdfExporterParameter.IS_ENCRYPTED, Boolean.TRUE); exporter.exportReport(); I am using "iText-2.1.0.jar" , "jasperreports-3.6.0.jar" . NOt getting more help from anywhere. Plzz help me. Thanks in Advance

Hi , I am new in Ireport I made one report which have JavaBean Datasource connection now I want to add this report as a subreport into another report which may have different connection . I made that and write conection expression is P!{Report connection} it runs fine but data is not display. Please help me how to solve that problem Please it is urgent for me Thanking You Atmaling