[Report in AFP Format from Jasper]

Can anyone clarify

[Report in AFP Format from Jasper]

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

[Download of BI Enterprise Edition-5.1.0]

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

 

 

[Embedding of Jasper Report/Dashboard into my Application]

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

[Hidden Column in Excel not getting removed, even when I am hiding it with printwhenexpression]

Any response guys.

Please help me in figuring out this one.

Regards,

Raman

[Hidden Column in Excel not getting removed, even when I am hiding it with printwhenexpression]

 

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

 

[Relevant Product for user Report building]

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

[How to read XML Element from XML File]

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

[How to read XML Element from XML File]

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

[Date Format Change using XML Datasource]

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

 

[Configuration References in Subreport]

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

Regards,

Raman

[Another Pie chart question]

It is possible in Pie Chart.

What you will need would be 2 pie charts

one for Paul and another Peter

[Configuration References in Subreport]

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

[How to use Jasper Properties-Configuration]

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

[Field/Parameter in Header is repeating]

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

[Field/Parameter in Header is repeating]

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

[Field/Parameter in Header is repeating]

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

 

[Jasper Professional-Date Picker Not working]

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

[How to use Jasper Properties-Configuration]

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

 

[How to use Jasper Properties-Configuration]

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

 

[Problem With Cascadin Parameter also using usernam]

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

[Problem With Cascadin Parameter also using usernam]

Hi Ramnik,

Thank you for replying.

It would be nice if this can be confirmed by some Jasper Soft official.

 

Regards,

Raman Deep Singh

 

[Jasper Professional-Date Picker Not working]

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

[Jasper Professional-Date Picker Not working]

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

[Problem With Cascadin Parameter also using usernam]

 

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 Table2

WHERE 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