May 6, 2009 at 3:47 am
Hello,
I'm trying to create a report that has lots of data. The format is:
Header
Info 1
Info 2
Info 3
Details
What I want the report to do is spread the data to a second column instead of jumping to a new page. When the second column is full, it has to continue on a new page or when the grouping requires to use a new page.
Can anyone help me as I'm totally clueless atm.
Regards
May 6, 2009 at 7:50 am
I'm not sure exactly what you want to do, but I do know that multi-column reporting is a weakness in SSRS.
Here are a couple of links that may help:
http://msdn.microsoft.com/en-us/library/aa179433(SQL.80).aspx
http://jagbarcelo.blogspot.com/2007/04/partial-multi-column-reports-in.html
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
May 6, 2009 at 8:04 am
Thanks for the reply Jack!
I think I should try and explain what I need to do better...
I have a 2 col report. The first column will always have data. The second might have data. The way things are working atm, the 2nd column always has data.
Current situation:
Header1 Header2
Info1.0 Info2.0
Info1.1 Info2.1
Info1.2 Info2.2
The Info1 list might be long enough to span both columns though. When it isn't, I want the second list (Header2) to appear on the next page and leave the 2nd column blank.
The result should be like these examples:
Header1
Info1.0
Info1.1
Info1.2
Header2
Info2.0
Info2.1
Info2.2
and
Header1
Info1.0 Info1.3
Info1.1 Info1.4
Info1.2
Header2
Info2.0
Info2.1
Info2.2
Hope this makes my need a bit more transparent.
May 11, 2009 at 12:45 am
Does anyone have a clue as to how to do this? I'm in dire need of a sollution :crazy:
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply