Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
monktrain
Starting Member
4 Posts |
 Posted - 2007-05-09 : 17:47:16
|
| I have a report with two columns. It works fine in SQL Reporting Services, but when I push it to the Report Server it only prints one column instead of the two that it's set up to print. What am I missing?D-Monk |
|
|
herothecat
Starting Member
19 Posts |
Posted - 2007-05-12 : 07:47:40
|
| I'm not exactly sure WHY this is the case, but multiple columned reports don't show correctly in or HTML or Excel. I'd check the others but don't have access to RS with all export options right now.It does however work when exporting to PDF.Export your report to PDF and you should most definitely see the multi-columns.Why push the envelope when you can just open it? |
 |
|
|
monktrain
Starting Member
4 Posts |
Posted - 2007-05-14 : 11:05:01
|
| Unfortunately, I have to use HTML. I create all my reports using SRS, then upload them to the Report Server. This, in turn, puts them into our implementation of Microsoft CRM. So these reports are going to be run by others from CRM, which is web-based. From there you can export it to PDF, but they will most likely just try to print it from the report viewer in CRM, and they are not very understanding people when they can't exactly see what they want. Thank you for your input, Hero.D-Monk |
|
|
|
karenros
Starting Member
37 Posts |
Posted - 2007-05-14 : 13:09:11
|
quote:
Originally posted by monktrain
I have a report with two columns. It works fine in SQL Reporting Services, but when I push it to the Report Server it only prints one column instead of the two that it's set up to print. What am I missing?D-Monk
Hey D-Monk, I am trying to do same thing but i cannot acheive it, can you please give the details steps of how u have used multiple columns, the goal of my sub report is that i want to snake the columns, like for eg, if my dataset has 9 rows i want to display 5 in the first column and the remaining 4 in the next column, can you please tell me how can i acheive this.RegardsKaren |
|
|
|
herothecat
Starting Member
19 Posts |
Posted - 2007-05-14 : 20:20:59
|
| Karen,One other thing about multi-column reports. A sub-report uses the same "column" settings as the "master" report. So if your main report has one, your sub will have one. This is regardless of the rendering format.Why push the envelope when you can just open it? |
|
|
|
|
|
|
|
|
SRS Printing only One of Two Columns