Crystal Reports 2008 error: Invalid Argument Provided

[Former Member]

Hi all,

I am getting the following error message which is very easy for me to recreate:

Invalid Argument Provided.

Details: The alias requested 'Command', contains a combination of characters which is not considered to be valid.

Here are the sequence of events to cause the error:

1- create a new report

2- click 'add command' and enter a very simple SQL like (or something equally simple to you):

SELECT RecDate, Operator FROM TBL_Transactions WHERE InstNum = '2008056125'

3- click OK to add the command to the Selected Tables list

4- right click the command and click edit

5- click OK right away--it is not necessary to actually change the SQL

6- the error message above will then pop up

Here is my product information:

Crystal Reports 2008

CR Developer

Version 12.0.0.796

Product Type: Full

Can anyone else recreate the error message? If you cannot recreate the error, what is your version? Because of this error, CR 2008 is unusable for about half of my reports. I did not/do not have this problem in Crystal Reports XI.

Thanks in advance for your help!

Larry

[Former Member · Accepted solution]

But Amr, if I delete the Add Command, then all of the fields on my report will be deleted. It is then too late to add a new SQL (or am I missing something??)

Also, how do I open a case with suppport? Before SAP bought Business Objects, I knew how to do that--in fact, this problem would have been solved long ago if we had the old system.

Thanks again for your very helpful support!

Larry

[amrsalem1983 · Accepted solution]

yes you are right, all the fields will be deleted,

but i'm telling you,

you can try this in another new report, and test the issue

and for sure you can get your support from SAP, they sent an Email to all the ppl, and explained how you get your customer ID and how to loging to the support portal.

i think you can handle that, its has been posted in this forum before too, search for it.

good luck Larry

[Former Member]

Thanks Amr, That is why I chose a simple SQLit runs in MySQL query browser. It is also quite a confusing problem because I did not have this problem in CR XI. And I am still running the same reports and SQLs now as thenonly now I cannot make a change to the SQL statement at all. If anyone else is using MySQL database, I would love to hear from you whether or not you are having this problem.

Many thanks,

Larry

[amrsalem1983]

Larry, i got your error, you are right, i did that to mySQL database

here is the issue,

when you create Add Command and you try to edit it, it gives you the error,

how to fix it,

delete the add command, and add another one, but write the full statement, and dont try to edit it,

and open a case with the support.

good luck

let me know if this works fine with you

[Former Member]

MySQL. I am connecting with an ODBC connection.

Larry

[amrsalem1983]

actually i've used "Add Command" option many times before

and it never show such error for me.

try to be sure of the connection parameters, and try to execute the same SQL statment in the database itself MYSQL

good luck

[Former Member]

Thanks Amr for your response. The quotes do not play a part in the problem. I can leave them out, but I have the same results. Were you able to recreate the error using a simple SQL of your own?

Thanks,

Larry

[amrsalem1983]

whats your database vendor Larry?

i mean what database your target

[amrsalem1983]

Larry,

why you put ' around the number

try this SELECT RecDate, Operator FROM TBL_Transactions WHERE InstNum = 2008056125

without single quotation

good luck