Crystal report filter update

These may or may not appear on our report. There may come a time that you sort your data, then realize that's not how you wanted it sorted. In fact, you may just want to revert back to the original sort order that appeared automatically when you created your report. If you have more fields in the Sort Fields section that you want to "unsort," follow the same steps to "unsort" those as well.

However, if you have more than one field in the Sort Fields section, you can remove the ones you want and leave the others if you want. Whereas sorting allows you to rearrange the data in a specified order, filtering allows you to control what data in your report you actually see. When you filter data, you establish filter criteria just as we did when we sorted data. You then filter the data by that criteria so that only the data you want to see appears on the report.

For example, if you only wanted to view customers who live in Texas, you would set criteria so that only customers living in Texas appear on your report. As with the Record Sort Expert, you can see that Crystal Reports shows us the fields in our report, then the tables in our data source.

As you can see above, the tab that is showing is for the field we selected in the last window, the City field. The choices in the dropdown menu are most likely choices you're familiar with when it comes to number values. However, we can also use them for text values. We want to filter by customers who live in Toronto and only Toronto, so we will choose "is equal to.

If we wanted, we could type in Toronto. We could also click the dropdown arrow to see all values in the City field. Crystal Reports asks if we want to use the saved data — or the data already in our data sources — or if we want to refresh the data so new data is included.

In the last section, we saw a slew of comparison operations that you can use to filter data in your report. They are shown again below. If we use the same filter criteria, we could choose "is not equal to. Is one of lets you create a list that you want to use to filter the data. Using our example, you would be able to choose multiple cities.

Is not one of lets you choose, using our example, multiple cities NOT to include in the filtered report. Is less than , when used in filtering text strings, will filter all results that come before the specified filter criteria — in alphabetical order. In other words, all cities that come before Toronto using alphabetical order would appear in your filtered report. Is less than or equal to does the same as "is less than," but it would include your filter criteria. In our example, it would include Toronto, as well as all cities that come before it in alphabetical order.

Is greater than , when used in text strings, will filter all results that come after the specified filter, using alphabetical order. It's the opposite of "is less than. Is greater than or equal to does the same as "is greater than," but includes the filter criteria. In our example, it would include Toronto, as well as cities that come after in in alphabetical order.

Is between allows you to provide two values. Using our example, perhaps we chose Tahoe and Toronto as our values. Your filtered report would show all cities between Tahoe and Toronto in your filtered report. Is not between shows all data that is not between the two values you provide. Using the example above, your filtered report would show all cities that are not between Tahoe and Toronto.

Starts with allows you to filter your report by values that start with a letter or a series of letters. For example, we might want to filter by all cities that begin with "T" or "Tor. Does not start with does the opposite of "starts with" and allows you to show all results that do not start with a certain letter or series of letters.

Filtering by date, if you have a date field in your report, is much the same as filtering by text. The important thing to remember is that you don't have to pick a date that's listed in your report when you filter by date. You can filter by any date that you want to enter in the Select Expert dialogue box as long as you enter the date in the month, date, year format.

Is in the period. When you choose "is in the period" for your filter criteria, Crystal Reports gives you a list of pre-built choices as to how you can filter the data. For example, you can use "YeartoDate.

They are pretty much always going to fall into that "Other" category. And, of course, a zero value is generally invisible on a chart. But, it can have some unexpected data points show up in your legend.

Originally posted by Lugh a zero value is generally invisible on a chart. Thanks for responding to my question. I was able to filter the charts for each data type based on your logic. However, as you said, there are zero data points that show up in the chart. Is there a way to remove the zeroes or maybe change it's color to look invisible?

Generally speaking, no. You can't really do conditional formatting inside a chart. I'm assuming you looked at the Top N and "specified order" options? What kind of chart are you using? This page was generated in 0. Legal Disclosure. SAP Crystal Reports releases and service packs. Replace the trial keycode for a production keycode to use the software for your ongoing licensed use.

Supported Platforms. Please contact us for a Linux version. SAP Crystal Server releases and service packs. Software downloads. Get the latest releases and service packs, see the product. SAP Crystal Solutions. How is your experience with this page? Contact our Crystal experts for all your licensing questions.

Download the free apps for mobile access. Choose the Licencing Option Best for You.