Coldfuion Report Builder

Of the most powerful and convenient report builder is Coldfusion Report Builder. It’s absolutely just like crystal report. You can make your report design in CF report builder or you can use their built-in theme, either. Are you getting sick of writing query in cf report builder? It’s ok. You can write Query in your cfm file and output report just like :

<cfquery name=”qryUsers” datasource=”#application.datasource#”>
SELECT * FROM Users WHERE U_ID = <cfqueryparam value=”#url.id#” cfsqltype=”CF_SQL_NUMBER”>
</cfquery>

<cfreport template=”NewColdFusionReport.cfr” query=”qryUsers” format=”PDF”>
</cfreport>

Integrate Crystal Reports into CFreport

Wanna reduce server load cos of reporting so many data? Getting sick of designing HTML coding for report? You don’t need to worry of above 2 questions. CFreport is there for you to fulfill your desire.

First of all, you need to draw your report in crystal report on-click action. Then, save these report. Here you need to embed this report in CFML.

<CFREPORT REPORT=”myreport.rpt”></CFREPORT>

Wanna to pass parameters into this crystal reports? Here you go:

<CFREPORT REPORT=”myreport.rpt”>
{Table_name.field_name} = “ppshein”
</CFREPORT>