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
finance_teacherAsked:
Who is Participating?
 
planoczConnect With a Mentor Commented:
You need to change to one dataset by using the two tables jioned together in a stored procedure. then group by work center.
0
 
finance_teacherAuthor Commented:
Do you have an example URL showing this ?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.