I am creating a Report on RDLC. Lets say i have 2 tables in database where im importing data from users and expenses.
Each user can have multiple Expenses. Expenses contain Details and amount just 2 columns that i have to include in the report.
Ive created a stored procedure but its duplicating rows because of having same UserId in expenses. So far im able to achieve this.
What i wanted is that One row with column bulty id and other details with multiple sub rows of expenses.
How can i achieve this. I've tried hide duplicate property in RDLC but its showing duplicate column fields
This is what i wanted to achieve
Solved it by doing the Master/Detail Approach. Put 2 tablix in the list. on the first tablix set user details and made a row group so that the values dont repeat and then on the second tablix used the additional data fields.
Then dragged this additional data tablix into the row of first tablix and everything seems to work just fine.
For serial numbering i used Counting distinct values according to my userid
