You can also apply filtering in an existing data source by right-clicking it in the Report Explorer or Field List and selecting Manage Queries. In the Manage Queries window, click the required query's ellipsis button.
In the invoked Query Editor, click the Run Query Builder button and use the Query Builder to specify the filter criteria as shown in the following image:
Use the report's XtraReportBase.FilterString property to filter records at the report level. Locate this property using the report's smart tag and click the corresponding ellipsis button to invoke the Filter Editor.
The ReportPrintOptions.DetailCountAtDesignTime property enables you to limit the number of records a report shows at design time in Visual Studio. Click the report's smart tag to access this setting as shown in the image below.
The ReportPrintOptions.DetailCountOnEmptyDataSource property allows you to specify how many times to print the Detail band when a report does not have a data source. You can use this property to create static reports that are not connected to a data source and display the same static content several times.
Conditionally Change Element Visibility
You can show or hide a specific report control in Print Preview based on a logical condition. For instance, the following example illustrates a document that displays the State field only if the Country value is "USA".
Select the target label on the report's surface, switch to the Property Grid's Expressions tab and click the XRControl.Visible property's ellipsis button.
In the invoked Expression Editor, specify the expression that defines when a control should be visible.
Add these controls to the Panel and set its XRControl.CanShrink property to true which automatically adjusts the panel's size to fit all the controls and prevent blank areas.