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
  • 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
    24 Jul, 2021 12:49pm

    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 ;)

  • Pedro Cardoso commented
    22 Jul, 2021 11:14pm

    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.

  • Guillaume Brochet commented
    15 Jul, 2021 03:16pm

    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