SSRS - Grouping of 2 or more multivalued field

Question

0.00/5 (No votes)

See more:

I had sql result shown below...

ProjectNO.     Projectname      Client    Programmers
01              ave             zica       dee
01              ave             zica       law
01              ave             zica       amy
01              ave            rowan      dee
01              ave            rowan       law
01              ave             rowan      amy

Now how would I represent this into SSRS as

ProjectNO.    Projectname      Client    Programmers
  01              ave           zica       dee
                                rowan      law
                                           amy

or how can I achieve this without using pivot in query and with ssrs only ?

ProjectNO.   Projectname   Client1   Client2  Programmer1   Programmer2  Programmer3
01           ave           zica      rowan    dee           law           amy

I was confused how to group them all according to Project name and Number.

Posted 21-Apr-14 4:16am

waleed ahmed wadkar

Updated 21-Apr-14 4:31am

v2

Add a Solution

Comments

Chandra Mohan N 22-Apr-14 0:25am

you can set the textbox's HideDuplicates property to the containing group name

waleed ahmed wadkar 22-Apr-14 3:23am

Hey I tried that , and result is ...
note - neglect spacing

ProjectNO. Projectname Client Programmers
01 ave zica dee
rowan
zica law
rowan
zica amy
rowan

ccalma 22-Apr-14 3:39am

Are you using Server Data Tools in creating the Report?

waleed ahmed wadkar 22-Apr-14 4:25am

visual studio 2012

ccalma 22-Apr-14 4:41am

Have you tried creating groups in the Row Groups section?

waleed ahmed wadkar 22-Apr-14 6:12am

no..so what sould I set on Row Group-->;group properties-->;Group On == ?

waleed ahmed wadkar 22-Apr-14 10:54am

leave the SSRS part , how could I achieve the 2nd format in SQL ?

2 solutions

Solution 2

Hi All,

Anyways, I figured it out using Stuff funtion with For XML path I got the answer Just for one column field

with Programmers in single cell (comma sepearted Prgrammers name) and Clients which happened to appear in Single cell instead appeared in individual cell ...like below

HTML

ProjectNO.  Prjtname      Programmers          Client    
01             ave        dee, law, amy        zica        

01             ave        dee, law, amy        rowan

Any suggestion or examples with (Stuff + For XML path) using individually with each(2 or more ) column... I had applied STuff+FOR XML path for both Programmers and Clients.

Posted 23-Apr-14 5:45am

waleed ahmed wadkar

v2

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

HuyNTT · Accepted Answer · 2014-04-22T06:24:00

Solution 1

This question could not be answers with some line of description.

Please refer
http://carlosferreira.com/how-to-combine-values-from-multiple-rows-of-a-single-column-t-sql-microsoft-sql-server-for-xml-path-csv/

Posted 22-Apr-14 6:24am

HuyNTT