Hello Scott,
Thank you for the update, however I am not using a FetchXML based report. I am using the CRMAF_ prefix in the query however when I run the report that parameter does not seem to be getting the value from crmaf_incidentid as it should to run against the single record that is open in the form. My query is shown below and below that are my settings for the @CaseID parameter
select CRMAF_fi.customeridname,
CRMAF_fi.createdbyname,
CRMAF_fi.createdon,
CRMAF_fi.incidentid,
CRMAF_fi.title,
CRMAF_fi.dandh_calltagname,
CRMAF_fi.dandh_accntnum,
CRMAF_fi.dandh_contactnamename,
CRMAF_fi.dandh_invoicedate,
CRMAF_fi.dandh_invoicenumber,
CRMAF_fi.dandh_errortypename,
CRMAF_fi.ticketnumber,
CRMAF_fi.dandh_branchname,
CRMAF_fi.dandh_comments,
CRMAF_fi.dandh_resolution,
CRMAF_fi.dandh_invoicereceived,
CRMAF_fi.dandh_receivedaccountnamename,
CRMAF_fi.dandh_receivedaccountnumber,
CRMAF_fi.dandh_custrecname
from filteredincident CRMAF_fi
where CRMAF_fi.incidentid = @CaseID
CaseID Parameter Settings:
General tab - Name & Prompt are both set to CaseID, data type is text, all check boxes are blank and the visibility is Hidden
Avail Values tab - None is selected
default Values tab - No default value is selected
Advanced tab - Automatically refresh is selected and the check to notify is selected
