Can Anyone HELP!!!!!!!! w/ Crystal

[ralphtg]

I need help with a report that will not run and at one point it did. I did not creat this report and i am not that familiar with crystal reports or SQL.
It is a crystal report with a mas 90 database and an access database file. i had to change servers and when i installed on new server certain reports did not run only the ones that were involved with this access database file.
the old server was nt4 server the new one has win200 pro.
the error i am getting is
ODBC error canada][PVX ODBC driver][FILEIO] Table is not accessible
i hit ok and this is the second part
error detected by database dll

---------this is the SQL query -----------

SELECT
ARO_InvHistoryDetail."InvoiceNumber", ARO_InvHistoryDetail."SOCommentCode", ARO_InvHistoryDetail."SOCommentCodeDescLine1", ARO_InvHistoryDetail."SOCommentCodeDescLine2",
ARN_InvHistoryHeader."InvoiceType", ARN_InvHistoryHeader."InvoiceDate", ARN_InvHistoryHeader."CustomerNumber"
FROM
"ARO_InvHistoryDetail" ARO_InvHistoryDetail,
"ARN_InvHistoryHeader" ARN_InvHistoryHeader
WHERE
ARO_InvHistoryDetail."InvoiceNumber" = ARN_InvHistoryHeader."InvoiceNumber" AND
ARO_InvHistoryDetail."HeaderSeqNumber" = ARN_InvHistoryHeader."HeaderSeqNumber" AND
ARN_InvHistoryHeader."InvoiceType" = 'C' AND
ARN_InvHistoryHeader."CustomerNumber" <> '0095440' AND
ARO_InvHistoryDetail."SOCommentCode" = '/C' AND
ARN_InvHistoryHeader."InvoiceDate" >= ? AND
ARN_InvHistoryHeader."InvoiceDate" <= ?


----------And this is the selection formula-----------

{ARN_InvHistoryHeader.InvoiceType} = "C" and
{@problem} in ["40", "39", "38", "37", "36", "35", "34", "33", "24", "23", "22", "21", "20", "19", "18", "17", "16", "15", "14", "13", "08", "07", "06", "05"] and
{ARN_InvHistoryHeader.CustomerNumber} <> "0095440" and
{ARO_InvHistoryDetail.SOCommentCode} = "/C" and
{ARN_InvHistoryHeader.InvoiceDate} in Date (2003, 11, 30) to Date (2004, 01, 03)


any hellp with this would be greatly appreciated
thanks ralph

 

[synapsevampire]

Some basics are in order.

How are these reports being executed, from within Crystal Reports? Crystal Enterprise? 3rd party software?

Are you stating the exact error returned?

I would try the set location for each table in the report, it sounds like you're using BOTH a MAS 90 database and a Access table in the same report, and the MAS 90 driver (assume the PVX is it) isn't finding the tables.

-k

 

[ralphtg]

i am trying to use crystal reports to open the file. it is crystal version 7. yes that is the exact error.
when i use both databases after i add the second database it says
"More than one datasource or stored procedure has been used in this report. please make sure that no sql expression is added and no server-side group-by is performed"

but than it just gives me the same error as before.
i am not sure what to do and i need this report as soon as possible so if anyone has any guesses please respond.
thank you
ralph