I have an RDLC report, In here I am showing ItemID, Quantity and Cost. There can multiple entries for ItemID where I need to group them by itemID and display item ID wise overall totals for Quantity and Cost.
Eg:
ItemID Qty Cost
1 10 2
1 2 2
Total 12 4
2 2 2
2 2 2
Total 4 4
How can I achieve this...In addition, I have date range to retrieve data. I get dates from two textboxes, txtFromDate, txtToDate. How can I display these textbox values(txtFromDate.text, txtToDate.Text) in the header part of the report. Please help me in
this As I am a noob.
To group data and add totals to a report, you could refer https://msdn.microsoft.com/en-us/library/ms170712.aspx. In this tutorial lesson, you will add grouping and totals to your
Reporting Services report to organize and summarize your data.
In addition, I have date range to retrieve data. I get dates from two textboxes, txtFromDate, txtToDate. How can I display these textbox values(txtFromDate.text, txtToDate.Text) in the header part of the report.
Thanks for your reply but unfortunately, I am not able to do the group totals. Grouping happens but the group total is not coming up. The total goes to the end of the report as group total
Member
168 Points
497 Posts
RDLC group totals to be displayed
Jan 04, 2017 05:41 PM|acmedeepak|LINK
Hi,
I have an RDLC report, In here I am showing ItemID, Quantity and Cost. There can multiple entries for ItemID where I need to group them by itemID and display item ID wise overall totals for Quantity and Cost.
Eg:
ItemID Qty Cost
1 10 2
1 2 2
Total 12 4
2 2 2
2 2 2
Total 4 4
How can I achieve this...In addition, I have date range to retrieve data. I get dates from two textboxes, txtFromDate, txtToDate. How can I display these textbox values(txtFromDate.text, txtToDate.Text) in the header part of the report. Please help me in this As I am a noob.
Regards,
Deepak
All-Star
17652 Points
3510 Posts
Re: RDLC group totals to be displayed
Jan 05, 2017 05:58 AM|Chris Zhao|LINK
Hi Deepak,
To group data and add totals to a report, you could refer https://msdn.microsoft.com/en-us/library/ms170712.aspx. In this tutorial lesson, you will add grouping and totals to your Reporting Services report to organize and summarize your data.
reference: http://ssrstutorials.blogspot.sg/2012/10/lesson-11-ssrs-grouping-and-totals.html
Take a look at https://www.mssqltips.com/sqlservertip/3421/add-a-date-range-dataset-in-sql-server-reporting-services/
Best Regards,
Chris
Member
168 Points
497 Posts
Re: RDLC group totals to be displayed
Jan 05, 2017 01:02 PM|acmedeepak|LINK
Hi Chris,
Thanks for your reply but unfortunately, I am not able to do the group totals. Grouping happens but the group total is not coming up. The total goes to the end of the report as group total