Display count of column for specific value in ASP.Net RDLC report using C# and VB.Net

Vanessa

SOLVED CLOSED ACTIVE ANSWERED
User: Vanessa
Posted: on Sep 30, 2021 11:26 PM
Forum: Crystal Reports with ASP.Net
Answer: 2
Views: 3824

Hello!

I have a follow query bout my previous question which was anwered but I have another problem to solve. That link below was my query before.

The IT and HR are under the Column Department, their salary is on Salary Column and I want to dispaly their salary total only not included Supply data in total. In other words, I have a Department and Salary Column on my table and what I need on is the total Salary of IT and HR under Department Column.

Sample Report Output

Dapartment Salary

IT 5,000

HR 3,000

Supply 2,000

Salary Total 8,000 because I dont want to add Supply

Salary on Salary Total

Download FREE API for Word, Excel and PDF in ASP.Net

dharmend...

0 5

Reply
ANSWER
User: dharmendr
Replied: on Oct 02, 2021 06:52 AM
Report

Instead of displaying through expression using parameter and set the value from code.

Refer below links.

Vanessa

0 6

Reply
ANSWER
User: Vanessa
Replied: on Oct 03, 2021 10:45 AM
Report

I got the correct syntax on your source code given to me

=Sum
(
    Switch
    (
         Fields!Department.Value = "HR", VAL(Fields!Supply.Value), 
         Fields!Department.Value = "IT", VAL(Fields!Supply.Value) 
    )
)

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Display count of column for specific value in ASP.Net RDLC report using C# and VB.Net

Display count of column specific value in RDLC report using C# and VB.Net in ASP.Net

Show (Display) column sum and calculated field in RDLC report in ASP.Net

Show sum of columns in RDLC Report using C# and VB.Net in ASP.Net

Company

Explore

Follow us

Contact Us