September 22, 2014 at 12:52 am
i have an ssrs report
where i have to place the sum of amounts from April to August
into Sepetember month
and i have replace zeros for the previous months i.e,. from April to August
how get this can any one help me....
September 22, 2014 at 1:04 am
Why April to August? Is there any kind of specific logic.
Assuming September is the "current month", I would just calculate some kind of YTD value for September.
For the other months I would use an expression to check if the month is September. If it is not, place 0, it it is, place the YTD.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 22, 2014 at 1:07 am
yah how to do that....can you please tell me....
how you calculated....
September 22, 2014 at 1:09 am
You either calculate it in the SQL query, or in SSRS itself.
An example:
Cumulative Aggregates in SQL Server Reporting Services[/url]
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply