水晶报表参数选择限制？ [英] Crystal Reports parameter selection limit?

问题描述

我试图从按用户分组的Oracle数据库中创建Crystal Reports 11报表。我有超过一千个用户。我想创建一个参数字段，提示用户选择要查看其结果的用户。但是，我的参数选择字段只显示221个可能的用户。由于SQL命令的Order By语句，用户按字母顺序显示。我想知道参数字段可以存储的动态默认值的数量是否有限制。

I'm trying to make a Crystal Reports 11 report off an Oracle database that's grouped by user. I've got over one thousand users. I want to create a parameter field that prompts the person to select which users they would like to view the results for. However my parameter selection field is only showing 221 of the possible users. The users appear in alphabetical order because of the SQL command's Order By statement. I'm wondering if there is a limit to the number of dynamic default values that a parameter field can store. Any help with this would be great.

推荐答案

Crystal 11中的默认限制显示为1000（保存在注册表项HKEY_LOCAL_MACHINE \SOFTWARE\Business Objects \Suite 11.0\Crystal Reports \DatabaseOptions\LOV\MaxRowsetRecords），因此您的问题可能在于参数字段本身的构造。确保它是一个动态参数字段，将在使用时查询数据库，因为显示的奇数个值使我认为这是报表首次运行和保存时生成的列表，因此是静态参数列表。

The default limit in Crystal 11 appears to be 1000 (held in the registry key HKEY_LOCAL_MACHINE\SOFTWARE\Business Objects\Suite 11.0\Crystal Reports\DatabaseOptions\LOV\MaxRowsetRecords), so your problem may lie in the construction of the parameter field itself. Make sure it is a dynamic parameter field that will query the database when used, as the odd number of values shown makes me think this was the list generated when the report was first run and saved, and therefore a static parameter list.

这篇关于水晶报表参数选择限制？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！