RDLC group totals to be displayed

Question

User1182587605 posted

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 

Answer 1

User-2057865890 posted

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

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.

Take a look at https://www.mssqltips.com/sqlservertip/3421/add-a-date-range-dataset-in-sql-server-reporting-services/

Best Regards,

Chris

Answer 2

User1182587605 posted

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