Smart questions
Smart answers
Smart people
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login
Remember Me
Forgot Password?
Join Us!

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!
  • 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!
Join Tek-Tips
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

LINK TO THIS FORUM!

Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.
Just copy and paste the
code below into your site.

Tek-Tips LinkedIn® Group

Partner With Us!

"Best Of Breed" Forums Add Stickiness To Your Site
Partner Button
(Download This Button Today!)

Feedback

"...I am so glad that I found your site, it is an excellent resource and has helped me greatly..."
More...

Geography

Where in the world do Tek-Tips members come from?
Click Here To Find Out!

Tek-Tips Shirts!

Get Tek-Tips Swag
Get your
Tek-Tips Forums
SWAG here!
Home > Forums > Enterprise Applications > ERP and CRM Solution Vendors > ACCPAC Solutions Forum

AR Invoice and sub reports

thread631-1684703
Read More Threads Like This One
Deborahza (TechnicalUser)
1 Jun 12 7:35
Hi,

The ARDINVO report was modified to add optional fields on a sub report by a old colleague.
Saved a copy, re-set the datasource locations on the main and sub report.
When I run the report in crystal it brings back the invoices but when I run it through Accpac I get "The table 'ARIBDO' cannot be found. If I delete the sub report - it runs through Accpac so I'm assuming it has something to do with the links. Any idea's?

TYIA
Debbie
tuba2007 (Programmer)
1 Jun 12 8:47
What version of Accpac are you running?
Deborahza (TechnicalUser)
4 Jun 12 11:03
It's MSSQL 2005 and A4W5.5
And using Crystal 11
DjangMan (Programmer)
4 Jun 12 13:29
How are you adding the table to the report? You'll want to use the way driver that the main report uses otherwise Accpac might not be able to change the path when it invokes the report.
Deborahza (TechnicalUser)
5 Jun 12 3:38
Ok I made a boo boo, it's 5.6
It's on the test server we are using to test the 5.6. upgrades and integrations to our fuel system.
The main and sub report are using the same ODBC driver. We have tried running just the sub report with only the ARIBDO table and we still get the same error.

TYIA
Debbie
Deborahza (TechnicalUser)
5 Jun 12 5:14
I have tried running it on my laptop now and it works. So I am re-installing AR on the 5.6 test server and will see if that makes a difference.
ettienne (TechnicalUser)
5 Jun 12 7:35
Are you using the version 5.5 report with version 5.6?
Deborahza (TechnicalUser)
7 Jun 12 8:23
No. It's the ARDINVO report in the 5.6 folder that has a sub report added.
Ran a repair on the Accpac instead of re-installing and it still gives me the error on our server. Yet it works on my laptop through crystal and Accpac.
Deborahza (TechnicalUser)
7 Jun 12 8:26
If I do copy it into 5.6 and use it, get the same error
ettienne (TechnicalUser)
7 Jun 12 9:10
It can only be something you are doing wrong, I've added subreports to 100s of these reports without any problems. Without seeing your report it would be almost impossible to say what is wrong.
tuba2007 (Programmer)
7 Jun 12 9:43
Ditto here. You're making a basic mistake, like using OLE instead of ODBC.
Read More Threads Like This One

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!

Back To Forum

Back To ACCPAC Solutions

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