nikunj321

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?

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?

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?

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

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?

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

Is it possible to call JasperReports in Dot net application?

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?

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

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...

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.

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...

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

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..

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.

How should i sort a field using xpath expression?

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..

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?

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..

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.

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

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..

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?

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?

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?