I have a stored procedure with IF and ELSE condition. It is working well but I want to add a third condition and the stored procedure conditions need to be replaced with: IF .. ELSE IF and ELSE.
When I add ELSE IF, it is not showing correct columns in the FIELD EXPLORER. It is showing columns of the first condition only.
My assumption is to remove the if else from SP and store the condifition is report level, else you need to push all the fields from SP and change if else condition accordingly.
Marked as answer by Ming Xu - MSFT on Feb 28, 2012 01:03 PM
rpk2006
Member
631 Points
629 Posts
Crystal Reports Database Expert not showing columns of stored procedure
Feb 13, 2012 05:15 AM|LINK
I have a stored procedure with IF and ELSE condition. It is working well but I want to add a third condition and the stored procedure conditions need to be replaced with: IF .. ELSE IF and ELSE.
When I add ELSE IF, it is not showing correct columns in the FIELD EXPLORER. It is showing columns of the first condition only.
How to make ELSE IF work?
cnranasinghe
Star
8885 Points
1798 Posts
Re: Crystal Reports Database Expert not showing columns of stored procedure
Feb 14, 2012 05:17 AM|LINK
My assumption is to remove the if else from SP and store the condifition is report level, else you need to push all the fields from SP and change if else condition accordingly.