在没有 Crystal Reports Server 的情况下在 Crystal Reports 之间共享功能?
我们有几个执行相同格式化操作的报表(例如,如果某个值在特定范围内,则显示“PASS”或“FAIL”。)
如果没有 Crystal Reports Server,是否有一种方法可以在报表之间共享功能,以便它们不需要被复制?我知道我可以使用用户函数库来做到这一点,但我不想将所有水晶函数移植到 UFL。
使用水晶报表 2008。
We have several reports that do the same formatting operations (e.g. displaying "PASS" or "FAIL" if a value is within a particular range.)
Without Crystal Reports Server, is there a way to share functions between reports so that they do not need to be duplicated? I understand I could do this with a user function library but I would prefer not to port all of the crystal functions to UFL.
Using Crystal Reports 2008.
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(2)
我知道的唯一其他选择是将函数移植到存储过程或数据库函数。这实际上是一个更好的实现(一般来说),因为 Crystal Reports 客户端处理比 SQL Server 慢得多。因此,您的通过或失败将成为一个函数或存储过程,甚至在选择查询中使用 case 语句。
使用 Crystal 报告的良好经验法则是,在将数据集返回到 Crystal 之前尽可能地展平数据集。这将允许您在依赖客户端进行处理之前使用数据库服务器的功能。完美的示例是向客户端返回 100 万行,但将其展平为仅显示 5 个组的总计。 Crystal 在处理总数之前会因获取 100 万行而窒息。
The only other option I know would be to port the functions to Stored Procedures or Database Functions. This is actually a better implementation (in general) as the Crystal Reports Client Processing is much slower than the SQL Server. so your pass or fail would become a function or stored proc or even the use of a case statment in the Select Query.
Good rule of thumb with crystal reports, flatten out the dataset as much as possible before returning the dataset to Crystal. This will allow you to use the power of the Database server before relying on the Client to handle the processing. The perfect example is to return 1 million rows to the client but flatten it out to only displaying totals from 5 groups. Crystal will choke on the fetching of 1 million rows before it can process the totals.
我记得早期版本的 CR 支持 共享存储库 除了通过 BusinessObjects(nee Crystal Decisions)Enterprise 提供的存储库之外。
我在 XI+ 版本中没有发现任何提及类似的功能(即共享的非 BOE 存储库)。
I recall that earlier version of CR support the notion of a shared repository in addition to the repository that is available via BusinessObjects (nee Crystal Decisions) Enterprise.
I haven't found any mention of similar functionality (meaning a shared, non-BOE repository) in version XI+.