How can I calculate table data and generate a RDLC report. Example is in description.

niroy

I have a table like the following:

Now I want to generate a RDLC report like the following:


How can I achieve that?

swpolo

Hi,
You can create your report and set grouping by the Equipment column.
Quantity in School is a count of records on Available in column with filter by 'School' value.
Quantity in College is the same but filtered by 'College' column.
Total - is count of records without filter.

swpolo

Hi,
You can create your report and set grouping by the Equipment column.
Quantity in School is a count of records on Available in column with filter by 'School' value.
Quantity in College is the same but filtered by 'College' column.
Total - is count of records without filter.