I have new report that has more than one data source. I can run the report on my network and can upload via "publish to crystalreports.com". When I am trying to set open data connection it's saying "open data uri could not be set. Please try again".
Version 1 of the Open Data Connector does not support reports with multiple data sources. When a user attempts to upload a report that contains multiple data sources AND checks the ODC option, they will receive an error message.
Users may still upload the report, but cannot select the ODC option. Please note: reports using more than 1 stored procedure or reports that contain a table and stored procedure are treated as a multiple data source report and are NOT supported with the ODC.
Reports published using the Open data Connector should be based off a single data source. It is also possible to save the report without the data connection and use the Desktop Publisher to schedule recurring reports with the freshest data.
KBA , BI-OD-CR , CrystalReports.com , Problem