HI

not sure how much Crystal expertise there is on here (since Kevins unfortunate departure)

My question is

I have a sub report in a large Crystal Report and I can see the SQL used in the sub report by using Database > Show SQL Query

If I cut and paste the SQL shown into my SQL Management Studio I get a different result. More rows are selected.

Any ideas.

Thanks