[one sheet per subreport]

Hi,

I have a requirement to design a report with one sheet per subreport, when i export a report to excel format.

Is it possible?

 

[Calling oracle stored procedure in iReport 3.6.2]

Hi,

 

Can anyone tell whether oracle stored procs are supported in new ireport directly?

If yes,How shoud i call stored procedure in this new ireport version?and how should i use plsql option for ireport?

I am attaching one simple proc..Can you help me in calling this proc in ireport directly?

 

[Subreports or Subdataset beneficial?]

I have a J2EE application  which is using JasperReports API for Reports.

My reports are having around 80 Subreports.If I use subdatasets for some of the subreports...i.e if i reduce my subreports to 60 and i use 20 subdatasets...Will it improve performance of my application?

 

[Advantage of JasperServer portlet in portal]

Hi,

Can anyone explain the scenario and pros-cons of deploying jasperserver portlet over embedding jasperserver in liferay or any portal?

 

[Cascading Input Controls for JasperServer 3.5]

I am able to use this patch succesfully.

I would like to select multiple values for first parameter and pass the same values(more than one) to next parameter.

Is it possible using this patch?

I tried using Multiple select query option,whuile configuring input control;but got foll error.

Unknown parameter type java.lang.String for multiple value input

Has anyone implemented this functionality in jasperserver?

[Porcedures in Adhoc Report]

How can i call procedures in JasperSoft?Is it feasible?Its urgent!!

[JasperReports in Dot net application]

Is it possible to call JasperReports in Dot net application?

[Color coding in Charts with Analysis View]

When i create a Analysis View and i click show chart option.I am not able to se any option which will define any series color and we can conditionally change the series colort.I am trying to serach for a functionaly which is their in meter chart...Is there same option with pie chart or bar chart?

[Alerters in Reports]

Do we have alerter functionality in jasperser and/or Jaspersoft?If yes,how to implement it?

[Bug in iReport while sorting?]

I have xml as a datasource,

1.I am having one grouping in my report and my grouping field has values like 1,01,2,2,02,1,01,....

So I am grouping by this field and in sort option i m setting this field to get sorted on the field and it gives proper output.

2.In my report header i have to include one subreport since i want to print one iterated value in Report header band(adding virtual detail band by adding a subreport with detail band only in report header band)

Due to my report requirement I have to use a sort option and subreport,but when i run the main report ,it shows the error

"Error filling print :Error Evalauting expression

Source text:((net.sf.jasperreports.engine.data.JRXmlDataSource)
    $P{REPORT_DATA_SOURCE}).dataSource("/node/dummyxpath")"

When i run the same report by removing a fied in sort option it gives output...but when i have sorting and subreport it gives above error..

Please guide me...

[Can't run report from Jasper Server repository]

There may be two possible reasons for this error.

1.Reports which you are uploading from iReport to jasperserver,both of them should use same Jasperreports library.Please make sure you are using ireport3.5.0 and Jasperserver 3.5

2.While adding a report from ireport to jasperserver,you may be importing database connection from ireport,so please make sure datasource has proper connection defined...like there should not be localhost for database server.

Please notify us if these solves your problem.

[Restrict Number of Lines In Page]

You can try keeping subreports aligned adjacent to each other from left to right and maximizing main reports width and minimizing main report's page height...

[Restrict Number of Lines In Page]

You can set page height option in report properties to  optimum and check the output

[Sorting fields using xpath expression]

Actually my field is treating field having value '1' and '01' as different value and thus when i group on this it is not giving the desired ouptput..

[Multiple Data Sources in One Report]

Reason for "documents has no pages" is,when you run ur master report ,you need to select Master Reports data connection.

And if ur subreport uses the same database connection then it should be use same  connection expression(while configuring subreport) else it should use the expression written in previous post.

[Sorting fields using xpath expression]

How should i sort a field using xpath expression?

[Grouping performed on a field (which is not clean)]

I have solved this problem,by using a number() function of xpath(i.e i converted numeric field to integer value) and gruped on that.It is working fine.

But when i sort on one of the field and use other subreport .It is giving error that it can't evaluate data source expression..

[Issue when i use subreport]

I am using XML as a source.When i sort on one of the feilds and use subreport.

iReport is giving me error

"Error filling print... Error evaluating expression :      Source text : ((net.sf.jasperreports.engine.data.JRXmlDataSource)     $P{REPORT_DATA_SOURCE}).dataSource("/node")"

 

Please tell me is it a defect of iReport or something else?

[Grouping performed on a field (which is not clean)]

I am having XML as a source,so all the fields are string by default.Now,I am supposed to do a grouping on a field which is having values like(1,2,01,2,3,3,1,01,02,2,)(ideally data should be clean).But I can't modify the source,so when i group the records in this field it is treating 1 and 01 as a different value,and so i am not able to acheive desire value.

Can anyone suggest any work around for solving this issue?I have already tried changing field expression that checks whether 1st digit is 0 or not and gives the unique output like (1,2,3...),but when i group by this modified expression it is not giving correct output....

Please try solving this issue..

[Report level sorting on fields]

Thanks for your reply..But i have one issue,since i  have a source as a XML file,all the fields are string.So when i try to sort a field (which is string) which holds numeric value,it is not giving the correct sorted output.How should i solve this issue.Please help me if you can.

[Report level sorting on fields]

I want to sort a certain field,which is dragged in detail band.How should i achieve this?

[Multiple Data Sources in One Report]

One of the ways for accessing multiple databses is to add a subreport using connection expression as

java.sql.DriverManager.getConnection("jdbc:mysql://hostname:3306/dbname","user","password")

and passing the subreport parameter on which their is a link between two databses.

 

I would like to know if someone else has other solution.I would like to select multiple datasource in the one report itself rather than adding a new subreport..

[Internationalisation help required]

I am able to do intenationalisation by creating propeties file for corresponding locale..It is working fine....

I have one question..can we create dynamic translation of the resource which we are defining in properties file instead of defining for each language?

[Internationalisation help required]

Thanks for your detailed discussion about how internationalisation works.

I needed some more help on this.

1.I changed locale execution tab to spanish ,but still it gives the output in default language.Is this only step solve my issue?

2.If i want to pass value to REPORT_LOCALE variable(which is in built) for spanish tag,how and what value should i pass?

 

[Internationalisation help required]

I have a report which is running properly.Can anyone please help me how to use REPORT_RESOURCE_BUNDLE parameter to print the same report in Spanish lang and English at any point of time?