水晶报表问题请帮忙 [英] Crystal Report Problem Please Help

问题描述

我正在使用存储过程来填充水晶报表，但是我在报表上得到重复(重复)的信息-大约66页而不是至少2页.我想为特定用户生成一个交易声明，使用水晶报表，存储过程从多个表中获取数据，并接受特定客户端(用户)的名称作为参数.我是出于良好目的使用Crystal报表，还是存储过程不只是一种处理方式?
[confused]

I''m using a stored procedure to populate a crystal report, But I get repeatative(duplicated) information on my report- something like 66 pages instead of atleast 2. I want to produce a transactions statement for a particular user, using the crystal report, with the stored procedure getting data from multiple tables, accepting as a parameter the name of a particular client(user). Am I using the crystal report for good purpose or may be the stored procedure isn''t just a way of doing it?
[confused]

推荐答案

您应该能够将存储过程用作Crystal报表的数据源.

1)验证当您在crystal之外执行sproc时，它将返回正确的行数.
2)确保您没有在crystal中执行某些联接，这会给您太多意外行.

我的愿景是因为sproc将返回生成报告所需的所有数据，而您不必连接到其他任何表以获取参考数据(例如用户的名字，姓氏等)，这将使报告的设计非​​常简单.

希望这会有所帮助. [竖起大拇指]

You should be able to use a stored procedure as the datasource for a Crystal report.

1) Verify that when you execute the sproc outside of crystal it is returning the correct number of rows.
2) Make sure you are not performing some join in crystal which is giving you too many unexpected row.

My vision would be that the sproc would return all of the data necessary to generate the report and you would not have to join to any other table for reference data (like user first name, last name, etc), this would make designing the report very straight forward.

Hope this helps. [thumbs up]

这篇关于水晶报表问题请帮忙的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！