grouping for reporting in report viewer - stored procedure problem

See more:

C#

SQL-Server

SELECT #MGFINAL.* ,#MGFINAL.IDNO+#MGFINAL.LOANUMBER AS IDNOLOANUMBER,
	       LOANS.CUSTOMER,
	       LOANS.ADVLOAN    AS PRINCIPAL,
	       LOANS.AC_BALANCE AS ACCOUNT_BAL,
	       LOANS.TERM_START AS ORIGIN_TERM,
	       LOANS.TERM_NOW,
	       LOANS.TOTPAYMT   AS TOT_AMT_PAID 
	FROM  #MGFINAL 
	LEFT JOIN LOANS ON #MGFINAL.IDNO=LOANS.IDNO
	GROUP BY #MGFINAL.IDNO+#MGFINAL.LOANUMBER
	ORDER BY #MGFINAL.IDNO+#MGFINAL.LOANUMBER,#MGFINAL.TX_DATE

End

How do I group and order the above?

The report is grouping but breaking for a row on a page, instead of the listing of row on a page.

Thanks