Display record based on condition in ASP.Net Crystal Report

Question

I am displaying records in Crystal Report from HeaderTable and LinesTableThese tables are linked with ID field In LinesTable there is field statusIts values are 1 2 3 and 4 I want to show the only status2 records in Crystal Report How I will do itPlease suggest me

dharmendr · Accepted Answer

In the select query apply where condition to fill the dataset with record having status2

dharmendr · Answer

Hi  IkramshamsCheck this example Now please take its reference and correct your codeIn this example i am displaying records having Country with value USADatabaseFor this example I have used of Northwind database that you can download using the link given belowDownload Northwind DatabaseHTMLltCRCrystalReportViewer ID34CrystalReportViewer134 runat34server34 AutoDataBind34true34 gtNamespacesCusing SystemDatausing SystemConfigurationusing SystemDataSqlClientusing CrystalDecisionsCrystalReportsEngineVBNetImports SystemDataImports SystemConfigurationImports SystemDataSqlClientImports CrystalDecisionsCrystalReportsEngineCodeCprotected void PageLoadobject sender EventArgs e    ReportDocument crystalReport  new ReportDocument    crystalReportLoadServerMapPath34CustomerReportrpt34    Customers dsCustomers  GetData34SELECT  FROM Customers WHERE Country  39USA3934    crystalReportSetDataSourcedsCustomer

Display record based on condition in ASP.Net Crystal Report

Company

Explore

Follow us

Contact Us