Email a Report from Report Builder

[susanh]

Good Morning,

I am to the Report Builder and so far like it, but I am kind of stuck on how to email my report.

I have been searching the web and have found ways to do it using cfdocument. So I am a bit confused and am wondering how I email it.

Here is my code which works fine via the web browser.

<cfquery name="daily_call" datasource="parts">
SELECT Assigned, Name, StartDate, DueDate, qte, amtquoted, sold, amountsold, updated_date, jobtype
FROM tasks
WHERE updated_date = #CreateODBCDate(DateAdd("d", -1, Now()))#
Group by Assigned, Name, StartDate, DueDate, qte, amtquoted, sold, amountsold, updated_date, jobtype
ORDER BY Assigned, Name
</cfquery>

<CFREPORT format="PDF" template="daily_call_report.cfr"
query="#daily_call#" />

Any help would be much appreciated. Thank Sue

 

[susanh]

I figured it out! Yeah!

I was putting to much thought into it. Just needed the filename parameter for the report tag and then was able to add the cfmail tag to grab the file as an attachment.