[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

SQL -- Microsoft Reporting Services ?

Posted on 2013-05-10
2
Medium Priority
?
485 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 27

Accepted Solution

by:
planocz earned 2000 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

Ask an Anonymous Question!

Don't feel intimidated by what you don't know. Ask your question anonymously. It's easy! Learn more and upgrade.

Question has a verified solution.

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

Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Windocks is an independent port of Docker's open source to Windows.   This article introduces the use of SQL Server in containers, with integrated support of SQL Server database cloning.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.

649 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