使用MS Access的多表Crystal Reports [英] Multi Table Crystal Reports using MS Access

问题描述

我正在寻找一个解决方案，我可以在单个水晶报告中使用5个表格。是否可以在单个语句中使用Multiple Select Query。请帮助我实现这一目标。我用Google搜索但没有发现任何与我的查询相关的内容。



感谢您的期待。



关注

Hi,

I am looking for a solution where i can use 5 table in a single crystal report. Is t possible using Multiple Select Query in a single statement. Please help me in achieving this. I googled but found nothing related to my query.

Thanks in anticipation.

Regards

推荐答案

您应该能够在同一个水晶报告中创建多个数据集。每个数据集都代表您希望从每个表中获取的数据。在这种情况下，一个带有多个select语句的SQL语句将不起作用。只需将select语句拆分为不同的数据集即可。我熟悉Crystal Reports 11.0和13.0，并且都允许这个功能。



此外，有时当你从Visual Studio打开Crystal Report时，它会抱怨为报告找到了多个数据源（或类似的东西），只需单击确定忽略它，在编译时，一切正常。

You should be able to create multiple datasets within the same crystal report. Each dataset would represent the data you'd like from each table. One SQL statement with multiple select statements will not work in this case. Just split your select statements into different datasets. I'm familiar with Crystal Reports 11.0 and 13.0, and both allow for this functionality.

Also, sometimes when you open the a Crystal Report from Visual Studio, it will complain that there are multiple data sources found for a report (or something like that), just click OK to ignore it and at compile time, everything works out just fine.

这篇关于使用MS Access的多表Crystal Reports的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！