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 |
|
adam3291
Starting Member
8 Posts |
 Posted - 2002-03-14 : 13:26:29
|
| Trying to setup up page margins in my TSQL Report. Is this possible. I use SET RMARGIN = 80 on my other version SQL we run here. No Go in TSQL.Thanks |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-03-14 : 13:34:24
|
| T-SQL doesn't have any setting for any margins or other page layout features (never did as far as I can tell). The query analyzer only returns results, it is not intended to format the output as a report. How do you (or your users) run these reports? Is there a front-end application that they use? |
 |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2002-03-15 : 13:13:37
|
quote:
I use SET RMARGIN = 80 on my other version SQL we run here. No Go in TSQL.
That "other version SQL" wouldn't happen to be a totally different database server like mySQL or Sybase instead of a different version number of SQL Server, would it?------------------------GENERAL-ly speaking... |
|
|
|
adam3291
Starting Member
8 Posts |
Posted - 2002-03-15 : 13:19:35
|
| Yes, it a midrange system based SQL. |
|
|
|
smccreadie
Aged Yak Warrior
505 Posts |
Posted - 2002-03-15 : 14:17:09
|
| Use MS Access or a third party tool like Crystal Reports to do actual reporting. You can also use a browser to help control printing. |
|
|
|
|
|
|
setup up page margins in my TSQL Report