以编程方式更改crystal报表的sql查询 [英] changing the sql query of the crystal reports programmatically

问题描述

这最近一直在吞噬我。假设我设计了一个报告，选择Xtreme示例数据库中"Credit"表
的所有字段。现在，我可以使用报表中嵌入的查询轻松显示数据列。但是说
我想减少报告，并说我想显示Id = 1的客户的信用额度，或者说显示所有
信用额度超过500美元的客户。如何在不使用参数字段的情况下执行此操作。我可以更改报表中嵌入的
查询而不更改数据库字段，但可以通过编程方式更改
代码中的记录选择条件。真的需要你的帮助。

解决方案

为什么不使用带参数的存储过程？该参数的值可以用编程方式设置。

this has been eating me up lately. suppose i designed a report which selects all the fields of 'Credit' Table
in Xtreme sample database. now i can easily display the data columns using a query embedded in the report. but say
i want to cutomize the report and say i want to display the credit amount of customer with Id=1 or say display all
the customers with credit amount greater than $500. how can i do this without using paramter fields. can i change the
query embedded in the report without altering the database fields but altering the criteria of record selection fron the
code programmatically. really need ur help on this.

解决方案

Why not use a stored procedure with a parameter? The value for that parameter can be set programattically.

这篇关于以编程方式更改crystal报表的sql查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！