Hi,
Rather than getting the query string to pass to a stored proc to use in a
crystal report, I am jsut going to make them export to .csv.
thanks all for suggestions etc.
<CFIF ISDEFINED("URL.PRINT")>
<CFHEADER NAME="Content-Disposition" VALUE="attachment;
filename=InvoiceSearch_#TimeFormat(Now(), "HHmmss")#.csv">
<cfheader name="Content-type" value="application/vnd.ms-excel"/>MRN,Surname,
Given Names, DOB, Invoice Number, Invoice Date, Provider, Provider Number,
Billing Mechanism, Episode Type,Hosptial Code, Admit Date, Discharge Date,
Invoice Amount, Amount Paid, Adjusted,
Balance<cfoutput>#CHR(13)##CHR(10)#</cfoutput>
<CFOUTPUT
query="SEARCH_RESULT">#SEARCH_RESULT.SB_PATIENT_MRN#,#SEARCH_RESULT.SB_PATIENT_SURNAME#,#SEARCH_RESULT.SB_PATIENT_OTHER_NAMES#,#DateFormat(SEARCH_RESULT.SB_PATIENT_DOB,'dd/MMM/yyyy')#,#SEARCH_RESULT.SB_INVOICE_NUMBER#,#DateFormat(SEARCH_RESULT.SB_INVOICE_DATE,
'dd/MMM/yyyy')#,#SEARCH_RESULT.SB_PROVIDER_SURNAME#,#SEARCH_RESULT.SB_PROVIDER_NUMBER#,#SEARCH_RESULT.SB_BILL_MECH_DESC#,#SEARCH_RESULT.SB_EPISODE_TYPE_DESC#,#SEARCH_RESULT.SB_HOSPITAL_CODE#,#SEARCH_RESULT.SB_ADMISSION_DATE#,#SEARCH_RESULT.SB_DISCHARGE_DATE#,#SEARCH_RESULT.INVOICE_AMOUNT#,#SEARCH_RESULT.AMOUNT_PAID#,#SEARCH_RESULT.AMOUNT_ADJUSTED#,#SEARCH_RESULT.BALANCE##CHR(13)##CHR(10)#</CFOUTPUT>
<cfabort>
</CFIF>
---
You are currently subscribed to cfaussie as: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]
Aussie Macromedia Developers: http://lists.daemon.com.au/
