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

Reporting Parameters but default to all

1 Answer 49 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
James Kiely
Top achievements
Rank 1
James Kiely asked on 10 Jun 2010, 12:38 AM
I'm new to Telerik Reporting and I have a report that using parameters and it works great.  Now I need to figure out or find an example of how to default the report to show all the data and allow users to filter down the data by using the parameters.  I have 3 paramters but I don't want to force the users to use all 3 parameters.  Any help would be much appreciated.

1 Answer, 1 is accepted

Sort by
0
Peter
Telerik team
answered on 15 Jun 2010, 05:02 PM
Hello James Kiely,

To achieve the desired functionality you have to set the Report Parameter's AllowNull property to True and set a Filter to: 

Expression        Operator      Value
===========   ========  =================================
=Fields.MyField        =            =IsNull(Parameters.MyParam, Fields.MyField)

For more information on the topic check out the Do not filter on null blog article.

Best wishes,
Peter
the Telerik team

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.
Tags
General Discussions
Asked by
James Kiely
Top achievements
Rank 1
Answers by
Peter
Telerik team
Share this question
or