crystal report database expert connection with domain

Question

User988538322 posted

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

http://missoultions.com/ShowCWFee.aspx

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

("Server=199.193.116.14;Database=cdf;Uid=misdb;Password=mis;")

thanks

Answer 1

User-578610739 posted

Hi Dear,

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 .

http://publib.boulder.ibm.com/infocenter/iadthelp/v6r0/index.jsp?topic=/com.businessobjects.integration.eclipse.doc.crdesigner/reportdesigner/crtskchangingthedatasourcelocation.htm 

http://stackoverflow.com/questions/4932548/unable-to-change-data-source-in-crystal-reports-9

http://scn.sap.com/thread/1692934 

http://www.softwareforces.com/Support/Learning-Center/Step-by-Step/rpt-Inspector/Changing-Data-source-and-Database-Crystal-Reports-Dev-to-QA-to-Production

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.

Answer 2

User-1151753377 posted

Hi NewProgramer,

Thank you for your post.

There is an article about using Crystal Report, it will give you details explains.

http://www.aspsnippets.com/Articles/ASPNet-Report-Viewer-control-Tutorial-with-example.aspx

Regards & Summer