August 6, 2010 at 9:07 am
I'm starting to look at SSRS. Building a report from query that returns about 30 columns which are just too many for one row on the report. I need to spread the columns across two or more rows.
August 6, 2010 at 9:29 am
I assume you are referring to the look of the report as your column limit?
You can have up to 256 columns in Excel 2000/2003 and 16384 in 2007.
Can you provide an example of your desired output?
August 6, 2010 at 9:56 am
nano2nd (8/6/2010)
I'm starting to look at SSRS. Building a report from query that returns about 30 columns which are just too many for one row on the report. I need to spread the columns across two or more rows.
Don't be a crying baby 😀
On the old times "reports" were always printed and we used to have a hard 132 characters limit per line - now you can manage font types and sizes as it pleases you.
So... what's your question?
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.August 6, 2010 at 10:37 am
I would like the columns to wrap onto two or more rows of the report:
Item 1 Color Size Price Col 2 Col 3 Col 4 Col 5
Col 6 Col 7 Col 8 Col 9
Item 2 Color Size Price Col 2 Col 3 Col 4 Col 5
Col 6 Col 7 Col 8 Col 9
August 6, 2010 at 10:42 am
It's not me whining, it's those darn users. I remember 132 very well along with Excel addins like Sideways. Anyway, all I want to do is wrap the columns into a second row:
Item 1 Color Size Price Col 2 Col 3 Col 4 Col 5
Col 6 Col 7 Col 8 Col 9
Item 2 Color Size Price Col 2 Col 3 Col 4 Col 5
Col 6 Col 7 Col 8 Col 9
August 6, 2010 at 11:16 am
I've read this in some place... "...one solution is to have a reasonable fixed column width (such, as 30) and set the textbox CanGrow to True so it wraps to next line if needed."
Hope this helps.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.August 6, 2010 at 11:18 am
Very good, I'll give that try. Thanks for the help, I'll let you know how I make out.
August 6, 2010 at 11:45 am
That didn't help.
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply