Error 0x80070057

[Former Member]

I created a report from a view. I did modifications in my view, then in the report.

The problem is when I click Refresh, the error 0x80070057 appear. No source, no description, only the error code.

How can I make this report usable without having to create a new report. You know, there is hours on it.

Thanks

Simon Ouellet

[Former Member · Accepted solution]

Simon could you please let us know if you are using any sub reports on this ? or are there any redundant formulas or parameters or running totals placed in that report?

Perhaps clicking on "Report--->Check Dependencies" might help you find the cause of this issue.

Regards

Jehanzeb

[Former Member · Accepted solution]

I found the problem. Due to the modification in my view, my parameter caused the error. I deleted selections and parameters in the report and sub-report (yes, there is one). I recreated them all and now it's working.

I did check my View and Set Datasource Location, but nothing changed.

I never though to use Check Dependencies. Next time, I'll do this. Thank you for the tip.

Simon Ouellet

[Former Member]

1) Were you able to point correctly to the new View.I assume that you must have used the 'Set datasource location' option under the 'Database' tab to point to the changed View.

2) Also, can you check at the databse end that the View is returning all and correct values as per the query.May be, a 'Select * from view_name' could help in testing this.

3) As a test,create a new report on this changed View and check whether it is getting refreshed.If it doesn't that means there is something wrong with the View(or the crystal is not able to interprete some syntax used in this view).

4) Again,as a test can you change the type of connectivity(i.e use oledb instead of odbc or native or vice-versa)

Let us know the database type and version,type of connectivity,version of crystal reports etc.

Thanks