Click here to Skip to main content
15,918,967 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
SQL
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
Posted
Updated 22-Dec-14 3:44am
v3
Comments
Sinisa Hajnal 22-Dec-14 9:51am    
What do you mean "breaking for a row" "instead of listing of row"? Please clarify. Show us what you get and what you're expecting. Thank you.
Shweta N Mishra 22-Dec-14 9:53am    
your question is not clear, what is the code you have return on a c# page, Are you using SSRS ?
User-8621695 24-Dec-14 5:52am    
First important thing is your question is not clear. You can do grouping on the reports itself either you are using RDLC or SSRS report.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900