Using Sage Estimating Data on Reports

Report Manager can report data from the following tables (in the Report Design database) and views (in the Estimates database):

  • Report.Addon_v1
  • Report.AddonBasis_v1
  • Report.Address_v1
  • Report.Alternate_v1
  • Report.AlternateStatus_v1
  • Report.Assembly_v1
  • Report.AssemblyAttachment_v1
  • Report.AssemblyDetail_v1
  • Report.BidGroup_v1
  • Report.Branch_v1
  • Report.CityCostIndex_v1
  • Report.CityCostIndexDetail_v1
  • Report.Company_v1
  • Report.Crew_v1
  • Report.CrewDetail_v1
  • Report.CrewResource_v1
  • Report.Estimate_v1
  • Report.GroupAssembly_v1
  • Report.GroupCrew_v1
  • Report.GroupModel_v1
  • Report.GroupPhase_v1
  • Report.Item_v1
  • Report.ItemAddonAllocation_v1
  • Report.ItemAttachment_v1
  • Report.ItemWbsValue_v1
  • Report.MaterialClass_v1
  • Report.Model_v1
  • Report.ModelLine_v1
  • Report.NamedNote_v1
  • Report.Overline_v1
  • Report.Person_v1
  • Report.Phase_v1
  • Report.ProjectInfo_v1
  • Report.RateTable_v1
  • Report.RateTableColumnHeading_v1
  • Report.RateTableDetail_v1
  • Report.ReportOptions_v1
  • Report.Subcategory_v1
  • Report.SubcontractorBid_v1
  • Report.Totals_v1
  • Report.Unit_v1
  • Report.WbsDefinition_v1
  • Report.WbsValue_v1

The same tables are available in external reports databases.

Viewing columns in tables

You can use SQL Server Management Studio to view the names of columns in each table in Report Design databases and in external reports databases.

To view tables and columns using SQL Server Management Studio:

  1. Start Microsoft SQL Server Management Studio.
  2. In the Connect to Server window, connect to the SQL Server instance.
  3. For Server type, select Database Engine.
  4. For Server name, select your Sage Estimating server.
  5. In the Object Explorer:
    1. Expand the Databases node.

    2. Expand the *ReportDesign* database.

      You can also expand a database created for external reports.

      This custom reports database is a copy of your data that you use exclusively for creating reports.

    3. Expand Tables.

      The Object Explorer displays a list of tables from the custom reports database.

    4. To view a list of the columns available in a table:
      1. Expand the table.
      2. Expand Columns.