具有两个或多个数据库的Crystal报表 [英] Crystal Report With Two or more Database

问题描述

你好朋友
我正在使用两个数据库，一个是母版，其静态是另一个，另一个是流程数据库，其更改与会计年度有关.现在，我想一次连接两个数据库，并一次在Crystal Report中查看两个数据库的值...

我正在等待您的回复




谢谢

Hello Friends
I am Using Two Database One is Master Page its Static Another one is Process Database its change Related to Accounting Year ....Now i wanna connect two database at a time and view two database value at a time in crystal Report...

I am Waiting for your Reply




Thank you

推荐答案

此资源处的解决方案应该可以帮助您
http://businessintelligence.ittoolbox.com/documents/build-crystal- report-against-two-database-sources-13024 [ ^ ].

The solution at this resource should help you out
http://businessintelligence.ittoolbox.com/documents/build-crystal-report-against-two-database-sources-13024[^].

嘿，
一种解决方案是，如果您使用的是sql server，则可以在查询中从不同的数据库中获取数据

为此请阅读本文

http://stackoverflow.com/questions/1144051/selecting-数据来自两个不同服务器的SQL Server [ http://msdn.microsoft.com/en-us/library/ms190479.aspx [ ^ ]

为此查询创建存储过程，并
将其用于水晶报表设计模式
希望这个技巧对您有帮助

谢谢你编码愉快

hey,
one solution is that if you are using sql server you can get data from different databases in query

for this read this articles

http://stackoverflow.com/questions/1144051/selecting-data-from-two-different-servers-in-sql-server[^]


http://msdn.microsoft.com/en-us/library/ms190479.aspx[^]

create stored procedure for this query and
use it into crystal report design mode
hope this trick will help you

thank you have happy coding

这篇关于具有两个或多个数据库的Crystal报表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！