I did the stored procedure in mssql 2012. working fine in server.
I have an issue that I need the output of my SP into HTML Report Format in aspx.page with Sub and Grand Total
I no need GridView
SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[Z_usp_Circ_Details_Member] AS BEGIN SET NOCOUNT ON; SELECT * FROM (SELECT MEMBER,[LANGUAGE],[TYPE],[PLATFORM],copies,CATEGORY,MAINAREA,YearNo FROM Z_tbl_Circulation_Details where mainarea='Peninsular Malaysia' and Language='English') TableYearNo pivot (Sum(copies) for [member] in ([The sun],[The Star]))pivotTable END
English Newspaper Print Free Peninsular Malaysia 2012 603706 5210 English Newspaper Print Free Peninsular Malaysia 2013 301853 98754 English Newspaper Print Paid Peninsular Malaysia 2012 2547 569146 English Newspaper Print Paid Peninsular Malaysia 2013 3257 284573