I have a crystal report which uses a stored proc to fetch the result set via cursor. When I execute the report via designer, the report runs fine but when i upload the report to CMC and schedule it, it runs but duplicates all the records. A trace on this report revealed that the stored proc is being called twice and hence the duplication. Is this a bug in the business objects product or is there another way of coding this kind of report.
Any suggestions is highly appreciated.
Thanks,
Kiran
kirandb (BOB member since 2010-08-05)