Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

RS 3.03 gets "Invalid Column" on RS 2.5 report

Status
Not open for further replies.
SteveMurphy

SteveMurphy

Programmer
Apr 15, 2004
2
US
Running report gives me "Invalid Column". The SQL has quotes around all columns/identifiers such as "LAWSON"."custorder"."Order_NBR" instead of LAWSON.custorder.Order_NBR. I remove the quotes, but then get "Missing parenthesis". I figured it had something to do with the date check (Ex. order_date between date1 and date2), so I removed that line. It ran, but just before returning data, I get an empty pop-up (no heading) saying "Invalid Directory". I click "OK" and get it again; I click "OK" and get "Internal Error: Problem creating IDAPI table". This happens when there are 3 or more tables involved. I'm going against a lawson 7.3.4 DB on an AIX unix box; I'm on Windows 98 PC.

Steve
 
Status
Not open for further replies.

Similar threads

cdrnys
  • Locked
  • Question
One user getting "Unable to open file" when running any report (ReportSmith 4.2)
Replies
0
Views
689
cdrnys
cdrnys
gebiggsy
  • Locked
  • Question
Report subtotals
Replies
0
Views
729
gebiggsy
gebiggsy
gebiggsy
  • Locked
  • Question
Report subtotals
Replies
0
Views
682
gebiggsy
gebiggsy
PITTUSER
  • Locked
  • Question
How do I use data from an Excel sheet in my Reportsmith report?
Replies
0
Views
752
PITTUSER
PITTUSER
nicofari64
  • Locked
  • Question
Strange problem with RS 3.0
Replies
3
Views
245
CharlesCook
CharlesCook

Part and Inventory Search

Sponsor

Back
Top