如何在Crystal报表中将访问db更改为sql db？ [英] how to change access db to sql db in crystal report ?

问题描述

Hai



我在网站上对数据库进行了修改，实际上它将创建带访问（.mdb）文件，我将更改为sql server并且我更改编码，但在报告字段或仍在访问数据库中，我需要更改sql服务器而不更改链接，如果我删除访问（.mdb）连接所有字段都从晶体报告中删除，所以我需要更改Access连接到SQL服务器没有删除水晶报表中字段的连接。



如果我删除访问并更改连接到sql并再次将字段拖放到报表中它可以工作，但它有更多10水晶报告并在每个报告中使用超过5个表格，而且我也不创建带有访问数据库的水晶报告，因此我不知道每个报告的表格链接和字段。



唯一的方法是删除访问连接并连接sql server并需要使用拖动字段重新设计crystal report？ ？ ？



问候

Aravind

Hai

I have a modification in website for database,actually it will create with access(.mdb) file,i will change to sql server and i change coding ,but in report fields or still in access database,i need to change sql sever without changing the link ,if i remove access(.mdb)connection all fields are removed form crystal reports,so i need to change Access connection to SQL server connection without removing fields in crystal report.

if i remove access and change connection to sql and again drag and drop fields into report it works,but it have more 10 crystal reports and use more than 5 tables in each reports and also i am not create crystal report with access database , so i don't know table links and fields for each reports.

The only way is remove access connection and connect sql server and need to redesign crystal report with dragging fields ? ? ?

Regards
Aravind

推荐答案

Hi


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



或



http：// scn .sap.com / docs / DOC-41469 [ ^ ]

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

or

http://scn.sap.com/docs/DOC-41469[^]

这就是为什么要用 PUSH方法 [ ^ ]独立于后端



我从未尝试过这个但是检查这个已解决的帖子

在Windows窗体应用程序中更改运行时的数据源位置和类型 [ ^ ]

This is why should go with PUSH method[^] which is independent of backend

I never tried this but check this solved thread
Changing datasource location and type at runtime in a Windows Forms app[^]

这篇关于如何在Crystal报表中将访问db更改为sql db？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！