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

How to allow dynamic grouping selections/paramters in a report?

4 Answers 582 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
jgill
Top achievements
Rank 1
jgill asked on 08 Mar 2011, 09:30 PM
Hi,
We wanted to find out if it is possible to allow users to dynamically group data in a Telerik Reporting Report (the users are used to the group by features from the Telerik RadGrid/RadGridView).  The users want to be able to select 1 or more columns in the report to group the data by, is this possible?  Some times they will just let the report generate without adding grouping.

4 Answers, 1 is accepted

Sort by
0
Peter
Telerik team
answered on 11 Mar 2011, 06:35 PM
Hello jgill,

I have attached a sample project to illustrate dynamic grouping with Report Parameters and the following grouping expression:

=IIF(Parameters.Grouping2.Value is null,"",Fields(IsNull(Parameters.Grouping2.Value, "Sales")))

Just to note that the default Sales field will not be used, it's added to avoid error while evaluating the expression.

Greetings,
Peter
the Telerik team
Registration for Q1 2011 What’s New Webinar Week is now open. Mark your calendar for the week starting March 21st and book your seat for a walk through all the exciting stuff we ship with the new release!
0
Simon Keeton
Top achievements
Rank 1
answered on 12 Mar 2012, 01:59 PM
Hi Peter,

We have similar requirement as stated here.

I downloaded the sample code you have provided but was unable to run it in visual studio. Its shows an error "Object reference not set to an instance"

Can you please provide us the complete running project & not just the class files.

Regards,
Simon
0
Steve
Telerik team
answered on 12 Mar 2012, 03:20 PM
Hello Simon,

We've not been able to reproduce the error you've encountered. Probably you forgot to rebuild your project after placing the sample report and classes in it? Anyway find attached complete project using a web application with the asp.net report viewer.

Greetings,
Steve
the Telerik team
NEW in Q1'12: Telerik Report Designer (Beta) for ad-hoc report creation. Download as part of Telerik Reporting Q1 2012. For questions and feedback, use the new Telerik Report Designer Forum.
0
Mike
Top achievements
Rank 1
answered on 15 Mar 2012, 05:17 PM
Thanks Steve! I wish there were more examples like the project you provided somewhere that was easily accessible. Like in the code library! While I don't have the same problems as the above poster, what you provided gave me some ideas that will help me.
Tags
General Discussions
Asked by
jgill
Top achievements
Rank 1
Answers by
Peter
Telerik team
Simon Keeton
Top achievements
Rank 1
Steve
Telerik team
Mike
Top achievements
Rank 1
Share this question
or