February 1, 2006 at 6:31 pm
I'm running on SQL 2000 with SRS. Standard install (I think, it was all set up by IT)
I have reports that run fine in the Report Manager but when they are run through a schedule (email) some of them (albeit most) "rsProcessingAborted" because of a report error.
Looking at the logs it seems generally based around comparison failure because of datatypes, eg (from the logs):
Now, when I remove sorting/grouping the reports run through the schedule OK; but that is obviously NOT what I want the report to look like. But it proves that the sorting/grouping has something to do with the problem.
I'm pretty sure that they are NOT the problem though, as the reports render in Report Manager fine with all the original sorting/grouping in place (ie no problems during development, just when we wanted them served to the employees Isn't that always the way it goes??). We've even had some reports which scheduled OK previously, but throw errors now.
I'm at a loss!!
Any suggestions greatfully appreciated (by myself and my hair)
February 2, 2006 at 6:54 pm
What sort of expression do yuo have for the sort expression e.g. is it VB.net code doing something neat or just simply "sort this field ascending"?
Steve.
February 3, 2006 at 5:27 am
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply