I am using Crystal report version 8, I want to use a sub query in existing report DB filed selection something like,
when case (select count(paper) from table B = 0) then "not authorized" else A.paperinfo End.
select expert doesn't allow me to use sub query, since table B is having duplicates I cant use join. I have no other option other than using a sub query in DB field selection.
In version 8, command parameter is not working, It would be great help if you able to provide me some suggestion.