CR-XI R2 SP2 throwing Invalid Argument provided

building reports crystal reports
1

Has anyone seen an error specific to SP2 (I have a CR-XI R2 install where this report works) where CR (and BOE XI R2 SP2) returns an Invalid Argument Provided?

The report joins 3 tables from an ODBC Provider (all inner joins) and one table from an OLE DB provider (SQL Server - outer join to one of the ODBC tables).

If I remove one of the tables on the ODBC Source, the report runs without issue. I had another report that was doing the same thing - 4 tables using the same ODBC driver as above, but one table was aspecified as a command. We were able to swtich back to a standard table and join accordingly, eliminating the command.

kirkdj (BOB member since 2007-01-17)

2

Hi,

I am also facing the same error. I faced this frequently but did not get any resolution as such.

Can you please let me know if you get any solution or cause on the same.

Thanks in advance.

Mandar_Deshpande :us: (BOB member since 2005-05-16)

3

Hello,
If either of you figured this one out, could you post an answer? I’m running into the same thing.

Thanks.

JonTarz :us: (BOB member since 2006-01-09)

4

I am facing the same issue in Crystal 2008. I have a report which has multiple commands and they are joined together and we are recieving this error. Did anyone encounter this.

Thanks
Vijay

Vijay K (BOB member since 2004-01-15)

5

Try to use only one type of connection either ODBC or OLEDB or use one Command. If you more than one command, then it will not work.

jayad (BOB member since 2008-07-11)