Please Share your Product Ideas with us!

All ideas are welcome. Just because the Idea doesn't make it into the product immediately does not make it a bad idea.

Excel report with Active Formula

Hi,


Excel formula outputed through SQL are intepreted as text upon excel files opening and needs to be "activated" (select cell, press enter).


Woud be very nice to allow direct excel formula in report output.


Example : Create a clickable URL link in excel to an online place (sharepoint) where reports are stored.

-> Very useful in a "meta" report, that holds other reports name / description / type / count


Best regards

Guillaume Brochet

  • Guillaume Brochet
  • Jul 15 2021
  • Future consideration
Advanced Data Migration (SST) / Migration Reporting
  • Jul 23, 2021

    Admin response

    We will review this but it comes down to what's possible in Excel and the third party plugin we use to support Excel integration. We will investigate and see what is possible.


    There is a product accelerator available to download via the support site that can integrate with Sharepoint, OneDrive, Teams from a file perspective already.


    In the existing HELP/ INSTRUCTIONs tab options in excel integration the implmentation team can put these sharepoint links in their spreadsheet already.

  • Attach files
  • Guillaume Brochet commented
    July 24, 2021 12:49

    Completely agree with Pedro.


    Excel output should be more customizable : Auto Filter -> Must Have,

    Add a logo, a date of report run, filename, colors etc ...


    I understand Syniti rely on third party plugin -> What's the name ? i'll submit my ideas there ;)

    ×

    Attachments Open full size

  • Pedro Cardoso commented
    July 22, 2021 23:14

    These are different asks, but sticking to the plot, excel downloaded data needs enhancement - level 1 spec here would simply ask for data types from underlying schema set being honored in excel formats. So format text as text, numerics as numerics, dates as date as a starting point for conversation.

    supporting keywords like link: to ensure hyperlink is created would be a great 4th but over and above. Let's deal with the text PLEASE. Also setting AUTOFILTER automatically on header row AND freezing top row - TABLE STAKES!!!

    Lots more to do here, but let's start with the basics.

    ×

    Attachments Open full size

  • Guillaume Brochet commented
    July 15, 2021 15:16

    Hi,


    Excel formula outputed through SQL are intepreted as text upon excel files opening and needs to be "activated" (select cell, press enter).


    Woud be very nice to allow direct excel formula in report output.


    Example : Create a clickable URL link in excel to an online place (sharepoint) where reports are stored.

    -> Very useful in a "meta" report, that holds other reports name / description / type / count


    Best regards

    Guillaume Brochet

    ×

    Attachments Open full size

Related ideas