动态加载Crystal Report [多个数据库] [英] Crystal Report Load Dynamically [More than one database]

问题描述

我已经完成了可动态加载并显示由SQL查询指定的数据的Crystal报表.

我已将MS ACCESS(.mdb)用作数据库.

在我的一份水晶报告中，我使用了来自多个数据库的字段
(两个不同的.mdb文件)


在connectionInfo中，我可以指定.mdb数据库的路径以及用户名和密码，但是如何引用两个Datbases

Hi,

I have done with crystal reports which loads dynamically and displays the Data specified by SQL query.

I have used MS ACCESS (.mdb) as Database.

In one of the my crystal reports I have used the fields from more than one databases
(two different .mdb files)


in connectionInfo, I can Specify the path of my .mdb database along with username and password but how can I reffer to TWO Datbases

推荐答案

如果是SQL Server，我''d在Database1中创建了一个视图，该视图从Database2中选择了一个表(使用链接服务器).然后，我将使用视图"作为报告的数据源.我不知道MS Access是否具有等效功能，只是给您入门的提示.

If it were SQL Server, I''d have created a View in Database1 that selects a table from Database2 (using Linked server). I''d then use the View as the datasource for the report. I do not know if MS Access has an equivalent, just a tip for you to get started.

< u></u>我已经完成:

在现有数据库中创建新表
然后从另一个数据库的表中插入该表中
并生成报告后
我已经删除了表

<u></u>I have done:

create new table in existing database
then insert into that table from table from another database
and after generating the reports
I have deleted the table

我建​​议您在Crystal报表中使用PUSH方法.您可以从任何地方获取数据&然后您就可以将数据传递给报告了，仅此而已.此外，它还可以减轻许多麻烦，例如运行时登录详细信息，超时错误等，

使用ASP.NET的Crystal Reports PUSH方法 [使用.NET的CrystalReports推送模型 [使用.NET中的Push方法创建Crystal报表 [ ^ ]
创建推送模型Crystal报表 [

I recommend you to use PUSH method in crystal reports. You can get data from anywhere & then you can pass the data to the reports, that''s all. Also it''ll reduce many headaches like runtime Logon details, timeout error, etc.,

Crystal Reports PUSH method using ASP.NET[^]
CrystalReports Push Model with .NET[^]
Creating Crystal Reports Using the Push Method in .NET[^]
Create a Push Model Crystal Report[^]

这篇关于动态加载Crystal Report [多个数据库]的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！