We use an MS SQL database directly as a data source for List & Label. All tables, columns and data records are then always available at once.

However, a created report should not always display all data, so we have selected the appearance condition within the report in such a way that only certain data of a table is displayed.

But we don't want to create and offer a separate report for each possible condition in a table, where each one has its own appearance condition. Also the user should not be able to change the report itself in the designer. Is there a simple and user-friendly way that the user can decide from "outside" for the report which data should be displayed?

CodePudding user response：

The best way to achieve this is using a

As you can see from the screenshot, the data for the report parameter can come from the database, but you can also offer a choice from a predefined list of entries or even allow the user to freely type a text. There are date pickers for date values etc.

These parameters are shown above the preview in desktop apps. In web apps, you have a separate pane - see the "Chart With Report Parameters" sample here.

Once you have configured the parameter as required, use it in the "Data Filter" property of your report container items. Note that you should look for a filter that translates to your database's syntax. This blog article has more details on the concept.