How to display Financial Year wise Summary

Question

How to display Financial Year wise Summary

avdhut.k

SSCrazy

Points: 2834
More actions
May 14, 2013 at 1:16 am

#277528

Hi,
I had requirement,I want a report in sql server 2008 as follows,
Total PayDate Amount
2000 20110401 1000
20110501 1000
5000 20120401 2000
20120501 1000
20120501 1000
20120601 1000
4000 20130401 2000
20130501 1000
20130601 1000
I had Paydate and Amount data with me,
But my Total should be displayed Finacial year wise.means Sum of Amount in that FY Year once
and for rest of the month as blank.
Kindly help me in this requirement.
Thanks in Advance!!!!

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Eugene Elutin SSC Guru Points: 59322 More actions · Answer 1

avdhut.k (5/14/2013)
Hi,
I had requirement,I want a report in sql server 2008 as follows,
Total PayDate Amount
2000 20110401 1000
20110501 1000
5000 20120401 2000
20120501 1000
20120501 1000
20120601 1000
4000 20130401 2000
20130501 1000
20130601 1000
I had Paydate and Amount data with me,
But my Total should be displayed Finacial year wise.means Sum of Amount in that FY Year once
and for rest of the month as blank.
Kindly help me in this requirement.
Thanks in Advance!!!!

We will kindly provide you help, if you kindly will post some details as per following kindly article:

http://www.sqlservercentral.com/articles/Best+Practices/61537/

:hehe:

_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)

How to post your question to get the best and quick help[/url]

avdhut.k SSCrazy Points: 2834 More actions · Answer 2

Hi,

I had requirement,I want a report in sql server 2008 as follows,

Total PayDate Amount

2000 20110401 1000

20110501 1000

5000 20120401 2000

20120501 1000

20120601 1000

4000 20130401 2000

20130501 1000

20130601 1000

I had Paydate and Amount data with me,

But my Total should be displayed Finacial year wise.means Sum of Amount in that FY Year once

and for rest of the month as blank.

Kindly help me in this requirement.

Thanks in Advance!!!!

Eugene Elutin SSC Guru Points: 59322 More actions · Answer 3

avdhut.k (5/14/2013)
Hi,
I had requirement,I want a report in sql server 2008 as follows,
Total PayDate Amount
2000 20110401 1000
20110501 1000
5000 20120401 2000
20120501 1000
20120501 1000
20120601 1000
4000 20130401 2000
20130501 1000
20130601 1000
I had Paydate and Amount data with me,
But my Total should be displayed Finacial year wise.means Sum of Amount in that FY Year once
and for rest of the month as blank.
Kindly help me in this requirement.
Thanks in Advance!!!!

We will kindly provide you help, if you kindly will post some details as per following kindly article:

http://www.sqlservercentral.com/articles/Best+Practices/61537/

Please be kind to us, read and use forum etiquette to post your questions.

We expect very little: DDL and some data, so we don't need to spend our time on setting up something which you should be able to provide easily and without much of effort.

_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)

How to post your question to get the best and quick help[/url]

avdhut.k SSCrazy Points: 2834 More actions · Answer 4

Hey Sorry,

I posting the table correctly,

but while Posting it gets meshed.

Eugene Elutin SSC Guru Points: 59322 More actions · Answer 5

avdhut.k (5/14/2013)
Hey Sorry,
I posting the table correctly,
but while Posting it gets meshed.

I cannot see you have posted a table. Just formatted/indented text.

Have you read forum etiquette article I've referred you too (if not yet, link at the bottom of my signature)?

If you would supply details in form of DDL and sample data insert script, you would already had your issue resolved...

_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)

How to post your question to get the best and quick help[/url]