1 / 17

Reporting with ColdFusion MX v7.0: Web Reporting-Freedom Realized

What I will cover in this presentation. Basic ColdFusion Report Builder description and functionWhat tools are neededHow to install and configure CRBHow to create reports using Query WizardHow to create reports using a Stored ProcedureHow to create reports dynamically with CFReport. What is t

lang
Download Presentation

Reporting with ColdFusion MX v7.0: Web Reporting-Freedom Realized

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

    1. Randy Brown brownra@msu.edu April 12, 2005 Reporting with ColdFusion MX v7.0: Web Reporting-Freedom Realized

    2. What I will cover in this presentation Basic ColdFusion Report Builder description and function What tools are needed How to install and configure CRB How to create reports using Query Wizard How to create reports using a Stored Procedure How to create reports dynamically with CFReport

    3. What is the ColdFusion Report Builder (CRB)? FREE Stand-alone report file (*.cfr) GUI based report-writer CFReport tag dynamically call reports created with CRB WYSIWYG reports in common file formats (Flashpaper, Adobe PDF and Microsoft Excel). A very powerful integrated business reporting tool. More� visit www.macromedia.com

    4. What You Will Need ColdFusion MX v7.0 Standard or Enterprise Edition: ColdFusion Report Builder (CRB) http://www.macromedia.com/software/coldfusion/reporting Adobe Acrobat v5.0 or greater: Macromedia Flash Player v7.0 or greater: Browser of your Choice (IE or Firefox):

    5. What the Client will need Internet Browser (IE or Firefox preferred). Adobe Acrobat Reader v5.0 or greater Macromedia Flash Player v7.0 or greater Microsoft Excel v5.0 or greater

    6. Install and Configure ColdFusion Report Builder

    7. Install CRB on you workstation Download CRB from http://www.macromedia.com/software/coldfusion/reporting Double click the installer file cf_reportbuilder_installer.exe Note some features in CRB require that you have RDS enabled.

    8. CFMX 7 RDS screen Did you enable this? If you DID NOT you will loose some of the functionality CRB has to offer, however you can still use it.

    9. Configure CRB

    10. Configure CRB step 2

    11. Configure CRB step 3

    12. My Example Application I plan on using CFMX7,ColdFusion Report Builder and CFReport to dynamically deliver the online giving results for year 2003-2004

    13. How to create reports using Query Wizard Step 1- build your query � Open CRR, goto Report, Report Query Step 2 - Select Fields you want to use Step 3 - Layout Report using the various bands Step 4 - Save report, test it and tweak it

    14. Demo 1 Introduce CFUG members to the GUI Use the Gift Status Example Build *.cfr from Scratch, note quarks and gotchas Insert header Graphic Align Fields in Bands Add Page Number (Page Footer) Add calculated Total amount of gifts

    15. How to create reports using a Stored Procedure Step 1 Create the Stored Procedures Step 2 Build your CFR or use template Step 3 map your fields Step 4 Run the *.cfr from CRB Step 4 Run the *.cfr from CFM file

    16. Demo 2 Build Gift Status report using a canned template Reference qry_demo2 in database (t_date, desi_code, amount) Stored Procedures are best in this case because it keeps the logic out of your report

    17. Questions

    18. Resources Introducing ColdFusion MX 7 -http://www.macromedia.com/devnet/mx/coldfusion/articles/intro_cf7_05.html Building Reports with ColdFusion MX 7 - http://www.macromedia.com/devnet/mx/coldfusion/articles/reporting.html ColdFusion Forum - http://www.macromedia.com/cfusion/webforums/forum/index.cfm?forumid=1

More Related