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 |
|
michael_aussie
Starting Member
15 Posts |
 Posted - 2010-04-12 : 00:14:24
|
| I would like "SQL Server Reporting Services" to generate an Excel file, that is preformatted for printing.The formatting I require includes:1. Printing ONE page wide.2. Repeat printing designated rows at the top of each sheet.3. Row height set to a certain value.4. Headers and footers.Currently we are generating the reports and then formatting by hand theses features in the spread sheet every time. |
|
|
gavakie
Posting Yak Master
221 Posts |
Posted - 2010-04-13 : 14:26:53
|
| You can setup the page layout in the report properties, you can also create the reports in excel themselves. Run your query by an ODBC or something. |
 |
|
|
michael_aussie
Starting Member
15 Posts |
Posted - 2010-04-28 : 03:00:08
|
quote:
Originally posted by gavakie
You can setup the page layout in the report properties, you can also create the reports in excel themselves. Run your query by an ODBC or something.
I have setup the page layouts in report properties. These properties are not detailed enough to handle things like "fit to one page wide".These properties in some cases are not handed over to the excel output (row height expands to accommodate large items even when I "untick" "expand to accommodate contents", the excel output still expands to accommodate the largest item.I can not do this under an ODBC connection. That defeats the benefits of using "reporting services". |
|
|
|
|
|
|
formatting Excel generated reports