Displaying records based on a condition
I have a table called payments which contains information related to payments made to a customer. The payments table has a field called payment type. I want to select payments of three different types. Lets call them type1, type2 and type3. I can select records of this type using the record filter.
In the report I am printing payments of the three types
Type 1 payment: Amount of type1 from the payments table
Type 2 payment: Amount of type2 from the payments table
Type 3 payment: Amount of type3 from the payments table
How do I select the appropriate record to match the kind of payment that I need to print in a specific spot on the report? Any help would be greatly appreciated?
You can define parameters to display records based on particular condition.
define parameters of dynamic type accoring to your condtion.
Insert parameters into report and the select expert record define the condtion on defined parameters.
Hope this will help you.