CODEWITHSUNDEEP
mysqlvb.netcrystal-reports
Ein Hazard
Ein Hazard

Reputation: 93

Crystal Report on VB with a condition

I am using visual studio 2010 and mysql for database and crystal report for reporting.

I want to show report and filter it based on its category. I have tried this tutorial here : http://vb.net-informations.com/crystal-report/vb.net_crystal_report_parameter_string.htm

It works, but only if the parameter already been filled. What I want is, if the parameter empty then report will show all item, else report will show based on the parameter.

How do i do that ?

Here a little detail of my project :

Database field :

Parameter Name in crystal Report :

Field in visual studio :

Upvotes: 0

Views: 921

Answers (1)

Siva
Siva

Reputation: 9101

You need to add a condition in record selection formula..something like below

If parameter=""
Then
Category=category
Else
Category=parameter

Upvotes: 1

Related Questions