I want to use my database on SQL Azure in Crystal Report. So I want to link my reports with data contained not in a local db, but in a SQL Azure one.
Insiede Crystal Report I have created a new ADO connection to my SQL Azure, providing server, db, user, password, and Crystal Report have recognized the database. But when I go to the Database Expert and I try to set this ADO connection inside my report,
I recieve this error:
L'operazione richiesta non è supportata dall'oggetto o dal provider (operation not supported by the object or by the provider)"
Why? How can i use my SQL Azure data in my Crystal Report reports?