水晶报表帮助
我设置了一个 Crystal Report 来与我的 Windows 窗体应用程序一起运行。
我将一个字符串传递给报告的 SelectionFormula。
我正在做的是：
我有3个表-StockFile、BranchFile和Supplier
当该项目添加到分支库存时，会创建一个库存项目，一个项目可以在分支之间移动，直到它被出售，所以可以有许多记录库存文件表。
我想要做的是创建一个回调报告：
[BranchFile].[BranchName], [BranchFile}.[BranchName], [Supplier].[SupplierName], (RTRIM([StockFile].[DESCRIPTION_LINE_1]) + '/' + RTRIM([StockFile].[DESCRIPTION_LINE_2]) + '/' + RTRIM([StockFile].[USER_ENTERED_DATA])) AS DESCRIPTION, [StockFile].[StockCode], [StockFile].[Size], [StockFile].[Weight], [StockFile].[CreationDate], [StockFile].[RetailPrice], [StockFile].[AssignedBranchQty]
我希望返回符合以下条件的数据：
(min([StockFile].[CreationDate]) <= '2009-08-01') AND [StockFile]。 [CreationDate] <= '2010-08-23' AND [StockFile].[AssignedBranchQty] <> 0
我可以管理除 min() 部分之外的所有内容。
请有人帮忙，我可以使用选择公式来实现这一点吗？？？
谢谢
I have a Crystal Report set up to run with my windows forms application.
I am passing a string to the SelectionFormula of the report.
What I am doing is:
I have 3 tables - StockFile, BranchFile and Supplier
A Stock item is created when that item is added to branch stock, an item can be moved around branches until it is sold, so can have a number of records in the stockfile table.
What I want to do is create a report which pulls back:
[BranchFile].[BranchName], [BranchFile}.[BranchName], [Supplier].[SupplierName], (RTRIM([StockFile].[DESCRIPTION_LINE_1]) + '/' + RTRIM([StockFile].[DESCRIPTION_LINE_2]) + '/' + RTRIM([StockFile].[USER_ENTERED_DATA])) AS DESCRIPTION, [StockFile].[StockCode], [StockFile].[Size], [StockFile].[Weight], [StockFile].[CreationDate], [StockFile].[RetailPrice], [StockFile].[AssignedBranchQty]
I want this data returned for the following criteria:
(min([StockFile].[CreationDate]) <= '2009-08-01') AND [StockFile].[CreationDate] <= '2010-08-23' AND [StockFile].[AssignedBranchQty] <> 0
I can manage everything apart from the min() part.
Please can someone help, Can I achieve this using the SelectionFormula???
Thank You
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
一般来说，尽量减少在 Crystal 和 Winforms 应用程序中执行的 SQL 工作量。
在执行 SQL 工作的后端创建查询或视图，使用 Winforms 应用程序输入日期参数或需要应用于查询的任何其他限制条件，并在 Crystal 中应用该条件。
与在 UI 或报告工具中相比，在后端使用 SQL 会容易得多。
In general, try to minimize the amount of SQL work you do in Crystal and your Winforms app.
Create a query or view on your back end doing the SQL work, use your Winforms app for the data entry of date parameters or whatever other limiting criteria you need to apply to the query, and apply the criteria within Crystal.
It will be much easier to work with SQL on the back end compared to within the UI or reporting tool.