Hey all,

To my company's call tracking system I am now adding a reporting feature. We used to have to go into Crystal Reports and manually do the reporting. I am building the reports in ColdFusion's report builder so that we can access them from the web.

I was wondering if anyone knows of a way to simply convert Crystal Reports files into CFR files. There are only three of them so if not I have already begun rebuilding them, but I am very new at the Report Builder.

If there is no way to convert them then I need help with my query.
So I am building my Query and so far this is what I have



I know that there is stuff in the DB to match all of that, but it returns nothing. Can anyone see and error in the query?

open new coldfusion report builder pager, click on the database icon, and paste your query save it, close the screen. back the main page expand query fields and drop and drop the item on the report page, align labels and fields as you like to display them.
Before all this you need ODBC connection to connect to database, save you changes as .cfr file and create .cfm which will run your report in the browser called .cfm

<cfsetting showdebugoutput="false">
<META http-equiv="Content-Type" content="text/html; charset=utf-8">
<cfprocessingdirective pageencoding="utf-8" >
<cfscript>
SetEncoding("form","utf-8");
SetEncoding("url","utf-8");
</cfscript>

<cfset dsn = "Development"> <--datasourcename-->

<cfreport template="Estimate.cfr" format="pdf"><--filename-->
<cfreportparam name="EstimateVersion" value="1">
<cfreportparam name="estimateID" value="123"> <-- String -->
<cfreportparam name="DATASOURCENAME" value="#dsn#">
</cfreport>

hope this helps