Dynamic grouping of records after generation of report

[Buknoy Palaboy]

Hi Stimulsoft team,

Is it possible to add a group band on a report after it is generated and assign a specific column to group retrieved rows?
If so, what is the command to use? Is there any sample c# code you can give us so that we can look at it and check if
it satisfies our requirement.

example:
* retrieve list of customers info
* now that I see all my customers, I want to see customers based on their location like what city they are in and group them
* or I want to see all customers grouped by their birthdate...etc

Please do tell if this is achievable.

Regards and thanks,
Buknoy

[Alex K.]

Hello,

As a way, you can use interactions. Please see the sample report in attachment.

Thank you.

[Buknoy Palaboy]

Hi Aleksey,

Thank you for the reply. Sorry if my inquiry is not clear. What I mean to say is, after I embeded the stimulsoft report object to an MVC view and
render or generate the report, what I want to do is add a grouping during runtime to group customers based on their "ContactTitle" for example,
then a new page will be generated for each group of "ContactTitle." Now if I want to change the grouping again like if region was added on the list of
displayed field, I would see list of customers group by "region". This is all done during runtime and not at the designer application.

Can this be done programmatically using Visual Studio 2010 on an MVC view?

Regards and thanks,
Buknoy

[Buknoy Palaboy]

Any updates, please anyone...

[HighAley]

Hello.

Thank you for the reply. Sorry if my inquiry is not clear. What I mean to say is, after I embeded the stimulsoft report object to an MVC view and
render or generate the report, what I want to do is add a grouping during runtime to group customers based on their "ContactTitle" for example,
then a new page will be generated for each group of "ContactTitle." Now if I want to change the grouping again like if region was added on the list of
displayed field, I would see list of customers group by "region". This is all done during runtime and not at the designer application.

Can this be done programmatically using Visual Studio 2010 on an MVC view?

You could create group at design time and set its Enabled property to false.
Then in your code you could set its condition and enable it.

Code: Select all

StiGroupHeaderBand groupHeader = report.GetComponentByName("GroupHeaderBand1") as StiGroupHeaderBand;
groupHeader.Enabled = true;
groupHeader.Condition = new StiGroupConditionExpression("{Customers.Region}");

Thank you.

[Buknoy Palaboy]

Hi Aleksey,
Your solution works like a charm. Good job. Thanks! :grinder:

Regards and Thanks,
Buknoy

[Andrew]

Hello,

Great!

Have a nice day!
Thank you.