Share
ReportHi Experts,
Why some of the expression fields are shown starting with "SUM" and some are shown starting with "First"??(Developing a SSRS report)
Best Regards,
Shabir Ahmad
You’re offline. This is a read only version of the page.
3,090
Hi Experts,
Why some of the expression fields are shown starting with "SUM" and some are shown starting with "First"??(Developing a SSRS report)
Best Regards,
Shabir Ahmad
Thanks for your reply,
What was my confusion for last query was, why dataset shows =sum and =first from DP class and tmp class. I cleared myself. When i took int in expression it will give =sum and when i took string data type in tmp table it gives me =first in expression dataset
Thanks
If you can clear one thing is why =sum coming automatically are there is some other reason, why it is not showing =sum for some values in dataset and other are showing =first .is there any reason??..
Shabir
Let's say the data source has three records, with values 1, 2, and 3.
=FIRST(Value) returns 1, because that's the value of the first record.
=SUM(Value) returns 6, because that's the sum of all values (1+2+3).
If there is a single record only, than the result will be the same, because both expressions will take the value of the single record.
Thanks for your response,
I mean to say i am making RD base report and in dataset expression why some value are showing =First and why some are showing =Sum, let say if i take one value with =sum(Value) in place of =first() for more it clear value in dataset is =sum(ABC) and i make it =First(ABC) will it affect on value will be shown on Report?
Best Regards,
Shabir Ahmad
I'm not sure what you want to hear.
Some expressions use FIRST() function to get the first value only, other experssion use SUM() function to summarize multiple values to a single one.
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,409
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (
