×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Different values in design and scheduled mode

Different values in design and scheduled mode

Different values in design and scheduled mode

(OP)
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.

RE: Different values in design and scheduled mode

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

RE: Different values in design and scheduled mode

(OP)
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

RE: Different values in design and scheduled mode

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

RE: Different values in design and scheduled mode

(OP)
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

RE: Different values in design and scheduled mode

Interesting...

Does it do this when you export as well?

Is the login different?

Very odd indeed...

-k

RE: Different values in design and scheduled mode

(OP)
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

RE: Different values in design and scheduled mode

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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close