5/5/2010 3:28:28 AM
Title:
Cross-tab Reports in Flex
I am totally amazed at the cool front-end UI things that could be
done in Flex. I have been dabbling a lot on Flex and steadily getting the
hang of it.
Anyway, one thing which I am looking for is on creating and printing reports. I am looking for some resources on how to achieve such
things, like:
1. Crosstab reports
2. Executive summaries
3. Free-Form reports
I would also like to know about the tools available for exporting the data to PDF or Excel formate from the genrated reports.
Basically, am looking on how I would be able to design/generate reports which could be used in a Flex application.
I would certainly welcome advise and feedback on this. Resources for further explorations on reporting would also be appreciated.
5/5/2010 4:47:17 AM
to display reports you can use the inbuilt components of flex like datagrid which accepts data as xml file. Or you can use your custom reporting design by placing labels on a canvas.
There is no direct method in flex to generate data to PDF or Excel formats. But instead you have to send the data to server side language like .net, php etc which can generate the reports in PDF or excel using server side API's for such formats.
5/5/2010 5:04:28 AM
You can print anything that you can see in the flash screen. So generating report design is the main work you need to do . Printing is not a big deal.
For cross Tabbed reports you can use tabbar component where each tab can contain one report.
Free form reports can be generated by just placing textarea or other text display components on a container like canvas.
Flex is client side just like html, so cannot generate reports to other formats like PDF or excel. You need to use some third party tool . You can send the data from flex to that tool and generate files.
The reports generated in XML format can be directly used in flex to provide direct data to some components like grid, list, datagrid etc
5/5/2010 6:55:33 AM
Bob and Rex, Thanks for your replay. I am using Java on server side with spring integration for my Flex application. My meaning of Cross-tab reports was typical cross-tab reports generated by Cognos Reporting tool. The application one i am developing will be having around 200 reports which can be defined with some 7 common templates. After some R&D on net I felt like OLAP Data Grid would provide more or less similar functionality. Any help or Reference Docs with examples related to OLAP Data Grid would be more appreciated.
Inder
Points: 2880
Posts:0
5/5/2010 8:34:35 AM
Hi Kiran, regarding your reports. Below are my thoughts, see if I am right.
1) You must be displaying one report at a one time and not the all 200 reports which means that when any report is required its data can be fetched from the server and displayed.
2) You have 7 templates which means that a single report can be displayed in 7 type of formats. For that you can use a combo box , or a tab control which can be used to select the format for any current report being displayed.
Regarding the OLAP Data Grid, the OLAP data grid is designed to manage when records are huge and a summery can be displayed instead of all the records say more than 1000 to records. Like we do display data using PIE charts or graphs. In your case I think you are not displaying the summery but the detailed reports.
However you can get some more detailed information with examples on these links:
http://livedocs.adobe.com/flex/3/html/help.html?content=olapdatagrid_2.html
http://livedocs.adobe.com/flex/3/html/help.html?content=olapdatagrid_3.html#265426
http://livedocs.adobe.com/flex/3/html/help.html?content=olapdatagrid_8.html