How to split cells in table format?

Question

How to split cells in table format?

meghna.bhargav

SSCrazy

Points: 2634
More actions
April 5, 2008 at 1:46 am

#184808

Hi Guys,
I have this table formatting problem; In this report each item has 2 rows. I want to split the send row as shown below. So the results of the report should have the format below.
rownumber ITEMNUNBER
1 A
2 A
3 B
4 B
5 C
6 C
i wna display in this way mentioned below:
A B
1 2 3 4
Any help appreciated!
thanks
Meghna

Viewing 15 posts - 1 through 15 (of 24 total)

You must be logged in to reply to this topic. Login to reply

Jeff Moden SSC Guru Points: 1004592 More actions · Answer 1

Not enough info... will you always have a max of 2 items. Also, it may make a difference if we knew why you wanted to do this.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

meghna.bhargav SSCrazy Points: 2634 More actions · Answer 2

hi

It can be many items also. Actually i wanted to do it in my RDL to make it more comapct and attractive for client but couldnt find a way out about its solution.

Can you help me to find a way out?

thanks

Meghna

Jeff Moden SSC Guru Points: 1004592 More actions · Answer 3

How many items can you have? Also, should they all be in separate columns or ???

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

meghna.bhargav SSCrazy Points: 2634 More actions · Answer 4

At present i have 3 items maximum , and i want all of them in separate columns for the unique item

For e.g

for item : A B

1 2 3 5 6

Ny idea?

thanks

Jeff Moden SSC Guru Points: 1004592 More actions · Answer 5

We're getting there... in the example you just gave, should 1 2 3 be in a single column or 3 columns? If 3 columns, what shall be their names?

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

meghna.bhargav SSCrazy Points: 2634 More actions · Answer 6

same names jef , as column name is the row number , if u see the example structure in the first post of mine.

Sorry for the delay , but this is exactly the scenario.

thanks

Jeff Moden SSC Guru Points: 1004592 More actions · Answer 7

Sorry... I'm still not getting it and I want to make sure... you posted the following...

for item : A B

1 2 3 5 6

... are you saying that the "1 2 3" should all be in one column and the "5 6" should be in another column like this?

[font="Courier New"] A | B

------+------

1 2 3 | 5 6[/font]

Thanks...

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

meghna.bhargav SSCrazy Points: 2634 More actions · Answer 8

Jeff,

for item : A B

1 2 3 5 6

... are you saying that the "1 2 3" should all be in three diffrent column and the "5 6" should be in another columns like this?

A | B

----------+------

1 |2 |3 | 5 | 6

i dont think its possible in reporting services, what do u say?

Thanks...

--Meghna Bhargav

Jeff Moden SSC Guru Points: 1004592 More actions · Answer 9

I don't know if it can be done in reporting services... header "cells" would need to be "merged" as if on a spreadsheet. I'm sure it can't be done in T-SQL... sorry.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

meghna.bhargav SSCrazy Points: 2634 More actions · Answer 10

meghna.bhargav

SSCrazy

Points: 2634

April 7, 2008 at 7:18 am

#799102

Ok , thanks for sspending your time on it!

Meghna

meghna.bhargav SSCrazy Points: 2634 More actions · Answer 11

meghna.bhargav

SSCrazy

Points: 2634

April 7, 2008 at 7:21 am

#799104

In sql , how it can be done?

thanks

Jeff Moden SSC Guru Points: 1004592 More actions · Answer 12

meghna.bhargav (4/7/2008)
In sql , how it can be done?
thanks

Like I said in my previous post, I don't think spreading a single header over 3 columns can be done. I can combine columns to hold the "1 2 3" in a single column...

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Jacob Luebbers SSCarpal Tunnel Points: 4864 More actions · Answer 13

You can manually merge cells in RS (just like Excel), but not dynamically afaik. Probably not what you want...?

Regards,

Jacob

meghna.bhargav SSCrazy Points: 2634 More actions · Answer 14

hi

that is not the way as 2 nd row elements belong to one column in a table and as per u , if i manually do , 2nd row elements split row after row, they wont come in one line.

like

A A

1 2 3 instead of that 1

2

3

it will dispaly this way.

Thanks

How to split cells in table format?

Cookies on SQLServerCentral