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