tag:blogger.com,1999:blog-3275211638149890246.post6400267012880945526..comments2024-03-20T13:44:47.908+05:30Comments on Rajendra M. Tambat: creating jasper sub-report using iReportRajendra Tambathttp://www.blogger.com/profile/12940814641424539332noreply@blogger.comBlogger90125tag:blogger.com,1999:blog-3275211638149890246.post-79790062564464505262017-08-14T09:17:41.091+05:302017-08-14T09:17:41.091+05:30technically should be possible actually username p...technically should be possible actually username password is the concern its managed in datasource connection properties and (well i don"t remember now) if jasper now supports multiple datasources then you can have two different datasources created for main report and sub report.<br />my blog is quite old I am not uptodate on jasperreport currently, but you can check this.<br />Rajendra Tambathttps://www.blogger.com/profile/12940814641424539332noreply@blogger.comtag:blogger.com,1999:blog-3275211638149890246.post-65362342043704006542017-08-13T08:18:14.230+05:302017-08-13T08:18:14.230+05:30Hello Sir,
I have one question is it possible tha...Hello Sir,<br /><br />I have one question is it possible that main reports fetching data from one datasource but in different machine and the sub-reports fetching the data from other datasource but username and password are the different?<br />Example:<br />First machine:<br />Database: Oracle<br />Username and password: usr,usr<br />Second machine:<br />database Oracle<br />Username and passwordAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-3275211638149890246.post-66591154242663779072016-07-05T07:48:52.530+05:302016-07-05T07:48:52.530+05:30Hi Ram, it is possible to put condition on your re...Hi Ram, it is possible to put condition on your remaining fields so that they are not displayed which alwayz evaluate false for eg. if(1==0) etcRajendra Tambathttps://www.blogger.com/profile/12940814641424539332noreply@blogger.comtag:blogger.com,1999:blog-3275211638149890246.post-69477139361939192942016-06-25T12:26:07.348+05:302016-06-25T12:26:07.348+05:30Hi Sir,
i have many fields in sub report but i wan...Hi Sir,<br />i have many fields in sub report but i want to display only one field total value only in main report how can i achieve itAnonymoushttps://www.blogger.com/profile/07373835858059512167noreply@blogger.comtag:blogger.com,1999:blog-3275211638149890246.post-54604456956337506802016-06-25T12:22:14.917+05:302016-06-25T12:22:14.917+05:30i no need to display sub report fields in main rep...i no need to display sub report fields in main report.i need only total value from sub report i want to display only total value of the sub report without other fields of the sub report how can i do itAnonymoushttps://www.blogger.com/profile/07373835858059512167noreply@blogger.comtag:blogger.com,1999:blog-3275211638149890246.post-87245832060899629812016-04-13T15:38:02.847+05:302016-04-13T15:38:02.847+05:30Hi Rajendra,
How to create jasper report using tw...Hi Rajendra,<br /><br />How to create jasper report using two csv files.<br />How to create subreport using csv fileAnonymoushttps://www.blogger.com/profile/17470239450274983479noreply@blogger.comtag:blogger.com,1999:blog-3275211638149890246.post-19600080872302350092015-08-12T16:33:01.834+05:302015-08-12T16:33:01.834+05:30Hi Siva,
Are you sure your database query is not r...Hi Siva,<br />Are you sure your database query is not returning duplicate records?<br />please make sure your query has proper results as expected.<br />I don't think it would be possible anything from jasper side.<br />Rajendra Tambathttps://www.blogger.com/profile/12940814641424539332noreply@blogger.comtag:blogger.com,1999:blog-3275211638149890246.post-81101121192567478002015-08-11T12:13:02.120+05:302015-08-11T12:13:02.120+05:30Hi,
I have print product sales report by different...Hi,<br />I have print product sales report by different days<br />product as row data, days as column.<br /><br />problem:<br />some product name display two times (row data).<br />How to avoid it? please guide me..சிவாhttps://www.blogger.com/profile/07614930690016087873noreply@blogger.comtag:blogger.com,1999:blog-3275211638149890246.post-66718176409430383732015-05-23T11:59:59.830+05:302015-05-23T11:59:59.830+05:30enven though you give page break it will not evenl...enven though you give page break it will not evenly cut your page, becauase it varies with your detail band number of rows it generates, unless you are sure you have fixed row format.<br />well but solution would be define your invoice format in sub report and use sub report twice in main report with pagebreak.<br /><br />Rajendra Tambathttps://www.blogger.com/profile/12940814641424539332noreply@blogger.comtag:blogger.com,1999:blog-3275211638149890246.post-1429890902565287612015-05-06T03:04:16.221+05:302015-05-06T03:04:16.221+05:30I want break a4 page into two exactly two part inv...I want break a4 page into two exactly two part invoice bill one as original and one as duplicate plz help me out from thisAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-3275211638149890246.post-14652401790950172122014-09-05T17:22:09.694+05:302014-09-05T17:22:09.694+05:30Hi,
I have made a report for invoice printing.
Pr...Hi,<br />I have made a report for invoice printing.<br /><br />Problem 1: Detail band should extend or should have a fixed height even if it has only one row, it should end just before the group footer where the subreport is kept.<br /><br />Problem 2: Have kept subreport on the group footer and set it's footer position properties to Force at bottom and it's working fine when previewing Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3275211638149890246.post-76161229195711730212014-03-29T17:33:56.833+05:302014-03-29T17:33:56.833+05:30hi
Sir , I have Problem with subreport ---> My...hi<br /> Sir , I have Problem with subreport ---> My requirement is to show Two subreports in the Master Reports as for that i have taken three details band details-1 and details-2 ,detail-3. In detail-1 band , <br /><br />i have some staitc text as a heading of subreport-1 ,in detail-2 i have some paragraph to print and in detail-3 band i have 2nd subreport-2 , But when i am compling it and Anonymoushttps://www.blogger.com/profile/01733048227153539338noreply@blogger.comtag:blogger.com,1999:blog-3275211638149890246.post-58066173559694808002014-01-25T13:43:28.677+05:302014-01-25T13:43:28.677+05:30hi all, has u can see price value is in column wis...hi all, has u can see price value is in column wise , can we display price data in a row wise .kindly guide <br />Farooqhttps://www.blogger.com/profile/13013356373408381783noreply@blogger.comtag:blogger.com,1999:blog-3275211638149890246.post-52872018437190956182013-07-04T13:25:22.102+05:302013-07-04T13:25:22.102+05:30Hi, i would like to print filter data of the subre...Hi, i would like to print filter data of the subreport for each row of main report. when i send a fileld parameter from the main report to the subreport , the main report does not execute at all. please help.Anonymoushttps://www.blogger.com/profile/03374998867039491153noreply@blogger.comtag:blogger.com,1999:blog-3275211638149890246.post-50696095644775879172013-05-07T16:55:29.698+05:302013-05-07T16:55:29.698+05:30Hi Kayal, your procedure looks ok.
does it give a...Hi Kayal, your procedure looks ok. <br />does it give any error on generation? if not means it is not yet defined as return value in your sub report, try to verify same by looking at source code in jrxml in subreport tag for following as shown in my example<br /><br /><br /><br />just once again verify following.<br />-- sub report<br />define variable (myvariable) <br />variable class = string <Rajendra Tambathttps://www.blogger.com/profile/12940814641424539332noreply@blogger.comtag:blogger.com,1999:blog-3275211638149890246.post-30177804280898601592013-05-06T17:03:46.394+05:302013-05-06T17:03:46.394+05:30Hi ,
Thanks for the reply.Kindly find the below de...Hi ,<br />Thanks for the reply.Kindly find the below details<br />Same as you explained I have a variable defined in my subreport- "myvariable" with value 12345 .I assigned the same to my main report variable named "Temp" using the return property .And I have placed my subreport element in detail band and Temp variable in page footer band of my main report.I have tried out kayalhttps://www.blogger.com/profile/04729341443428900333noreply@blogger.comtag:blogger.com,1999:blog-3275211638149890246.post-31601060882550467172013-05-03T19:35:36.789+05:302013-05-03T19:35:36.789+05:30Hi Please read end of my tutorial I have explained...Hi Please read end of my tutorial I have explained how to return value from sub report, but there is pre conditions I place it here --<br />when you have to define a variable that returns a value from sub report note that<br />1. values should come from sub-report variables, and place holder in main report also should be a variable.<br />2. variable defined in main report will get populated only Rajendra Tambathttps://www.blogger.com/profile/12940814641424539332noreply@blogger.comtag:blogger.com,1999:blog-3275211638149890246.post-68713387651994823592013-05-03T14:34:18.426+05:302013-05-03T14:34:18.426+05:30Hi,
I have a Constant value '12345' define...Hi,<br />I have a Constant value '12345' defined for variable "myvariable" in subreport when I try to map to mainreport variable "myvari" it is always returning null tried out various possibilities but nothing helped to solve the issue.Can you help out on this.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3275211638149890246.post-37804121685420130612012-11-28T11:32:10.340+05:302012-11-28T11:32:10.340+05:30jarur,
mala shakya ti madat me karen.
jarur,<br /><br />mala shakya ti madat me karen.<br />Rajendra Tambathttps://www.blogger.com/profile/12940814641424539332noreply@blogger.comtag:blogger.com,1999:blog-3275211638149890246.post-73199409407611184742012-11-28T05:57:08.897+05:302012-11-28T05:57:08.897+05:30तांबे साहेब,
उत्तम लेख. आपल्या मातृ भाषेत मला जास...तांबे साहेब,<br />उत्तम लेख. आपल्या मातृ भाषेत मला जास्पर रिपोर्ट वर लिहिण्याची इच्छा आहे.<br />मी आपली मदत गृहीत धरू का ?<br />Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3275211638149890246.post-44913410121929115992012-10-17T18:40:13.104+05:302012-10-17T18:40:13.104+05:30hi,i'm working on mysql,jasperreports and i wa...hi,i'm working on mysql,jasperreports and i want to do certification in it.do u have any idea about how many types certifications are there and any links for study material.i am fresher and have been working on these for past 4 months.any information regarding this would be help full.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3275211638149890246.post-76386303412913708442012-10-15T17:57:07.511+05:302012-10-15T17:57:07.511+05:30ok...now this process would be big,i have to do it...ok...now this process would be big,i have to do it now...thanks for giving the information...i have been searching for this(to know whether there is a way or not) for 2 days now!!!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3275211638149890246.post-66447384686241115232012-10-15T16:23:32.377+05:302012-10-15T16:23:32.377+05:30Unforutnately not.Unforutnately not.Rajendra Tambathttps://www.blogger.com/profile/12940814641424539332noreply@blogger.comtag:blogger.com,1999:blog-3275211638149890246.post-90355427246417545132012-10-15T15:07:06.487+05:302012-10-15T15:07:06.487+05:30this process is working fine but i have 10 columns...this process is working fine but i have 10 columns in each subreport and there are 7 sub reports,so creating of these many variables is much time consuming and i dont know whether its effective,so is there any other way?<br />thanks for the replyAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-3275211638149890246.post-27584832571988220712012-10-15T13:47:35.391+05:302012-10-15T13:47:35.391+05:30Hi It is possible,
follow below steps
1. create a ...Hi It is possible,<br />follow below steps<br />1. create a variable ret_value_xx in main report<br />2. set evaluation time as band ( so su report should able to pass value correctly)<br />3. define variable in sub report sub_rpt_xx<br />4. in main report again go to subreprot properties<br />5. you will find property return values<br />6. add value there subreport variable= sub_rpt_xx and Rajendra Tambathttps://www.blogger.com/profile/12940814641424539332noreply@blogger.com