csplrj

I can't see the forum link. I can only see the topic heading" :In a HTML Exported Report Line not visible in" and not the details of the message http://jasperforge.org/plugins/espforum/view.php?group_id=102&forumid=103&topicid=42837 Thanks in advance CSJakharia

Software -------------- JasperReport 3.1.0 IReport 3.1.1 MySQL 5.0 Problem -------------- My SQL Query is SELECT sum(quantity*rate) as itemAmount, `item`,`color`, `fabrication`, `finishedItem`, `image`, `overheads`, `print`, `style`,customer,costId FROM (transcostsheet join mastercustomer on transcostsheet.customer_id=mastercustomer.id) left join (transcostsheetItem join transcustomeritemrate on transcostsheetItem.item_itemId=transcustomeritemrate.item_itemId)on transcostsheet.costId=transcostsheetitem.transCostSheet_costId and transcostsheet.customer_id=transcustomeritemrate.customer_id group by color,fabrication,finishedItem,image,overheads,print,style,customer,item HAVING $X{IN, costId, costIds} but it says "Unknown column$X having clause" Thanks in advance CSJakharia

I have logged that bug CSJakharia

When you speak of latest version do you refer to 3.0 or previous one i.e. 2.0.5? As I am using 2.0.5 Thanks in advance CSJakharia

Can you please provide me the download link as i am not able to find the same at this page http://www.jasperforge.org/index.php?option=com_content&task=section&id=16&Itemid=277 Thanks in advance CSJakharia

Sorry actually it was wrong file The current file is attached over here [file name=jasperReport1.jrxml size=13218] Thanks in advance CSJakharia

I just now read about JasperReport 3.0 release but can't find the download link. Can you please provide us the link for the same? Thanks in advance CSJakharia

We are using latest one i.e. JasperReport 2.0.5 (jasperreports-2.0.5.jar) The Jasperreport jrxml is attached [file name=jasperReport.jrxml size=10410] Thanks in advance CSJakharia

I had exported a report page to HTML but the horizontal line drawn in the page can be displayed in Firefox 2.0 but not in IE 6.0 Please see the attached file for having a look Attached File: [file name=index.htm size=26076] Thanks in advance CSJakharia

Try the below post http://www.jasperforge.org/index.php?option=com_joomlaboard&Itemid=&func=view&catid=8&id=31532#31532 Bye for now CSJakharia

Thanks My Problem has been solved I used Edit->Report properties as mentioned by my forum friends Thanks Again CSJakharia

Add Field in Report of type JRBeanCollectionDataSource and add in that Arraylist A, JRBeanCollectionDataSource of Object B and have datasource of subreport as $F{subReportList} Thus your problem should be solved Bye for now Chirag

Thanks for your reply that helped me as I also was facing the same problem. The demo folder is not included in IReport. I am using IReport right from 0.3.1 version till 2 But the demo folder is not included in that distribution.Can you please make appropriate changes in the distribution as this will reduce much of the queries in the forum for users of IReport Please point me if I am downloading the wrong distribution Anyway IReport and Jasperreport is great. Thanks for such a nice product Bye for now CSJakharia

I get this error when I try to open the Report from my Java Application. I know that I have to change the scriptletclass tag in jrxml file What My Query is Is there any method to do the same through IReport Interface? Thanks in advance CSJakharia

I have created 2 reports one is master report and other one is subreport. I am filling up both the reports with the JRDataSource. I have set the datasource expression of the subreport to Code:new JRBeanCollectionDataSource((java.util.List)$F{subReportHashMap}.get($P{Detail}.intValue()==1?"P":"A"«»)) But when I try to run the report it throws Code:[code]classcastException:net.sf.jasperreports.engine.data.JRBeanCollectionDataSource and after some errors Code:[code]net.sf.jasperreports.engine.fill.JRExpressionEvalException:Error Evaluating Expression: Thanks in advance CSJakharia