Insert the Report Object’s Data into Excel

• Select the DBxtra Report Object from within the Project Explorer.

• Double click it.
• Select:
  • Excel Static Data
    This inserts the raw static data into Excel.
  • Excel Live Data
    This inserts a live real time connected data set into Excel
  • Excel Live Pivot Table
    This inserts a live real time connected data set into Excel.
    • Optionally, you can choose to also insert a live real time connected Pivot Chart.
      The XL Reporting Service t creates a new sheet with it.

    Note: The Pivot Chart will be bound to the Pivot Table.
    That means: whenever you change pivot settings to either the table or the chart the table / chart will also be updated to the same parameters.

    

• All prior options allow you to either insert the data into a new Excel sheet or into a specified range.
  • If you select “New Sheet” then the data will be inserted in a new Excel sheet and the name of the Report Object will be assigned to it (max. 20 characters).

  

  • If you select Existing Sheet then you must assign either a cell or point the mouse to an Excel cell.
• Choose if to add a title – the Report Object’s name – above the data.

• Choose if to add column headers – the XLReport Query – column headers – above the data.

Parameters

When the DBxtra Report Object has an assigned parameter then the Parameter window will open.

When a Parameter Report Object is inserted into Excel it will show a comment above the data which displays the parameter values. Hover over the comment to view its text.

Note! If you convert – format – your data set to an Excel table, then the live data connection will be lost and the data set will be converted as static data.