AnnMary.Thomas

Hi @rohitahuja, Yes I was able to. Please find the answer in the below link posted by me

Please find the answer in the below link http://community.jaspersoft.com/questions/844705/how-attach-pdf-file-generated-jasper-report

This is how I did in Java. Hope this helps ByteArrayInputStream bs = new ByteArrayInputStream(output.toByteArray()); // output refers to your Jasper report Document document = new Document(); PdfCopy copy = new PdfCopy(document, output); document.open(); PdfReader jasperReader; //Reader for Jasper Report PdfReader nonJasperReader; // Reader for the Pdf to be attached (not .jasper file) jasperReader= new PdfReader(bs); attachmentReader = new PdfReader(params.get("att").toString()); numberOfPages = jasperReader.getNumberOfPages(); for (int page = 0; page < numberOfPages;) { copy.addPage(copy.getImportedPage(jasperReader, ++page)); } numberOfPages = nonJasperReader.getNumberOfPages(); for (int page = 0; page < numberOfPages;) { copy.addPage(copy.getImportedPage(nonJasperReader, ++page)); } copy.freeReader(jasperReader); jasperReader.close(); document.close(); }

I have a frame with say 10 elements in it. The fram is at the bottom of the page. And this page is called as a subreport from a main page. On the report this fram is extended to 2 nd page. even though there are no contents displayed in the 2 nd page. That is the the frame which began on the bottom of the first page is extendd to the second page for no reason. How can i avoid this Jasper soft studio version - 5.6

Did you add the .ttf (font files) files to your application. Please check the below link http://www.codesuggestions.com/java/jasper-reports/adding-custom-fonts-to-jasper-reports/

Check the type of the fileds in your report. Say if your query is Select filed1,filed2 from table1 where field1 and field2 are of type boolean. Then the corresponding fileds in your report where you are dispaying or using in some calculation for other fileds, the type should be same

That is because your detail Split type is set to Prevent. Try to set it stretch or null ** Pls use Add comment if you are replying to an answer other wise this will not be intimated to the person who answered and cannot give you further answers **

Did you add the ojdbc jar to the DRIVER class path. In the dialog where you define the connection settings there you should find a tab to set the driver class path. Add the ojdbc jar there. This should solve your problem

select fieldName from tableName where $X{IN,field2,parameter1} where parameter1 is your List parameter, filed2 is the one for which you need to search in table. ex: select empname from empTable where $X{IN,empId,paramselectedEmpIds}. this is equivalent to select empname from empTable where empId in (100,101,102)

Try giving Print When Expression for Break element. Add the break element. Set the property Print When Expression to your specific condition

So when you are putting this sub report on detail band, set the detail band's split type property to "Prevent". This would stop the split happening for the first time. If this helps please mark as answer or reply and we will look for other possibilities

Is your header define as a subreport which your are calling from main report. Then say the subreport only has header?. Then the height of subreport header should be the same what you specify in main report

Thank you TigerMan. Glad to know that my answer helped you. Can you please check the point as answer so that it would help others also :)

Thank You :)

Please vote for my answer if it has helped you :). And also please use 'add Comment' for replying, otherwise whoever answers will not get notification for reply

I had a similar case. The query I have specified in the same way as you have specified. But the Parameter i have specified in the following way. Parameter Name=parameter1 Class=java.util.Collection Default Value Expression=java.util.Arrays.asList($P{REPORT_PARAMETERS_MAP}.get( "parameter1" ))

The scenario what I understod is th output should be like Col1Col2Title 1Title2Val1 val2 . . . Val1 Val2 . . . Wy dont u place the Column name and tilte in Column header band. And in the detail band place List with Vertical Print.

Check the height of the subreport (total of all the band heights in subreport). have you specified the same height in the main report for the subreport

Thank you Rohit. This is new to me. Thanks for sharing

what is the query that you a re using for this..?

I still feel, you need to define only one Style say mainStyle and 50 conditions to this and in condition 1 you will have to write paramList.contains(field1). now set the bg color for that. then add Condition 2 and write paramList.contains(field2), set bg color for that and so on. Now in all the fields in the report set style as mainStyle. If my answer as helped you please vote :)

Can I know why this was voted down? This is a solution which is working and which Im using for one report.

do you have a field in the jasper file with name exactly as EMP_BANK_AC.(not like empBANkAC)

Please mention the type of the parameter and what are you using that for. For ex: is the parameter a String whichh holds the SQL or is it a parameter to the subreport query or it is just used to display in the subreport

If your data is coming from query can you modify your query like this To_Char(start_date,'dd.MM.yyyy') || ' - ' START_DATE , To_CHAR(end_date,'dd.MM.yyyy') END_DATE Here "-" this is appended to the Start _DATE