Returned data different between CR and CE

[BigalYoung]

Hi all,

CR10 and CE10 on SQL Server 2000.

Within CR10 the report returns 23 rows of data.
Within CE10 the report returns 1 row of data (only the very first row). This happens when previewed or scheduled.

I've taken the SQL from CR10 and applied it to the database and the 23 rows that it returns is correct.

Anyone had this type of problem before?

Cheers

Bigal (MIS)
Virgin Retail

http://www.virginmega.co.uk

 

[synapsevampire]

Perhaps there's some security applied and the user logging into the CE server has different privileges?

It's generally something like that.

Also recheck the ODBC on the server, perhaps it's poitning to a test or qa database.

Having CR on the CE server is a good idea for testing such things.

-k