By default ,All data will display

[anamika]

Hello,

I want to display all the data of the table by default without selecting any option from dropdown filtering.

Or add a option "ALL" to the dropdown list to select all the data from the dropdown filtering.

[Neli]

Hi Аnamika,

If I understood correctly, you have a MultiValue report parameter and you would like to display the report with all values initially selected. You may set the default Value of the report parameter to be:

= AllValues(Fields.NameOfField)

I hope this information helps you. Please, let me know if you need further assistance.

Regards,
Neli
Progress Telerik

[anamika]

Hi,

Thanks for your answer. It helps me a lot. But now my requirements are changed.

I have a multivalue parameter that i have set to be null to make it optional at the time of filtering.
But the problem is not with null checking. I am able to do null checking and selection of one parameter at a time.
But If I want to select multivalues , it is showing error of 'No Page to Display'.

I am following this link 

https://www.telerik.com/support/kb/reporting/accessing-and-managing-data/details/how-to-use-multivalue-report-parameter-in-a-sql-query

and with the help of this link I have created a stored procedure and function but have not applied any other filtering. Still I am not able to show data with multivalue parameter.

[Neli]

Hi Аnamika,

I suspect that the behavior might be caused by the SkipBlankPages property of the report. The R1 2020 Service Pack of Telerik Reporting introduced a couple of changes in the rendering engine.

The rendering engine is now forced to skip all pages that do not contain significant content. The latter is considered blank and this includes all pages that only contain items of the following type: Report, Group, any Section, empty SubReport item, Cross-section item, i.e., they do not contain items like TextBox, PictureBox, Table, etc. 

Please,  test setting the SkipBlankPages property of the report to False and let me know if the report works as expected.

Regards,
Neli
Progress Telerik