Skip to Content
Former Member
Jul 24, 2017 at 12:15 PM

Crystal report sub query selection statement


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.