I am wondering if there is the ability when Merging a report after it has come up on your screen to Excel as opposed to Word?
I have tried to File/Merge the report and select All File Types and choose an excel file however it lauches a word doc with some gobbly gook and then crashes.
Any help would be ideal.
Thanks.
Daiva
Hi Daiva
If you just want to get the data into an Excel file, you can use File / Save As.
Two things to remember
- if you want to save it with column headings, you should tick the "Include Data Labels" box.
- The data you get out will be simply the full underlying dataset that is returned to the report by the stored proc - not grouped in any way, and including all the fields whether they're shown in the report or not.
Ken
Alas. Yes, this is possible however I want to merge it into a formatted excel file with the matching data labels to columns in Excel.
Removes having to reformat one excel sheet into another.
dj
Daiva Jocius
Director, Resource Development
403.294.7433 ex: 1104
dljocius@ATPlive.com
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Ken McSwain Sent: Thursday, December 17, 2009 5:34 PM To: Daiva Lynn Jocius Subject: Re: [Tessitura Technical Forum] Reports & Utilities/File/Merge to Microsoft EXCEL instead of Word?
From: Daiva Jocius <bounce-daivajocius8936@tessituranetwork.com> Sent: 12/17/2009 6:16:19 PM
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!
Ah... Don't think that's possible... You'll probably need to do some vba coding in Excel to pull the dataset you need using a stored proc, then put it where you want, rather than being able to push it in from a report. That can work quite well.
You'd need to create an odbc connection to your tessitura server on your machine, but once you've done that you should be able to run stored procedures directly from excel.
I have several spreadsheets running with the odbc connection and it works well. If you can't do that however, you could simply create a macro that takes the exported data from the report and merge it into your spreadsheet.
I have several macros like this which reformat the excel export and add some additional summary information.