Right now i am using two rdlc file to achieve. except for the field gender and field age , rest are the same. these are the two queries i use.
query 1 :select state,gender,count(*) from table
query 2 :select state,age,count(*) from table
how do i dynamically set the column frm the dataset to achieve in a single rdlc file. do i need to use parameters in reports. but i have no idea how it would work. any help would be appreciated. what i meant is
