Hi
I have an issue that I need the out put of my SP into HTML report format in aspx. page with Sub and Grand Total
I no need Gridview.
Pls advice
Maideen
Below is my SP and OutPut
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
Results
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
Go to the complete details ...