Hi all,
one of our developers has written some code in PL/SQL. When the code is run in PL/SQL, it returns the correct results:
Episode Name and NumberSlot DurationtestRay Mears: Extreme Survival (2): Ep 1, Sahara0.6760000Ray Mears: Extreme Survival (2): Ep 2, Rockies, The0.6760000Ray Mears: Extreme Survival (2): Ep 2, Rockies, The0.545000Ray Mears: Extreme Survival (2): Ep 1, Sahara0.545000

As it is supposed to return only results where the figures under the "Test" column are greater than 0 (zero).
When the same code is run via Crystal, the results are displaying 3 extra rows for which PL/SQL was correctly not reporting as the "test" value is supposed to be 0 :

Episode Name and NumberSlot DurationtestRay Mears: Extreme Survival (2): Ep 1, Sahara0.6760000Ray Mears: Extreme Survival (2): Ep 2, Rockies, The0.6760000Ray Mears: Extreme Survival (2): Ep 2, Rockies, The0.545000Ray Mears: Extreme Survival (2): Ep 1, Sahara0.545000Lord Of The Skies0.6760000Have I Got News For You (21): Ep 6 *84 is PRE*#0.6760000Have I Got News For You (21): Ep 6 *84 is PRE*#0.6760000


We are running Oracle 9i and version 9 of Crystal...I have tried to redo synonims and change cursors...but it still does not work...it seems that Crystal translates the results from PL/SQL in a different way...
Can you help?
How do I format the post so that the tables make sense in here rather than just reporting as one line?
Thanks