drallpradeep

" + new SimpleDateFormat("dd-MMMMM-yy").format(new SimpleDateFormat("MM/dd/yyyy").parse($P{fdate}))+

Dear Sir, //Where is this combobox? combo box on jsp page where we select a value and pass the id to jasper report. // Where is the query executed? query executed in jasper report. // What does it have to do with JasperReports? Is this about JasperServer? jasper report 2.0.5 my question is, If i do not pass a value in parameter (i.e. 'directoreate' paramter) then display all records and If I pass specific parameter id then display only specific id record. presently if I mention parameter like E.EMP_V_directorateid Like '%' || $P{directorate} and do not pass a parameter value , then display all values of directorate table. But problem is that If I pass a parameter value like '4' then its dispaly all r ecords related to E.EMP_V_directorateid '4'. Secondly, if I mention parameter like E.EMP_V_directorateid = $P{directorate} and pass a parameter value like '4' then it will display all records of id = '4' but I can not call all the records of directorate table. How to display all the records of a particular table or specific records in a single parameter? I hope, now you can understand my problem and provide me some solution. Thanks & regards, Pradeep

Hi, I would like to display a message in all page footer except last page? I mentioned in print when expression under page footer like new Boolean($V{PAGE_COUNT}.intValue() > 1) , but it is not working. Please suggest. how to count max page? Regards, Pradeep

value can not display on last page only but display on rest page in page footer. Mention this line in page footer band under print when expression, total count page – 1. new Boolean($V{PAGE_COUNT}.intValue() > 1)

hi, how to check two conditions with OR (||) operator in print when expression. 1. new Boolean(!$F{LVE_D_UPDATEDON}.equals("null")) - it is working fine 2. new Boolean(!$F{LVE_D_UPDATEDON}.equals($F{LVE_D_APPLIEDON})) - it is working fine but when I use both conditions in a single command to help of (|| - or) in print when expression, it will not work. Actually condition is that either 'LVE_D_UPDATEDON' field is blank or LVE_D_UPDATEDON date is equal to LVE_D_APPLIEDON date field then message can not print. 3. new Boolean (!$F{LVE_D_UPDATEDON}.equals("null")) || new Boolean(!$F{LVE_D_UPDATEDON}.equals($F{LVE_D_APPLIEDON})) - it is not working. Regards, Pradeep

hi, how to check two conditions with OR (||) operator in print when expression. 1. new Boolean(!$F{LVE_D_UPDATEDON}.equals("null")) - it is working fine 2. new Boolean(!$F{LVE_D_UPDATEDON}.equals($F{LVE_D_APPLIEDON})) - it is working fine but when I use both conditions in a single command to help of (|| - or) in print when expression, it will not work. Actually condition is that either 'LVE_D_UPDATEDON' field is blank or LVE_D_UPDATEDON date is equal to LVE_D_APPLIEDON date field then message can not print. 3. new Boolean (!$F{LVE_D_UPDATEDON}.equals("null")) || new Boolean(!$F{LVE_D_UPDATEDON}.equals($F{LVE_D_APPLIEDON})) - it is not working. Regards, Pradeep

Hi, I have a combo value which is search by id. if I mention as E.EMP_V_directorateid Like '%' || $P{directorate} of parameterized search by (i.e. 4) then its display all the related id records like 4,14,40,41,400 etc. which is wrong and If I mention parameter as E.EMP_V_directorateid = $P{directorate} then it will display only id=4 record. Is it possible, If i do not mention id then display all record and If I pass specific parameter id then display only specific id record in a single parameter. Can we take the advantage of 'like' and '=' in single way? Regards, Pradeep

$X{IN, colName, paramName}

Can we change the type of text from lower case to upper case automatically by jasper. I mean, if we pass value in any case lower, running etc. It will automatically convert the case and display value only in UPPER CASE or ALL CAPS(like Ms-word under font). Regards, Pradeep

I have open my reports in .rtf format, but I need to open reports in Ms-word format. I am not unable to get all features of Ms-word in rtf. Please suggest how to open the report in Ms-word format. Regards, Pradeep

I gone through the demo folder example but I could not understand. Can you provide me an example of orientation for two different page. Regards, Pradeep

Dear Lucian, Can you provide me an example, if possible. I tried your suggestion, but could not get the output. Regards, Pradeep

I also tried in custom format but its display in million format. Please reply.

Please reply.

How can we get more than page. Can you forward me an example? Please reply.