Hi,

I'm still doing battle with my delivery date report and I decided to revert to a much simpler report but now things have gone very weird.  If I run the report from Crystal 2008 end it works fine but if I run it from the database end it has a major issue and massively over counts some items.

When developing and run in Crystal it says 3 (I'm using DistinctCount({ADL_Loans.personID})) people have 4 (using Count({ADL_Loans.personID})) items delivered.  When embedded and run from the database it says 3 people have 53,156 items delivered!  We have never issued anywhere near that number.  This is somehow linked to a formula I am using to calculate delivery times as when I remove it from the report it correctly counts at the database end

 (datediff("d",{Referrals.FirstContactDate}, {ADL_Loans.Loaned_Date}) -

    DateDiff ("ww", {Referrals.FirstContactDate}, {ADL_Loans.Loaned_Date}, crSaturday) -

     DateDiff ("ww", {Referrals.FirstContactDate}, {ADL_Loans.Loaned_Date}, crSunday))

The annoying thing is I seem to recall it working about a month ago but I could be confusing it with another report.  It’s proving difficult to bugtest because I have to alter it in crystal then logon to our main database then run it from there and wait several minutes to get the output because of the massive overcount.  I've been altering the join types on the tables but nothing so far.

Has anyone ever experienced an issue where crystal gives the right output but when run elsewhere it’s wildy incorrect.  Is it a known issue perhaps? 

Ben

Sorry for being unclear, I'm not sure of the proper terminology but here goes.

I'm not sure of the exact process but I believe it uses .net framework.  I link the application that is the database frontend to a saved crystal report and when clicked it will then ask for any parameters and usually run and output exactly as it would within Crystal.  This allows the application frontend user to run the custom reports I create.  Permissions are the same, user credentials are the same I believe.  There are hundred of reports I've linked to the application frontend and they all still work. 

I also have to ensure Crystal Reports Runtime redistributable is on each machine that has the database frontend.  Saying that maybe there is a more uptodate version of the redistributable so I'll have a look tomorrow.