How to merge whole Column to get end result-a Single Cell

Question

Viewing 6 posts - 1 through 6 (of 6 total)

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

hernan.ruggiano SSC Rookie Points: 34 More actions · Answer 1

SSC Rookie

Points: 34

March 24, 2009 at 10:49 am

Could you post the query you are using please?

maxE Valued Member Points: 67 More actions · Answer 2

actually its not the Database problem.

I am getting this problem in REPORTING SERVICES.

I have a table and have to make first column appear as a single cell(as in image) with all rows merge for that only column dynamically.

thanks for your reply though..

hernan.ruggiano SSC Rookie Points: 34 More actions · Answer 3

If i understood what you are asking, here is the code

declare @idemp nvarchar(max) ,@onecell nvarchar(max);

declare curs cursor for

select FIELD from TABLE

open curs

fetch next from curs into @idemp;

set @onecell = ' ';

while @@FETCH_STATUS = 0

begin

set @onecell = @onecell + ' ' + @idemp ;

fetch next from curs into @idemp;

end

close curs

deallocate curs

select @onecell;

What this does is to put all the results from the query into one cell, the answer was cursors.

Tell me if it helps.

Hernan.-

maxE Valued Member Points: 67 More actions · Answer 4

again, thanks for your reply

but as i said its not the backend problem , rather its a UI problem.

I am using reporting services to generate report and i have a table , in that table the value in first column is static.

i have to make that column with static value, dynamically merged,depending on the number of rows generating dynamically in other columns.

Bajrang SSCrazy Points: 2074 More actions · Answer 5

Select all of the columns and right click on that. Select MergeCells

Done.

Hope that helps

-RP