Frequently asked Questions

Public write access is disabled. Please  login
open source crm Last post
user

CJKulit05
6 posts
---
Location:
Antipolo City
Philippines
08.03.2018 11:27

Joined Table on Crystal Report Error

Hi Team,

I'm getting an error message when i tried joined table on my RPT file. it works if the rpt file only referring to 1 table only. But when i have 2 or more tables, when im trying to load the report, i'm getting an error message:

Error?
Login failed.
Details: ADO Error Code: 0x
Source: Multi-Step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.
Error in File [temp file path].rpt: Unable to connect: incorrect log on parameters.

Please assist.
Thanks,

Edited by CJKulit05 - 08.03.2018 10:41




 
user

viennadeveloper
108 posts
---
Location:
n.a.
09.03.2018 13:18

Re: Joined Table on Crystal Report Error

Hello Chris,

For Joined table query you need not have to put the joined queries in SQL Query field but you need to create a view of joined query and update the sql query field like

select field1, field2, field3 from view1;

Regards'
viennadeveloper