CF Reporting using objects

Forum|Forum|12 years ago
December 5, 2013
1 reply
664 views

I already have a very complex dynamic query the displays a list on the webpage. Now I need to pass this result set as object or csv or xml to CFR and produce a report.

how to do this?

This topic has been closed for replies.

Anit_Kumar

Community Manager

Hi jolakammu,

You may try something like the below code:-

select * from table_name

</cfquery>

<cfspreadsheet

action = "write"

filename="AgentReport.xls"

query="query_name"

overwrite="true">

</cfform>

Regards,

Anit Kumar

A

Anonymous

May be I was not clear on my question. Now how to pass this data to a coldfusion report and generate nice looking (header, footer, body, bolding , page number, grouping etc) report as pdf. Thanks.

I mean, how to make this csv as a datasource and create a report template (.cfr)

Upen1

Inspiring

Here this is a simple example of generating report using query object by "cfreport" tag and report template.

http://coldfusion-tip.blogspot.com/2013/11/using-coldfusion-report-template-to.html

If you want to use a CSV data in report template then I think you need to convert CSV into Query object then follow the process descriobed in the above URL.

For CSV to Query coversion, you may refrer following links or you can write your own functon:

http://cflib.org/udf/CSVToQuery

http://www.bennadel.com/blog/501-Parsing-CSV-Values-In-To-A-ColdFusion-Query.htm

For more knowledge about ColdFusion reporting please refer following links:

https://learn.adobe.com/wiki/display/coldfusionen/cfreport

http://help.adobe.com/en_US/ColdFusion/10.0/Developing/WSc3ff6d0ea77859461172e0811cbec22c24-6fc2.html