Total in SSRS

(0) Share

Report

Posted on by Axle

Hello,

I am trying to build an SSRS report to show the total amount on a quote based on quote type.

Example:

Type	Amount
A	3000
C	4000
D	7000
B	2000

I can build a list of quotes based on their type and amount, like Quote 1 is Type A, with amount 1500, and Quote 2 is type A with amount 1500, but how do i convert this into an aggregate based on type?

Thanks

*This post is locked for comments

All responses (1)

Answers (0)

Suggested answer

ScottDurow 50,177 on at

Like (0)

Report

RE: Total in SSRS

You will need to use the group by aggregate attribute in the fetch xml for your report - see msdn.microsoft.com/.../gg309565.aspx

Once you have the fetch xml query in your report you can simply add a tablix bound to that dataset.

I fins it is easiest to use the report wizard to create the starting point and then download the rdl and edit it in visual studio. See http://himbap.com/blog/?p=2394

Hope this helps