locked
Get report data from its element RRS feed

  • Question

  • User992700523 posted

    Asalam Alaikum (Greetings)!

    I need a help regarding Report Viewer, I have a report which shows me data like:

    Supplier Type Supplier Name Reg Date
    Exporter
    Al - Habib Traders 2011-09-09
    Esup Suppliers 2012-09-01
    Local
    Traders Sons 2013-10-01
    Wide Trade Sons 2011-01-01
    Zheng Wu Traders 2014-02-14
    None
    Korex Suppliers 2018-01-01

    I want to get total with every exporters type. How can i do that in expression? or any other way.

    Thank you!

    Regards,
    Muhammad Naveed Haroon

    Thursday, July 5, 2018 6:13 AM

Answers

  • User347430248 posted

    Hi MuhammadNave,You had asked,"I want to get total with every exporters type. How can i do that in expression? or any other way."

    In your example, there is no any column for amount to make a total.

    I create one example, that may help you to get an idea.

    When you try to create report at that time try to check the checkbox for sub total.

     Further, you can add column and rows and put a simple expression like below to total the data.

    Output will be like below.

    Further, you can try to refer links below for detailed information with more examples.

    Lesson 6: Adding Grouping and Totals (Reporting Services)

    Add Total and Subtotal to SSRS Report

    Regards

    Deepak

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Friday, July 6, 2018 8:06 AM