Saving a report as XLS

When you save a report as an Excel file it typically (for most of my users) saves the column names as the first row (the names as defined in the returned data set from the SP).  However, I have one user who is not getting the names as the first row.  When she saves the report, row 1 contains the first record in the report.

Is this a user level preference?  If so, where would one look to change it?

 

Thanks!

  • This is what you’re looking for:

     

     

    Include Data Labels should be checked when saving.

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Levi Sauerbrei
    Sent: Tuesday, December 01, 2009 11:46 AM
    To: Ryan Creps
    Subject: [Tessitura Technical Forum] Saving a report as XLS

     

    When you save a report as an Excel file it typically (for most of my users) saves the column names as the first row (the names as defined in the returned data set from the SP).  However, I have one user who is not getting the names as the first row.  When she saves the report, row 1 contains the first record in the report.

    Is this a user level preference?  If so, where would one look to change it?

     

    Thanks!




    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!

  • Levi,

     

    There is a check box in the Select File Format window when saving a report called Include Data Labels…..make sure that check box is checked for the user. 

     

    Teresa

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Levi Sauerbrei
    Sent: Tuesday, December 01, 2009 10:46 AM
    To: Teresa Dean
    Subject: [Tessitura Technical Forum] Saving a report as XLS

     

    When you save a report as an Excel file it typically (for most of my users) saves the column names as the first row (the names as defined in the returned data set from the SP).  However, I have one user who is not getting the names as the first row.  When she saves the report, row 1 contains the first record in the report.

    Is this a user level preference?  If so, where would one look to change it?

     

    Thanks!




    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!

  • 9 minutes elapsed and the correct answer from two different directions!  Any wonder I love the Tessitura crowd?

     

    Thanks guys!