Hi,
I've set up a data-driven subscription on a report but it's not sending and the error log says it's because:
Default value or value provided for the report parameter 'CSRFaxID' is not a valid value.
For the particular dataset record causing the error I'm passing the value Null to the report parameter. The report parameter CSRFaxID is set up with "Allow Null" and with a default value of Null. I can run the report in my browser with CSRFaxID set to null, but the scheduled subscription is not able to produce the report with the same parameter value. Does anyone have any idea what the problem is and how I can fix it?
Regards,
Greg McNamara
Hi,
NULL values can cause plenty of headaches and unpredictable behavior in sub-systems.
Try not to use NULL. Set the default to 'UNK' or 0 instead and make sure that no null values are left over.
If needed disallow nulls or replace nulls by something like 'UNK'
Philippe
|||Hi Philippe,
Thanks for your help. I actually tried something similar to this and it worked ok. The column is type uniqueidentifier so I just passed a guid with all zeroes. It seems a bit strange to have to use this workaround, there seems to be an inconsistency between data-driven subscription datasets and defined report parameters where NULL is concerned.
Regards,
Greg
