I am designing a report based on a sql stored procedure with 3 parameters required. I have a parameter that I would like to make dynamic based on an "Item" table for multiple selections.
I keep getting this error when I run the report
Prompting failed with the following error message: 'List of VAlues failure: fail to get values. (Cause of error: the new table link contains TargetFieldNames that are not valid. Error source: prompt.dll
Error code: 0x8004380d
Can someone point me to an example or tell me if this even possible to do?
Edited by: SHARON SCHMIDT on Feb 17, 2009 3:16 PM