Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 591
  • Last Modified:

Dtabase object error-

Hello,

I designed a report (Crystal Reports XI) to read a database table and display the contents in a report.  The report uses a database command to query the table.
SELECT  *
FROM    RPTINGDATA.SLDACCTSUM
WHERE   DMNAME NOT IN ('FFFINAL','FFPREFINAL')
AND        SALEBATCHID <> ''
When I run the report "on demand" or "run now" it executes correctly.  When I schedule the report to run under Business Objects Enterprises I get the following error:
Error in File C:\Program Files\Business Objects\BusinessObjects Enterprise 11\Data\procSched\myusswalprv0010.reportjobserver\~tmp49c045a26deae415.rpt: Error in formula <Record Selection>. '{SLDACCTSUM.DMNAME} <> "FFFINAL" and ' This field name is not known. Details: errorKind

Any Idead what my problem is?
   
0
BrianMack
Asked:
BrianMack
  • 3
  • 2
1 Solution
 
mlmccCommented:
Does the "userid" the report runs under have database permissions?

mlmcc
0
 
BrianMackAuthor Commented:
It's my Id. It should.
0
 
mlmccCommented:
Are you sure.  Generally scheduled reports run under a generic id not a specific users.  I don't use BO Enterprise so it may do it that way.  Does it only run when you are logged in?

mlmcc

0
 
BrianMackAuthor Commented:
I think that was the problem.  I logged in as administrator and scheduled the job and it worked fine.  Thanks
0
 
mlmccCommented:
Glad i could help

mlmcc
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now