Member Avatar for jovillanuev
jovillanuev 0 Junior Poster in Training

Hi Forumer's

I’m currently having 3 reports (Detail, summary per etamonth and summary per sku). Those 3 results is derived in 1
query ( see my query using CTE) into a single report. so when generate it ito SSRS and export to excel i would like to send it into 3 different sheet or tab in excel. please let me know how to arrive the solution for this scenario.

This are the format of my query which is working.

,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.

  • 1 Contributor
  • 0 Replies
  • 60 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.