Generating PDF/HTML/CSV/XML Report in ADF :
"You can clone source code from git hub and below is address "
"https://github.com/prateekazam/ReportApp2/"
In my last past i have explained how to generate report into PDF format.But that component is not able to generate report in HTML/CSV/XML.(Limitation )
Hence in this post i have tried to resolved all the problem which last version has. Using this you can generate report following new format .
1-XML
2-CSV
3-HTML
Declarative Component Specification(ReportDeclarative ) :
Tag-Lib Name :reportDeclarative
Tag-Lib-URL: http://www.adfwithejb.blogspot.com
Tag-Lib-Prefix :report
Component Name :ReportDeclarative
*All i have changed the Tag-Lib information .
Following Feature added in this version which were not presented in last version .
1-Exception handling is implemented
2-Pagination is implemented
3-Serial Number
4-XML Report Support
5-HTML Report Support
6-CSV Support
7-Region Support
You can use this component in Region as well .
Since only pdf report require itext API so do not forget to add itext jar file in project which is present at following link.
http://www.4shared.com/file/a8rSo6rk/itextpdf-510.html
Download component jar at following line :
https://docs.google.com/file/d/0B8cP4jZuxLlXbWs2TjNwZzFvdGM/edit
(This time i have been uploaded file in google document )
* I have already mentioned in my last how to add declarative component jar in the project.
I tested this with multiple scenario and it is working for me.Please let me know if you will get any type of exception or error.
PDF Report:
*You can generate pagination
*You can add serial number and you can change serial column header by default will S.No.
CSV Report :
*CSV file contains comma separate value.
*So if you are using Open office then you have to check separate by comm .
*Pagination is not applicable
*You can add serial number and also you can change the default serial column header value.
*It is same as note file hence Header will not come as bold .
HTML Report :
*You can add serial number and also you can change the default serial column header value.
*Pagination is not applicable
XML Report :
*Column name will come as opening tag and closing tag.
*You need to provide parent tag of the column in Raw Tag attribute of the declarative component
*All the parent tag should also have parent therefore you also need to provide parent tag value in Parent Tag attribute of the declarative component.
*No pagination will work .
Any comment will appreciated .
Thanks
Prateek
"You can clone source code from git hub and below is address "
"https://github.com/prateekazam/ReportApp2/"
In my last past i have explained how to generate report into PDF format.But that component is not able to generate report in HTML/CSV/XML.(Limitation )
Hence in this post i have tried to resolved all the problem which last version has. Using this you can generate report following new format .
1-XML
2-CSV
3-HTML
Declarative Component Specification(ReportDeclarative ) :
Tag-Lib Name :reportDeclarative
Tag-Lib-URL: http://www.adfwithejb.blogspot.com
Tag-Lib-Prefix :report
Component Name :ReportDeclarative
*All i have changed the Tag-Lib information .
Attribute of the ReportDeclarative component are following :
S.No. | Attribute Name | Required | Default Value | Explanation |
1 | Button Name | Yes | It will display as button name of download button | |
2 | Report Type | Yes | 1-For Pdf Report :PDF 2-For Csv Report :CSV 3-For Html Report :HTML 4-For XML Report :XML |
|
3 | Report Name | Yes | Name of the report.it does not require any extension | |
4 | Table Id | Yes | af:table id which you want to export into pdf | |
5 | Serial Number | No |
False | It will add one column in the table which contains serial number |
6 | Pagination | No | False | Pagination in pdf.It will only applicable when report type is pdf. |
7 | Row Tag | No | If you generating XML report then it is required | |
8 | Parent Tag | No | If you generating XML report then it is required | |
9 | Serial Column Header | No | S.No. | If you are generating report with serial number then by default column header will be S.No. If you want to change then you can replace it here. |
Following Feature added in this version which were not presented in last version .
1-Exception handling is implemented
2-Pagination is implemented
3-Serial Number
4-XML Report Support
5-HTML Report Support
6-CSV Support
7-Region Support
You can use this component in Region as well .
Since only pdf report require itext API so do not forget to add itext jar file in project which is present at following link.
http://www.4shared.com/file/a8rSo6rk/itextpdf-510.html
Download component jar at following line :
https://docs.google.com/file/d/0B8cP4jZuxLlXbWs2TjNwZzFvdGM/edit
(This time i have been uploaded file in google document )
* I have already mentioned in my last how to add declarative component jar in the project.
I tested this with multiple scenario and it is working for me.Please let me know if you will get any type of exception or error.
PDF Report:
*You can generate pagination
*You can add serial number and you can change serial column header by default will S.No.
CSV Report :
*CSV file contains comma separate value.
*So if you are using Open office then you have to check separate by comm .
*Pagination is not applicable
*You can add serial number and also you can change the default serial column header value.
*It is same as note file hence Header will not come as bold .
HTML Report :
*You can add serial number and also you can change the default serial column header value.
*Pagination is not applicable
XML Report :
*Column name will come as opening tag and closing tag.
*You need to provide parent tag of the column in Raw Tag attribute of the declarative component
*All the parent tag should also have parent therefore you also need to provide parent tag value in Parent Tag attribute of the declarative component.
*No pagination will work .
Any comment will appreciated .
Thanks
Prateek
many thanks for this great component
ReplyDeletebut there is an issue when I test this component
OS: Windows7
Jdev Ver:11.1.1.6
IE:9
Issue: I must press button two times in order to generate report.
when I press it for the first time it still loads but no report is generated.
Hello Ahmed ,
DeleteThis is not problem with component.I think you did not have af:form in your page or might be component not inside in af:form.
Since i already faced the same problem and it resolved after putting the component inside in the af:form .
Please let me know your experience.
Thanks
Prateek
god jab and i now that i itext is using a PDF file as a template i was tring that in V 5.1.3 are it`s can be use to ad the template pdf file url as one of the component parameter
ReplyDeletei like to ask you if you can send me the source of the Component
ReplyDeletesure ,
ReplyDeleteCan you send me your email id address ?
Thanks
Prateek
Hi Prateek,
DeleteThanks for such a useful reusable library, can u pls share the code so that i can customize this to my requirement? :)
aaridrakamanu@gmail.com
Hi Prateek
DeleteI also require this re usable declarative component library . Please send me source of this code at email address nisarg.doshi23@gmail.com
i really would like to thank you this is such a generous offer you gave ,
ReplyDeletemy mail is :
omar@mohamedomar.me
thank you
Hi Prateek ,
ReplyDeleteCan you please send me the code . As i need to extend the same with few layout changes . can you please help me on this .
Thank you,
sashankp@gmail.com
Hello Kumar ,
ReplyDeleteThank you for the gerat component, but I couldn't managed to work it . I added you library as to my project but still cannot find your component (reportDeclarative) in the component browser.
In the log , it seems all went good wjile adding the linbrary to project.
These ADF Library jar items are now in ViewController.jpr
{
file:/C:/Oracle/Middleware/jdeveloper/adfv/jlib/oracle-page-templates.jar
file:/C:/Oracle/Middleware/jdeveloper/adfv/jlib/oracle-page-templates-ext.jar
file:/C:/Dev/adf/mywork/declarativeComponents/adflibReportGeneration.jar
These are in the project as a result of your ADF jar imports:
Itextpdf-5.1.0.jar (file:/C:/Dev/adf/mywork/declarativeComponents/itextpdf-5.1.0.jar from .../ReportAppsV2/ReportGeneration/ReportGeneration.jpr )
}
Do you have any idea what can be the problem ?
Also if it is possible may I have your code ?
fhuanhar@gmail.com
Best Regards,
Ahmed
Hello Kumar ,
ReplyDeleteI noticed that your component is for jsp pages. I want to use this on a JSF page.
Ahmed
Hi Prateek,
ReplyDeleteYour component works very well for JSP pages and it is not working in JSF page.Will you add or edit your component to support JSF also. Will you share me the source code.
thanks
Obu
hi Prateek,
ReplyDeleteYour Tutorial is very helpfull for us,
If Possible Can you please send me the Compoenet code . As i need to extend the same with few layout changes like logos and Headers . can you please help me on this .
My Email Id is: satishkumar0542@gmail.com
Hi Prateek ,
ReplyDeleteGreat post! It's really helpful.Can you send me the source code for the same. Need some tweaks to use it.
Please mail me at - shanto.mathew2011@gmail.com
Thanks,
Shanto
HIi Prateek,
ReplyDeleteIts very useful thing , can u please send me the code with example so I can use it.
My email id: ashishomenia2@gmail.com.
thanks .
Hi Prateek,
ReplyDeleteCould you share me the code.. it's really helpful..
Thanks in advance..
Hi Prateek,
ReplyDeleteCould you share me the code too.. it's really useful.. my email id : ajit_sri@hotmail.com
Thanks
Hi Prateek,
ReplyDeleteYour blog is very useful. If possible, would you please share the source code also? My email id is jaga.griffins@gmail.com.
Thanks.