aezaz123

Hi All, Can any one let me know how to extract only month part from date column of my source database table in jasperETL. Please if any scenario based explanation will help us a lot. Looking forward for your reply Thanks in Advance Aezaz

Hi All, I have created some dimension using using 'tMap' transform but i am looking for creating fact table for my dimension. Can any one help me and let me know how to build fact table in jasperetl, any documents on same will help me a lot. Please help Looking forward for your reply... Thanks in Advance Aezaz

Hi Matt, Thanks for quick reply. I am using "ReportExecution" hyperlink type in my report. Is there any other way to do drill report in jasper?. i am passing parameter using this "ReportExecution" hyperlink type. Please let me know how can i pass two parameter in one click Thanks Aezaz

Hi All, I have a issue in passing parameters in jasper server, i have a jrxml file in which i need to pass to parameters "year" and "region" in one button click but here in jasper server when we click on any chart it will pass one parameter and prompt for other parameter to enter manually, can any one let me know is it possible to pass more then one parameter on one button click. Looking for reply Thanks Aezaz

Hi All, I am working on drill down reports in jasper, as i understood you all discussing in this topic is hyper linking of report and passing parameter to next report on one button click. Please correct me if i am wrong. I tried with one parameter passing from one report to other report on button click in jasper server and its working fine. But i have a requirement where i need to pass two three parameter at-a-time on one button click, the parameters are Region, Start date and End date. But when i click on my chart to pass this parameter it will take only one parameter Region and for other two parameter it is asking parameter to enter manually. Can anyone let me know how i can pass more than parameter in jasper server in one button click? Looking forward for your reply Thanks in Advance Aezaz

Hi, Thanks for your quick reply.. I am still not clear can you please explain me bit more on this, if you have any example or any jrxml file for this topic kidly share. looking forward for your reply Thanks once again Aezaz

Hi jorge, Did you got a solution for post report using Web Services instead of sql queries, even i have same type of requirement so if you can help me out it will be great. Looking forward for you reply thanks Aezza

Hi All, I have a small query on Ireport, i am using jaspersoft Ireport Community edition. Need to know is there any option in Ireport to connect to more then one databases at a time to fetch one single report. Snap shot is attached for ref Please help and let me know it is possible in ireport or not Thanks Aezaz

Hi Experts, I hope I am putting this question in right place, Can any one share IReport ultimate guide PDF formats or any other documents which helps in learning Ireport. I am trying on my own but really need some good documents so please share if possible. Thanks in advance Aezaz

Hi All As we were exploring Jasper ETL tool, we came accross following error for one of my flow can any one have any idea on this, please share your tips. Exception in component tFileExist_1 java.lang.NullPointerException at test.connectwebservice_0_1.ConnectWebService.tFileExist_1Process(ConnectWebService.java:270) at test.connectwebservice_0_1.ConnectWebService.runJobInTOS(ConnectWebService.java:1044) at test.connectwebservice_0_1.ConnectWebService.main(ConnectWebService.java:937)[statistics] connecting to socket on port 4325[statistics] connected[statistics] disconnectedJob ConnectWebService ended at 17:49 24/12/2010. [exit code=1] ThanksAezaz

Hi Carl, I need some clarification on drill down in jasper soft, as per my knowledge the thing we discussed in this topic is hyper linking the reports and passing parameter through url. But drill is a feature of BI tool where drill report and drill down report is one single report template only parameter is to be change, suppose like if i have a report displayed data based on region and when i click on region it has to show data based on state wise but all in same report this is drill as per my knowledge. Correct me if i am wrong. Please let me know is it possible the second type of drill which I explain above is possible in jasper soft ireport. Looking forward for your reply Thanks Aezaz Ahmed

Hi All, Sorry i am jumping into discussion in between, but issue is also look's similar so if any one can help I will greatly appreciate. We have developed a dash board which we want to drill down functionality in web page. We have used JSP code for that which we got from one of Jasper blog. But code is compiling fine but when we tried to run the code its giving blank page with image alignment in web page. We have followed steps given in following link. It’s really looking good in blog. i think we have missed out some thing some where. Can any one please tell us where we are going wrong? http://nukalamadhu.wordpress.com/2010/03/15/jasper-reports-drill-down-facility-inside-a-web-application/ I have attached my jsp code and jasper files for your ref which i am using. Thanks in Advance Aezaz Ahmed

Hi All, I have just started with jasper soft ETL tool and saw demo project for ETL process in jasper. I have still lot of confusion in that so if any one of you have any demo projects with dataset for that please share with me it will be great help. looking forward for your reply Thanks and Regards Aezaz Ahmed

Hi All, I have just started with jasper soft ETL tool and saw demo project for ETL process in jasper. I have still lot of confusion in that so if any one of you have any demo projects with dataset for that please share with me it will be great help. looking forward for your reply Thanks and Regards Aezaz Ahmed

Carl, You said in your reply that " I added the input controls and ran it again, and the links correctly passed the appropriate parameters to Drill2." i didn't get you where exactly you have added input controls and how please explain me, it might be simple but i am confused kindly clear my confusion. Thanks Aezaz

Hi Giulio, I saw this iReport Video Podcast, it is very nice. Is there ant video for Drill down functionality in IReport, if there is a video please share the like or video. i am looking for drill down function in Ireport. looking forward for reply Thanks Aezaz

Hi Carl, I tried your tips but still its not drilling down. I am not sure the reason, i have attached my master and details jrxml files for your ref. please have a look on it and let me know am i right. If possible please share any working drill down master and details jrxml files. Looking forward for you reply Thanks Aezaz

Hi Carl, Thanks for your quick reply... I tried your tips but in preview i am just able to see hyper link mark but its not drilling down. I will explain my report please correct me if i am wrong. I have developed a report called Detail_Report with will display "Product" and "Revenue" month wise. also i have created one parameter here called $P{year} when i preview it, gives me report output. Now i Developed one more report called Master_Report. here i am displaying "Product" and "Revenue" "Year" wise. here also i have created one parameter again $P{year}. I kept both the reports on my desktop in JRXML format. Now i followed step explained by you i.e right click on parameter $P{year} in Master_Report and selected hyperlink then in dialog box selected "Self" in Hyperlink target and "ReportExceution" in Hyperlink type. Now in Link parameters tab i Added two parameter one is _report with report name "Detail_Report" in Expression (also in place of report name i gave full path i.e C:/.../.../report name but its not working) then i added one more parameter year. I have attached Hyper link dialog box for my master_report for your ref. When i see preview i am able to see only hyper line mark(hand mark) on "year" but its not drilling down. Can you please let me know that am i doing any thing wrong, is there any thing else to add. Please its very urgent.. hope you will help me Thanks once again Aezaz Ahmed

Hi All, I am new to jasper soft, i am struck in drill down report. I saw this discussion on drill down. Can any one please explain me how to do drill down in jasper soft IReport. Its very urgent kindly please help me.. Thanks in Advance Aezaz Ahmed

Code:Hi, I saw you discussion in this error in server. Even i am facing this problem. I have some jrxml files created from ireport in some other machine. i tried to publish thous report to server which we are keeping in different machine. when i publish report from client machine it is not showu=ing any error. But when i tried to open published report through server i am getting this below error "com.jaspersoft.jasperserver.api.JSException: jsexception.error.creating.connection" for details i have attached snap of that error I am new to jasper plz any one let me know how to resove this error. i tried solution give in your discussion but it is not working yet. One more thing if i tried to open server report published from server in client its opening fine but if i publish from client to server i am facing this problem. Please its very urgent.. looking forward for any one's reply Thanks in Advance Aezaz Ahmed

Hi All, I am trying to develope a tabular report in jasper IReport componenet but there is no any option to build table report, i used rectangle box from tool peallet to do so. i just want to check is there any other option to put table in IReport please let me know. Thanks Aezaz

Hi All, I am totaly new to jasper soft and desperatly need some clearification. Is it possible to make client server model in jasper soft. Eg: One jasper server in one machine and many IReport as client in other machine. I am realy struggling to do this. Please if any one can help me i greatly apreciate. any document on same will be greate help. looking forward for reply.. Thanks in Advance Aezaz