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
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.
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?
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.
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
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
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
CA Neeraj Kumar 1,882
André Arnaud de Cal... 794 Super User 2025 Season 2
Sohaib Cheema 525 User Group Leader
