Solved

SQL -- Microsoft Reporting Services ?

Posted on 2013-05-10
2
475 Views
Last Modified: 2013-05-16
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
0
Comment
Question by:finance_teacher
2 Comments
 
LVL 27

Accepted Solution

by:
planocz earned 500 total points
ID: 39158941
You need to change to one dataset by using the two tables jioned together in a stored procedure. then group by work center.
0
 

Author Comment

by:finance_teacher
ID: 39170996
Do you have an example URL showing this ?
0

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question