4 Replies Latest reply on Dec 7, 2017 12:42 PM by Bones23

    Deliver enitre Dashboard content using Agent

    Bones23

      Hi All,

       

      Sorry if this is a repeated question, but I have trawled the internet to no avail.

       

      I have a series of reports which are featured in a Dashboard which are required on a weekly basis by my colleagues, however when the Agent distributes the Dashboard; the Excel file only contains 75 rows of data per sheet. I know the tables are much larger than 75 rows as when I export the Entire Dashboard to excel it shows me the full content.

       

      I have temporarily circumvented this by adding the reports to a Briefing Book and delivering as a .mht file, which works for delivering the content; however it then relies on the recipient opening in IE and Exporting to Excel. My concern here is not only is it slightly time consuming but I have no control of the format of the data (potentially losing leading 0's and formatting required for lookups to work).

       

      So I think I have two questions:

       

      1) Am I approaching this problem in the correct way in the first instance?

      2) If this is the correct way to approach this problem, how do I increase the number of rows returned in the analysis featured in the Dashboard distributed via the Agent?

       

      Thanks in Advance