在水晶报告中过滤结果 [英] filtering the results in crystal report

问题描述

如何过滤水晶报告的结果？我将为此代码添加什么？我将把SELECT语句放在哪里？谢谢！

how can i filter the results of crystal report? what will I add to this code? where will I put SELECT statement? thanks!

Dim crReportDocument As PhysicalCount
       Dim crDatabase As Database
       Dim crTables As Tables
       Dim crTable As Table
       Dim crTableLogOnInfo As TableLogOnInfo
       Dim crConnectionInfo As ConnectionInfo


       crReportDocument = New PhysicalCount ' Report Name



       crConnectionInfo = New ConnectionInfo
       With crConnectionInfo
           .ServerName = "servername"
           .DatabaseName = "dbName"
           .UserID = "sa"
           .Password = "pw"
       End With



       crDatabase = crReportDocument.Database
       crTables = crDatabase.Tables



       For Each crTable In crTables
           crTableLogOnInfo = crTable.LogOnInfo
           crTableLogOnInfo.ConnectionInfo = crConnectionInfo
           crTable.ApplyLogOnInfo(crTableLogOnInfo)
       Next


       CrystalReportViewer1.ReportSource = crReportDocument

推荐答案

使用参数字段，检查这些样本

C# Crystal Reports字符串参数 [ ^ ]

C# Crystal Reports Integer参数 [ ^ ]

C# Crystal Reports日期参数 [ ^ ]

C＃Crystal Reports - 迄今为止的日期 [ ^ ]

Use parameter fields, check these samples
C# Crystal Reports String parameter[^]
C# Crystal Reports Integer parameter[^]
C# Crystal Reports Date parameter[^]
C# Crystal Reports - Date to Date[^]

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