Hello jorie,
Its a Straight forward requirement, If my understanding is right you are expecting your report to display based on the radio Button you have selected. Recommend you to follow below Approach:
--> Declare the Radio Buttons, you can refer the BLOG only for reference.
--> To validate the selected Radio Button it is recommended to use CASE statements instead of IF ELSE statements.
--> Later based on the Radio Button You have to trigger the respective Select Statement, below I have given a Pseudo code for reference still there are many other ways to arrive at the solution.
1) Declare a Local Variable which if of type TABLE-FOOD field.
2) Now based on the radio button selected you can populate the Local Variable accordingly.
For Eg: If Radio Button 1 is Selected then Local Variable = Chicken
If Radio Button 2 is Selected then Local Variable = Hamburger
If Radio Button 3 is Selected then Local Variable = Pizza
3) Define a Single Select Statement where you will feed the Where condition with the local variable.
Select * from Table
where food = Local_Variable.
4) Finally Display the Values fetched using traditional Factory method.
For Sample programs there are plenty of resources available in net, recommend you to first try out with the available examples and come back to us for specific issues. This Will let us help you with solution specific Answers.
Start Coding first and reach out to us for issues, above details should definitely get you going.
All the Best!
Regards!
