1. Created a typed dataset as follows
select last_name,first_name,location,dept,title from employee
2. Using Report Wizard created a group by Location Like
Last Name, First Name , Location, Dept, title
3. Assigned the rdlc to a report viewer control and it works fine.
My requirement to provide reports grouped either by location, department or title.
I do not want to maintain 3 rdlc report for the above.
I wanted to use one and change the grouping field at runtime based on some condition like
default: // By default it is grouped by location.
Any input is appreciated.