![crystal report 10 multiple value parameter field crystal report 10 multiple value parameter field](https://content.spiceworksstatic.com/service.community/p/post_images/0000275920/59e66b87/attached_image/showquery.png)
You can close Selection Formula Editor screen after creating selection formula.
#Crystal report 10 multiple value parameter field how to#
Double click each field then it will be selected.įorm the following picture you can understand how to select fields. įirst you have to select OrderMaster.OrderMaster_customername from Report Field and select the comparison operator and select the parameter field. For creating selection formula, you have to select the fields from above field list and make the formula. Now you can see the record Selection Formula Editor Screen. Select Parameter Field from Field Explorer and right Click on Parameter Field.įill the appropriate name for Name and Prompting text fields like the following picture.Īfter creating the parameter field, we have to create the selection formula for the Crystal Reports parameter.įor creating selection formula, Right click on Crystal Reports designer window, select REPORT -> SELECTION FORMULA -> RECORD. Then you can see Field Explorer in the Left hand side. (Up to here explained in detail in the previous section C# Crystal Reports from multiple tables). Select the Field Explorer from CrystalReport Menu.
![crystal report 10 multiple value parameter field crystal report 10 multiple value parameter field](https://www.tutorialspoint.com/crystal_reports/images/cross_tab.jpg)
Next step is to create a String parameter in Crystal report designer window. Hope you understand the previous section well, if not, please click here C# Crystal Reports from multiple tables. In this section we pull out the selected customer report only by passing Customer name as argument. In the previous section we are getting the report of all orders from all customers, that is, all orders placed by all customers. Before starting to this section just take a look at the previous section C# Crystal Reports from multiple tables. This program is the continuation of previous tutorial, the only difference is that we pass a Customer Name as String parameter and get the report of that particular Customer only. In the previous tutorial we saw how to generate a C# - Crystal Reports from multiple tables. For example, from C# program we pass a customer name as a parameter and show all the orders of that customer to the Crystal Reports. Here we pass a String parameter from C# to Crystal Reports.
![crystal report 10 multiple value parameter field crystal report 10 multiple value parameter field](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/26497691/original/blob1455634632728.png)
If you are new to Crystal Reports and do not know how to create Crystal Reports from C#, please take a look at the section step by step tutorial for creating a Crystal Reports from C#. So before you begin this section, please take a look at the database structure of crystaldb - Click Here C# crystaldb The following section describes how to pass a String parameter to Crystal Reports from C# application.Īll C# Crystal Reports Tutorial in this website is based on the following database - crystaldb.