November 15, 2007 at 9:25 pm
I am trying to create a data driven subscription for a report through Report Manager. One of the params is employeeid which is a 5-6 character varchar field. Although it is a varchar field, the values are all numeric. The report runs fine through report manager but everytime I try to batch, it generates an error. I've tried the following:
1). hard coding a specific value for the param. This won't even let me save the subscription.
2). pulling employeeid from a db query
The param in the report is set to expect a string. Within the db query in the subscription, I cast the field as varchar but it didn't change anything. The stored proc behind the report accept a varchar as a parameter for this field. I just can't figure out where this is going wrong!
Any ideas or help would be greatly appreciated!
TIA,
Beth
December 5, 2007 at 3:35 pm
Make sure that you aren't using the global USER.UserID otherwise the DDS will fail every time. Any report that contains a field w/ that function or embedded in a parameter will cause a DDS to fail. I've run into this several times...
Ben Sullins
bensullins.com
Beer is my primary key...
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply