Please Check this ...i need a report showing all 12 months data in one report. but when im writing query in sql im getting results in vertical postion so i cannot use this bcoz requirement is i have to the result horizontal way Month1 Month2 Month3 in this
way ...
how can i make a report in horizontal way of months like below
January February
centername income outcome total centername income outcome total
but im getting result for query as below ...please helpppp
SELECT centername,monthid, sum(expr1) as income, Sum(expr2) as Outcome, sum(expr1+expr2) as total from transactionsStat_view_summary_centers where bigcentersid = '2' and YearID='1433' group by centername,MonthID
developer27
Member
396 Points
205 Posts
months in horizontal way in report
Apr 14, 2012 11:01 AM|LINK
Please Check this ...i need a report showing all 12 months data in one report. but when im writing query in sql im getting results in vertical postion so i cannot use this bcoz requirement is i have to the result horizontal way Month1 Month2 Month3 in this way ...
how can i make a report in horizontal way of months like below
January February
centername income outcome total centername income outcome total
but im getting result for query as below ...please helpppp
SELECT centername,monthid, sum(expr1) as income, Sum(expr2) as Outcome, sum(expr1+expr2) as total from transactionsStat_view_summary_centers where bigcentersid = '2' and YearID='1433' group by centername,MonthID
centername montid income outcome total
city1 1 1 22 23
city2 1 1 22 23
city3 1 1 22 23
city4 1 1 22 23
city5 1 1 22 23
city6 1 1 22 23
|
|
city12 1 1 22 23
//2ndmonth
city1 2 2 23 25
city2 2 2 23 25
city3 2 2 23 25
city4 2 2 23 25
city5 2 2 23 25
|
|
city12 2 2 23 25
hiza808
Member
270 Points
75 Posts
Re: months in horizontal way in report
Apr 15, 2012 08:07 PM|LINK
http://www.codango.com/aspnet/dir/tutorial/howto/graphics/charts/