ramandeep1980

Can anyone clarify

Hi , Is it possible to use Jasper for Report generatin in AFP format? If Yes, Is trial version availabl for POC. Regards, Raman Deep Singh

Hi, Can you please provide me with the link for download of BI Enterprise Edition-5.1.0, The one present below is for - BI Enterprise Edition-6.1.0 www.jaspersoft.com/download-jaspersoft-bi-software Kindly Help. Regards, Raman

Hi, I am bit novice in Java, though have worked extensively in BI, Reporting,Datawarehousing and ETL. I would need bit of help in embedding of Jasper Reports/Charts/Dashboard in my Already running application.We are using WASCE(Websphere) Server. Can you please guide how can we call Jasper Reports to our server and how can we pass parameters adn all to it . Thanks and Regards, Raman

Any response guys. Please help me in figuring out this one. Regards, Raman

Hi Everyone,I am trying to remove column from excel after hiding it with printwhenexpression.With print when expression column is not showing up but is hidding in report.Please suggest me how to remove it.Please view attached image to understand my problem in better way.Regards,Raman

Hi , I would need help in deciding which jasper product should i use. I am already using Jasper iReport for a while for reports in my applications.Now moving forward i am trying to create a reporting system where user can themselves drag and drop columns and create their own report. Can you pleae guide me in this. Regards, Raman Deep Singh

Done that too Thomas. That was a wrioting error. Still I am not able to read XML elements though XML attributes can be read easily. Can anyone reply to this. Regards, Raman

Hi Everyone, I am able to read XML attributes from XML file but not able to read XML elements. In below example,I am able to read comment , entered,center etc by giving xPath till Event tag and giving description of fields as @comment, @entered and @center etc but not able to read aReason by giving xPath till Reasons tag and using @aReason as a field decription, the reason i understand is that comment, entered etc are atrribute of XML where as aReason are XML elements. <Event comment="Coll" entered="Se" Center="ET" appro="1" age="3" <Reasons> <aReason>Missing</aReason> <aReason>Missing1</aReason> <aReason>Missing2/aReason> </Reasons> </Event> Can you please tell me wat xPath and wat field description i need to use to read aReason , XML elements. Regards, Raman

Hi, I am having some major trouble in changing Date format in ireport. I am geting data from XML datasource as- 2013-02-13T22:07:37.589-05:00 and I want to change it to this 30-Feb-13 10:07 PM EST. But some how jasper is not able to understand the incoming format from XML. Regards, Raman Deep Singh

Just thought to bring it up .As this is very important and urgent for me Regards, Raman

It is possible in Pie Chart. What you will need would be 2 pie charts one for Paul and another Peter

Hi, I need an urgent help regarding Configuration Referenes. I need to control page header of a subreport depending upon the ouput is XL or PDF. Though these setting works perfectly fine when i do setting in Report , as follows:- net.sf.jasperreports.export.csv.exclude.origin.band.1 pageHeader net.sf.jasperreports.export.xls.exclude.origin.band.1 pageHeader BUT does not work appropiately when i use them in subreport.When im putting them in subreport and call it in Main Report , the pageheader loose the control and start repeatig in Excel. Kindly help. Regards, Raman Deep Singh Post Edited by ramandeep1980 at 10/20/2010 20:07

Hi Lucian, Thank you for replying. I added it to the Report properties in report's JRXML. and it worked fine Regards, Raman Deep Singh

Hi Lucian, Thank you for replying. I was able to solve it.Solution was not very appealing. I just deleted the header field containing the parameter and re created it and my problem got solved. But it is weired that everything works fine till there is no field in the Header containing parameter And when u add parameter to the header Just delete and recreate it. Regards, Raman

For further information. I am using:- iReport :- 3.7 Professional version Jasper Server:- 3.7 Professional edition Hope this would help. Regards, Raman Deep Singh

Hi, I am using following property of Jasper to print Page header only once in the Excel. "net.sf.jasperreports.export.xls.exclude.origin.keep.first.band.1" Value :- pageHeader Thus even though Page header is repeating n every page in PDF it is not repeating in Excel. BUT When I put Field or Parameter in header (for example:- if i want Date to be a column heading) they repeat twice instead of once for whole report in Excel and behave normally or in expected manner in PDF. This is weired tht they get repeated twice for whole report does not matter how long the report is. Though they shud only get printed once when taking print out on Excel.Kindly help Regards, Raman Deep Singh

Hi Kristen, I checkd up and yes u were right.Some one did mess up/made changes in WEB-INF/calendar.properties Thanks for helping out. Regards, Raman Deep Singh

Hi, How can we use jasper properties mentioned in below mentoned page for setting up the Jasper properties http://jasperreports.sourceforge.net/config.reference.html#net.sf.jasperreports.export.xls.max.rows.per.sheet Do we need to use it put this in just report or for each column. For exampl:- For this property net.sf.jasperreports.export.html.remove.emtpy.space.between.rows How we supose to use this property to remove spaces. Do we need to put this property in all just a report or we have to put it fro all fields so that they do not have vacant space. Regards, Raman Deep Singh Regards, Raman Deep Singh

Hi, How can we use jasper properties mentioned in below mentoned page for setting up the Jasper properties http://jasperreports.sourceforge.net/config.reference.html#net.sf.jasperreports.export.xls.max.rows.per.sheet Regards, Raman Deep Singh

Oh..I was not aware of this fact about you being with Jasper Soft. Thank you for replying... I will contact the Jasper Soft' support Team to help me fix this bug. Regards, Raman Deep Singh

Hi Ramnik, Thank you for replying. It would be nice if this can be confirmed by some Jasper Soft official. Regards, Raman Deep Singh

Hi Kristen, I do not think any change has been made in WEB-INF/calendar.properties . Secondly, Other than what i have written in my first message (I am not able to use Date Picker for selecting the date parameter. Report gets hung AND When we do it my manually writting the date and Click OK then report does not respond.) What i mean by GIVES TROUBLE is :- that lately it does not respond at all.so it more like just an image. Regards, Raman deep Singh

Hi Kristen, This is problem for all reports i have checked till now on Professional 3.7 Edition. Yes I have tried this on sample reports also and the Date picker is not working there also. As i said UI is same as Jasper Server.It is working in English. Regards, Raman Deep Singh

Hi,We are facing a major trouble in regard to refreshing of cascaded or dependent parameter.That also using the username as one of the parameters. We have got 2 parameter of Single Select(X) and Multi-select(Y) type respectively.Till the time we do not change/Update the values existing for Y in the back end everything goes fine. But the moment we change the existing value of Y showing for particular value of X and LoggedInUserName (LoggedInUserName has default value as $P{LoggedInUser}.getUsername() ) things get hay-wired Y has query in following format :-WHERE column_1 = $P{X}And column_user_id = $P{LoggedInUserName} Now when we run the report,it still keeps on showing the previous values, the one which exist before Updating the Table’s column and only changes it after we click on the OK button after making few available selection from the parameter Y for that user. So basically it seems that even though we have changed the existing value of column for Y, for particular value of X and username it still gets saved in Jasper server some where and only gets refreshed after making few selections.Moreover this seems to be very much user specific.Thus it seems list of parameters for user gets saved somewhere in Server. This actually effects the dynamic behavior of the parameter. Query for X:-Select column_a from Table1 Query for Y:-Select column_b from Table2WHERE column_1 = $P{X}And column_user_id = $P{LoggedInUserName} Jasper Server Version:- Professional 3.7 Kindly advise on the same.Regards,Raman Deep Singh