This is a migrated thread and some comments may be shown as answers.

By default ,All data will display

3 Answers 58 Views
Report Designer (standalone)
This is a migrated thread and some comments may be shown as answers.
anamika
Top achievements
Rank 1
Veteran
anamika asked on 23 Mar 2021, 10:40 AM

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.

3 Answers, 1 is accepted

Sort by
0
Neli
Telerik team
answered on 26 Mar 2021, 08:24 AM

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

Virtual Classroom, the free self-paced technical training that gets you up to speed with Telerik and Kendo UI products quickly just got a fresh new look + new and improved content including a brand new Blazor course! Check it out at https://learn.telerik.com/.

0
anamika
Top achievements
Rank 1
Veteran
answered on 12 Apr 2021, 11:48 AM

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.

0
Neli
Telerik team
answered on 15 Apr 2021, 07:03 AM

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

Virtual Classroom, the free self-paced technical training that gets you up to speed with Telerik and Kendo UI products quickly just got a fresh new look + new and improved content including a brand new Blazor course! Check it out at https://learn.telerik.com/.

Tags
Report Designer (standalone)
Asked by
anamika
Top achievements
Rank 1
Veteran
Answers by
Neli
Telerik team
anamika
Top achievements
Rank 1
Veteran
Share this question
or