March 24, 2012 at 6:34 am
Hi Forumer's
Im newbie in this forum.
I have an SQL query using CTE. This query i have to pullout 3 kinds of resultset using SSRS and place it into separate sheet when export to excel.
what is sql query or logic in SSRS and then how toexport to multiple excel sheeets.
do i have to create 3 dataset per resultset? need you input guys..
my resultset are the following:
i have already this query.
1. i have a query to get all the detail.
2. pullout summary like pivot
3. pullout summary per SKU
this are the format of my query
,with CTE as
(select... --this get the details
),
CTE2 as
(
select...--this get the summary per etamonth
),
CTE3 as
(
Select ...--
)
Select * from ...this get the summary per sku
thank you in advance..
jov
March 25, 2012 at 7:19 pm
Guys,
Anyone who have idea about my concern..need your input please.. thanks.
March 26, 2012 at 7:46 pm
Solved.
March 27, 2012 at 3:56 am
Add page breaks before each table which you want to display on another sheet.
Via the 'PageName' property of the tablix/matrix/chart, you can give each Excel-sheet a nicer name also...
Hope this helps!
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply