SQL Server Report Builder - Expression

Question

My condition is that industry who has paying highest time amount and total receivable amount of that industry

My expected result is ABC industry is highest number of count and total receive amount for that is 3584

I am trying find SSRS expression for above query but I couldn't. please help me

Answer 1

It will probably be better to do this in your dataset query, something like this.

DECLARE @t TABLE(IndustryType Varchar(3), Amount int)
INSERT INTO @t VALUES
    ('ABC', 500),('XYZ', 304),('KLM', 683),('ABC', 529),('ERJ', 703),
    ('XYZ', 902),('ABC', 852),('KLM', 950),('ABC', 703),('ABC', 1000)

SELECT TOP 1 * 
    FROM(
        SELECT IndustryType, COUNT(*) as cnt, SUM(Amount) as TotalAmount 
            FROM @t
            GROUP BY IndustryType
    ) x 
    ORDER BY x.cnt DESC

This gives the following results

If you cannot do this for whatever reason, edit your question and show what the final output should look like.