Page 1 of 1
Dynamic grouping of records after generation of report
Posted: Fri Jun 22, 2012 2:15 am
by 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
Dynamic grouping of records after generation of report
Posted: Fri Jun 22, 2012 8:36 am
by Alex K.
Hello,
As a way, you can use interactions. Please see the sample report in attachment.
Thank you.
Dynamic grouping of records after generation of report
Posted: Sun Jun 24, 2012 11:47 pm
by 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
Dynamic grouping of records after generation of report
Posted: Tue Jun 26, 2012 8:37 pm
by Buknoy Palaboy
Any updates, please anyone...
Dynamic grouping of records after generation of report
Posted: Wed Jun 27, 2012 5:42 am
by HighAley
Hello.
Buknoy Palaboy wrote: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.
Dynamic grouping of records after generation of report
Posted: Thu Jun 28, 2012 1:35 am
by Buknoy Palaboy
Hi Aleksey,
Your solution works like a charm. Good job. Thanks! :grinder:
Regards and Thanks,
Buknoy
Dynamic grouping of records after generation of report
Posted: Fri Jun 29, 2012 1:02 am
by Andrew
Hello,
Great!
Have a nice day!
Thank you.