August 18, 2012 at 8:19 am
I want to get the sub total for say non numeric field Month. So how can i get it in SSRS?
August 18, 2012 at 9:38 pm
What is the meaning of
January + February + March + .... ?
What do you mean by total? Do you mean total number of days between MIN(Month) and MAX(Month)?
--Vadim R.
August 19, 2012 at 3:27 am
Actually i am counting mail returns for month field if any. So for that i need count of month for particular month and then total of mail returns for all the month in specified range of date.
August 19, 2012 at 10:58 am
naisu1383 (8/19/2012)
Actually i am counting mail returns for month field if any. So for that i need count of month for particular month and then total of mail returns for all the month in specified range of date.
It doesn't make sense. "Count of month for particular month" is 1.
I think what you mean is count of records per month and then total count of all records, right? If so, and assuming you are using Table, you'll need to create a Group by Month and place your counter in Group's Footer. Place total counter in Table's Footer.
--Vadim R.
August 19, 2012 at 8:08 pm
naisu1383 (8/19/2012)
Actually i am counting mail returns for month field if any. So for that i need count of month for particular month and then total of mail returns for all the month in specified range of date.
count of month , doesn't mean addition of month . I liked the post 😛
you need the count and total mails and display where in the report ?
check the features of SSRS , when you add a filter you may be able to add up in the end.
~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one :ermm:
August 19, 2012 at 8:10 pm
rVadim (8/19/2012)
naisu1383 (8/19/2012)
Actually i am counting mail returns for month field if any. So for that i need count of month for particular month and then total of mail returns for all the month in specified range of date.It doesn't make sense. "Count of month for particular month" is 1.
I think what you mean is count of records per month and then total count of all records, right? If so, and assuming you are using Table, you'll need to create a Group by Month and place your counter in Group's Footer. Place total counter in Table's Footer.
that is why he mentioned, Specific Range Of Dates. So, count of month is more than one ...
~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one :ermm:
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply