Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Schedule Reports to execute and Export to Excel
- Thread starter davida37
- Start date
You can use Subscriptions to run the report. Within the subscription setup, you may specify the file format and location of the output
Rgds, Geoff
We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.
Please read FAQ222-2244 before you ask a question
Rgds, Geoff
We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.
Please read FAQ222-2244 before you ask a question
- Thread starter
- #3
We are scheduleing and exporting to excel, but what we are finding is that when you open the excel output, it has merged a few of the cells together and treats the cells as objects when you cut and paste from the output to another file. Wondering if anyone has had issues with their excel export output from MSRS
When exporting to excel, SSRS tries to keep the layout the same as when viewed on line or in pdf. What this means in practice is that any slight difference of alignment can cause cells to be merged in excel
As an example
Say you have 2 tables in a report.
One has 3 fields and the other has 5 fields.
They are laid out with the 3 field table directly above the 5 field table.
The 2 tables are the same width as the last field on the 3 field table is a "notes" field which is very wide.
When exporting to excel, the final field in the 3 field table will have merged cells as this is the only way in excel to replicate the layout in the report as columns in excel cannot be "unaligned" as they can in a free floating layout a la SSRS.
Hope this makes sense
Rgds, Geoff
We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.
Please read FAQ222-2244 before you ask a question
As an example
Say you have 2 tables in a report.
One has 3 fields and the other has 5 fields.
They are laid out with the 3 field table directly above the 5 field table.
The 2 tables are the same width as the last field on the 3 field table is a "notes" field which is very wide.
When exporting to excel, the final field in the 3 field table will have merged cells as this is the only way in excel to replicate the layout in the report as columns in excel cannot be "unaligned" as they can in a free floating layout a la SSRS.
Hope this makes sense
Rgds, Geoff
We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.
Please read FAQ222-2244 before you ask a question
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question