[Draw Stacked Bar Chart]

On 2/15/2019 at 7:26 PM, akovach said:

Hi you can do this with stacked column chart of HTML5 Charts component. Check the report in attachment

HI,

Can you tell, where is the attachment?

[Hide 1st Group Header band on Every Page]

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

[how do i supress band in ireport?!]

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

 

[Customize JasperServer repository view]

Still didn't find any solution

[Customize JasperServer repository view]

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 ?

 

[Customize JasperServer repository view]

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.

[Customize JasperServer repository view]

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

 

[JasperMobile giving error 404 for Android]

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.

 

 

[Hide Details contained in a band when print when expression]

Can you show your PrintWhen expression ?

[JasperMobile giving error 404 for Android]

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.

[Problem to access JasperServer repository from iReport]

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

[One time display of Crosstab headers in Excel/CSV]

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 ?

[Calculations by group and by field content]

hi,

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

[One time display of Crosstab headers in Excel/CSV]

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

[Sum of previous 2 rows]

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

[Masking text field (Displaying * when overflows)]

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.

 

 

[Logical operator ! not working]

It worked as below:

new Boolean(!($P{NO_DATA}.booleanValue()))

[Logical operator ! not working]

It worked as below:

new Boolean(!($P{NO_DATA}.booleanValue()))

[Logical operator ! not working]

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

 

[Logical operator ! not working]

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

 

[Problem: - password protected PDF]

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();

[Password protected PDF]

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();

[Problem: - password protected PDF]

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

1. iText-2.1.0.jar
2. jasperreports-3.6.0.jar
3. commons-beanutils.jar
4. commons-collections.jar
5. commons-digester.jar
6. commons-digester-1.7.jar
7. commons-logging.jar
8. groovy-all-1.5.5.jar
9. ojdbc14.jar

Not getting more help from anywhere. Plzz help me.

Thanks in Advance

[Password protected PDF]

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

 

 

 

[how to add Javabean set datasource as subreport]

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