Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
avijitgorai
Starting Member
2 Posts |
 Posted - 2009-01-29 : 03:35:41
|
| i have the the following tableComplaint(id int,ComplaintDate dateTime,ComplaintType (Foreign,Product,Service) varchar(20))so, how can i produce following output.Can any body give me the solution for this. Foreign Product Service MonthName Total LastYearTotal Total LastYearTotal Total LastYearTotal January 10 10 50 48 0 0 February 8 12 33 49 0 0 March 11 9 47 50 0 1 April 5 8 38 52 0 0 May 8 14 36 46 0 1 June 12 15 45 36 0 0 July 6 11 33 43 0 0 August 10 4 31 16 0 0 September 13 8 29 39 0 0 October 9 9 42 50 0 0 November 7 4 36 42 0 1 December 12 4 59 29 0 0 Please help me, its really very urgent.Advance thanks.Avijit Gorai. |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2009-01-29 : 05:29:26
|
| moved from article discussion forum.___________________________________________________________________________Causing trouble since 1980Blog: http://weblogs.sqlteam.com/mladenpSpeed up SSMS development: www.ssmstoolspack.com <- version 1.1 out! |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-29 : 09:26:09
|
| seems like this is for reporting purpose. which reporting tool are you using? if its sql reports, this format output can be easily generated by the use of matrix? |
|
|
|
avijitgorai
Starting Member
2 Posts |
Posted - 2009-01-30 : 01:29:16
|
quote:
Originally posted by visakh16
seems like this is for reporting purpose. which reporting tool are you using? if its sql reports, this format output can be easily generated by the use of matrix?
Thanks for ur reply.This is for reporting purpose.I am using Sql Server Reporting.Can u guide me how to generate this kind of report. Regard,Avijit Gorai. |
|
|
|
|
|
|
Need help CrossTab Query