Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Different values in design and scheduled mode

Status
Not open for further replies.
goranm

goranm

Programmer
Dec 18, 2001
247
SE
I have a very stange problem.

My report, wich includes two linked subreports, shows right values when I run it thru the Report Designer, but when I schedule the report it shows complete different values.

We have Seagate Info 7.0.2.

Does anyone have any ideas ?

Thanks.
 
Sort by date Sort by votes
I'd guess that you have 2 different data sources involved, that's generally the case.

Perhaps a subreport is pointing to a different ODBC?

-k
 
Upvote 0 Downvote
Hi !

Thanks for your answer, but it is the same ODBC-connection in the main report as in the two subreports.

I have also tried to use a native connection, but with the same result.

/Goran
 
Upvote 0 Downvote
I'd guess that the ODBC connection on the server is different, rather than the initial guess that one subreport is pointing to a different ODBC.

ODBC Administration has a tracing facility which might help you to understand why there is a difference.

An alternative might be that number formats are different, so the values appear to be different, or you're using a & concatenation which is producing seemingly wrong results.

-k
 
Upvote 0 Downvote
Hi !

Thanks again.

You see when I have been running the report thru the Report Designer I have done that on the same server as where it is scheduled.

And my values in the subreports are just simple counts.

/Goran
 
Upvote 0 Downvote
Interesting...

Does it do this when you export as well?

Is the login different?

Very odd indeed...

-k
 
Upvote 0 Downvote
Hi !

I tested and made an export to excel, and it was the same problem.

The login is also the the same for both main and subreports.

/Goran
 
Upvote 0 Downvote
I've had this happen if I use the wrong ODBC driver, such as using the Oracle supplied driver instead of the Crystal supplied Oracle driver.

-k
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

A Beginner
  • Locked
  • Question
is the RDC still available in Crystal Report
Replies
1
Views
424
hilfy
hilfy
hpl2001
  • Locked
  • Question
Report in History auto updating
Replies
0
Views
238
hpl2001
hpl2001
mikekask
  • Locked
  • Question
Download Seagate Crystal SQL Designer
Replies
1
Views
351
mikekask
mikekask
pcdudekc3585
  • Locked
  • Question
Seagate 7.5 info desktop
Replies
0
Views
247
pcdudekc3585
pcdudekc3585
dfor
  • Locked
  • Question
Selecting random records in Crystal
Replies
1
Views
370
lbass
lbass

Part and Inventory Search

Sponsor

Back
Top