Link to home
Create AccountLog in
Avatar of finance_teacher
finance_teacher

asked on

SQL -- Microsoft Reporting Services ?

Below two tables need to be merged into
one Microsoft Reporting Services report.
----------------------------------------------------------
     select job, customer
     FROM job
     where job = 'G0878'
     
     SELECT job, work_center
     FROM job_operation
     where job = 'G0878'
----------------------------------------------------------
How can I change the below to put each work_center
into a separate Microsoft Reporting Services SQL statement column
instead of all work_centers in one column like it currently displays ?

I cannot run pre-scripts since this is
a Microsoft Reporting Services report.

  select
  j.customer,
  (
     SELECT work_center + ','
     FROM job_operation
     where
       --job = j.job
       job = 'G0878'
     FOR XML PATH('')
  ) as Work_Centers
 
  from job j
  where job = 'G0878'
s001.jpg
ASKER CERTIFIED SOLUTION
Avatar of Howard Cantrell
Howard Cantrell
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of finance_teacher
finance_teacher

ASKER

Do you have an example URL showing this ?