Click here to Skip to main content
15,125,228 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Situation: Show all Records from a certain Table that has the same record in a row.
Question: How to show all records that has the same name in the textbox
Expected Output:

If a Name is input in a textbox
the crystal report will show all records that has the same name

is there some codes in the crystal report to do this?

What I have tried:

sql = "select * from Table 1 where Name=@Name"
Updated 19-Aug-21 20:32pm

1 solution

You can use parameters in Crystal. Have a look at Crystal Reports - Parameters[^]
Beginner213456 6-Sep-21 20:09pm
I used crystal report parameter. and you must type the data you wanted to be shown ,before opening the crystal report. which is a solution to my problem
i'm just wondering if there is a way similar to the parameter. so that you can input data you wanted while in the crystal report?
Wendelius 6-Sep-21 23:08pm
If I understand your question correctly, you want to set the value of the parameter from the application? If that's the case, you can use SetParameterValue. Here's a link to the version that was used with MS ReportDocument.SetParameterValue Method (String,Object,String) (CrystalDecisions.CrystalReports.Engine) | Microsoft Docs[^]
Beginner213456 8-Sep-21 5:10am
I mean, is there a way to input the data u want to be shown in runtime, like a search button in runtime crystal report.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900