C#中的水晶报表 [英] crystal reports in C#

问题描述

你好，

我正在Windows应用程序中使用Crystal Report.并基于发票(表的列)从数据库表中检索数据，但是当我通过发票时，它无法显示存储在表中的所有数据.我如何防止它.........我只希望由我传递的那些行

解决方案

但是当我传递发票时可以显示存储在表中的所有数据
从数据库中获取与特定发票编号相关的数据.

在查询的WHERE子句中使用运行时参数，该参数为报表带来数据.运行报表时，此运行时参数为InvoicNo.传递输入的发票编号以查询并取回特定数据.

如果需要，请参考:
pass-crystalreport-parameters [ pass-parameters-to-crystal-reports [ ^ ]
在运行时将参数传递给Crystal Reports [ ^ ]

hello,

i am using crystal report in windows application.and retrieving data from database table on the basis of invoice(column of a table) but when i am passing the invoice no it can be shown all the data which is stored in table. how i am prevent it.......i want only those row which is passed by me

解决方案

but when i am passing the invoice no it can be shown all the data which is stored in table
Fetch the data from database related to a particular invoice number.

Use a runtime parameter for WHERE clause of your query that brings data for report. This runtime parameter is InvoicNo defined at the time you run the report. Pass on the invoice number entered to query and get back specific data.

If needed, refer:
pass-crystalreport-parameters[^]
pass-parameters-to-crystal-reports[^]
Passing Parameters to Crystal Reports at Runtime[^]

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