Solved

Dtabase object error-

Posted on 2006-06-24
5
584 Views
Last Modified: 2009-08-04
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
Comment
Question by:BrianMack
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 100

Expert Comment

by:mlmcc
ID: 16976984
Does the "userid" the report runs under have database permissions?

mlmcc
0
 

Author Comment

by:BrianMack
ID: 16977141
It's my Id. It should.
0
 
LVL 100

Accepted Solution

by:
mlmcc earned 125 total points
ID: 16977234
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
 

Author Comment

by:BrianMack
ID: 16985880
I think that was the problem.  I logged in as administrator and scheduled the job and it worked fine.  Thanks
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 16989485
Glad i could help

mlmcc
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…
This video shows how to use Hyena, from SystemTools Software, to update 100 user accounts from an external text file. View in 1080p for best video quality.

751 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question