That's unfortunate.   It might be worth filing a feature request.

The plus sign is for adding numbers. Use the ampersand for concatenating strings.

It works now, …

As I said in my first reply, you want to use your SQL query to prevent data from reaching your report that you don't want to print. That way you won't have to decide whether or not to print something…

Have you tried, for example: if ( desiredCompletionDate != "" ) {      qryForExcel["Desired Completion Date"][qryForExcel.recordCount] = desiredCompletionDate; }

You're welcome. Happy coding.

Change format="PDF" to format="#VariableName#" where VariableName contains the text "PDF" or "Excel".

If you evaluate your variables, what do they contain?

You need to put some alert statements into your script to ensure that (a) execution is reaching that part of the script and (b) the script is dealing with expected values.   For example:…

If you want to write the document to a file, your cfdocument tag must include the filename attribute.   Did you perhaps just leave that out of the example you posted?

I don't use CF11, but some troubleshooting tips: Try hard coding the URL of the cflocation tag and test it. If it works then assign the URL you are constructing to a string and dump that string so…