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
Solved

Dtabase object error-

Posted on 2006-06-24
5
582 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
  • 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: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

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

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
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 …
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…

807 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