Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
Filtering the records in a report using a Parameter field lets you focus on the data that is most important to you. So far in this chapter I have shown you how to define a single-value Parameter field. In this movie I will show you how to define Parameter fields that let you select multiple values at the same time. This report contains an existing Parameter field called Quarter. It is over here in the Field Explorer. If you do not see the Field Explorer, you can go up to the standard toolbar and click the Field Explorer button to display it. As currently configured, the Parameter field only allows a single value, so I want to go in and change it.
If you need to review how to create a Parameter field you can go back to the first movie in this chapter. But for now, I will click Quarter, which is the Parameter field, and then click the Edit button. Just too quickly look at what the Parameter field is, it's named Quarter and is of Type Number--in other words, it contains numeric values--and it is a static list which I entered here in the Value list. So now what I want to do is allow multiple selections at the same time.
To do that, I will go in to the Value Options area and scroll down and here it says Allow multiple values. I will click over on the side of the line where it says False. This displays a list, and I am going to change that property's setting to True and then click OK. So now when they enter Values Dialog Box appears, like it did in previous movies, we can select multiple values. So if I wanted to see only the data for quarters 2 and 3, I could click 2 and then click the Add button. And then the highlight moved down to 3 automatically, so I will click Add, so we have 2 and 3.
If I wanted to remove one of those values, I could select it and click Remove or to remove all of them, I could click All. But I do want to look at 2 and 3, have that as my filter, so I can click OK. And when I do, data for Quarters 2 and 3 appear inside the body of the report. If Crystal Reports displays a dialog box asking you either to identify the data source or to make a connection, then you can connect to the call data file using the techniques that you've learned elsewhere in this course.
Letting users select multiple values in a Parameter field gives them the power to display just the data they are interested in. Rather than go into one value at a time and try to keep the numbers in their head when they change the Parameter value, multiple values puts all of the data in the report at one time.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 97510 Viewers
80 Video lessons · 141053 Viewers
59 Video lessons · 59403 Viewers
52 Video lessons · 72725 Viewers
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.