January 20, 2010 at 12:20 pm
I have a sp which is returning the result set as well as an error message. I want to populate this result set in SSRS report by ignoring the error. But report taking only error message and displaying in the report, I want to ignore error and display results
1) is it possible to display only resultset by ignoring error message?
2) if yes, How? do we have options or properties in ssrs to take only result set instead of error message
3) If No, any alternative solution please?
4) I also tried using Try.. catch in my script to ignore , but its SQL2000 compatible so I cannot use TRY .. Catch.
Thanks in Advance
January 21, 2010 at 7:29 am
What is the error?
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
January 21, 2010 at 7:20 pm
Error: invalid length parameter passed to the substring
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply