Last post Mar 17, 2015 05:59 AM by Summer - MSFT
May 31, 2014 01:22 AM|NewProgramer|LINK
i have a windows domain and i create a database in control panel and upload my Project. Every thing is ok but when i want to show crystal report error comes you can see
1 i create a store procedure in Database 2 connect in database expert from OLEDB Connection Provider for SQL Server 3 when i locally run, no error come but when i connect to domain server report do not show.
also i want to know how can i connect from crystal report database expert to Domain server database.
this is my Connection string
May 31, 2014 07:34 AM|Ajay2707|LINK
Above link is not working.
So as per your description,
1. first check your domain server database with sqlserver management studio(SSMS), if this is ok.
2. So now you are able to connect via ssms, so second option is connect crystal report to domain server db. Here is you just open the report and click menu:
Database - > Set Datasource Location .
One thing to be sure, that both (local and domain) server have same table or sp structure and datatype. If there is mismatch of current database and updated database , it will prompt and not update. Other wise it will update and when you click ok, it preview
the data. After check simply deploy the report at server location.
Now this is fine. So check with browser with the data you know already at preview. If that is not display , then same data you entered in crystal report directly and check with same database connection.
Mar 17, 2015 05:59 AM|Summer - MSFT|LINK
Thank you for your post.
There is an article about using Crystal Report, it will give you details explains.
Regards & Summer