Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Same report: - different outcome Post Reply Post New Topic
Author Message
yggdrasil
Senior Member
Senior Member
Avatar

Joined: 19 Jun 2007
Location: United Kingdom
Online Status: Offline
Posts: 150
Quote yggdrasil Replybullet Topic: Same report: - different outcome
    Posted: 23 Oct 2007 at 2:06am
This one has me totally confused.  I have a large report with three separate subreports. It works fine with the first two, then I added the third (which is much more complicated).
This too works on my PC. But not on either of my colleagues, it just doesn't bring back any data for them!
We are all using Crystal 10, and as far as I can see have the same setup and configuration.  We all connect to the same database in the same way. I have no idea where the difference could lie.Confused
Can you give me any idea where to look?
Thanks
IP IP Logged
yggdrasil
Senior Member
Senior Member
Avatar

Joined: 19 Jun 2007
Location: United Kingdom
Online Status: Offline
Posts: 150
Quote yggdrasil Replybullet Posted: 24 Oct 2007 at 12:27am

I have since found that we have a difference in the Number format set under Options. I have numbers set to 1234, he has 1234.56  If he resets to integer, he gets results too.  But this report has to be distributed, so it has to work whichever way.  Anyway, it works ok with the other two subreports, which are very similar. And the linking parameters are all primary to foreign keys, which are integer numbers.

This is actually distributed to work with a bought-in  Oracle system which has a run-time version of Crystal embedded to run these reports I write. I cannot change anything in this system, so I have to get it right here.

IP IP Logged
yggdrasil
Senior Member
Senior Member
Avatar

Joined: 19 Jun 2007
Location: United Kingdom
Online Status: Offline
Posts: 150
Quote yggdrasil Replybullet Posted: 02 Nov 2007 at 3:52am

No replies Cry

I've had to leave this for a while for a high priority job, but I will have to make another attempt next week.
IP IP Logged
claudius
Newbie
Newbie


Joined: 01 Nov 2007
Online Status: Offline
Posts: 3
Quote claudius Replybullet Posted: 02 Nov 2007 at 5:51am
Once uppon a time I have had an issue where the report was working in my company environment but failed to start at customers...

I solved it by doing following:

I've saved the subreports into separate reports and I proved them to be working fine in all environments.

Than I made a copy of one of them, I got rid of all the content and used it as a canvas for the subreports. I have added all the subreports to the canvas providing accurate parameter links. I've test it few times and than I've saved it. It started to work in customers environment. Until now I don't know why it failed to start beforehand.

I hope that will help :)

Cheers
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.