May 19, 2006 at 8:43 am
Hey guys got another one for ya,
Alright I have a Subreport or even a report for that matter where I just want a list to be able to have multiple columns. Now one problem I have is just getting the list to be in multiple column format while the rest of the report is free form. 2nd problem I have is how do I get the multiple columns to pring left to right instead of top to bottom. For example how can i get the 2nd entry to print in the 2nd column instead of in the 2nd row of the 1st column. Thanks again guys.
Mickas
May 22, 2006 at 8:00 am
This was removed by the editor as SPAM
May 22, 2006 at 8:34 am
I"m afraid I don't have an answer for you, either. I'm currently working on multiple column reports (mailing labels, actually). My problem is this; I have it set to print 3 columns, but it's only populating data on the left-most column. It won't display anything on the center or right columns. Does anyone have any suggestions?
May 22, 2006 at 12:33 pm
Well I don't have an exact answer for you either but what ive read is SQL Reporting Services handles column reports as if it was a page cut in half. So basically it will print top to bottom and then go to the next column. You can probably see this being visible if you export to excel. It does not come up in the preview tab.
May 23, 2006 at 6:54 am
Why don't you write a stored procedure which displays a variable that is made to store each and every row in the column to concatenate with it selves seperated by a space using a cursor which is used to hold each and every row.
1) declare variable with max datatype
2) declare cursor
3) concatenate each fetch with the same variable
4)display the variable at the end
Hope you got the idea. if you want me to be more clear .pls reply back
Regards
Raj Deep.A
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply