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.AssemblyDetail_v1
• Report.BidGroup_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.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.Subcategory_v1
• Report.SubcontractorBid_v1
• Report.Unit_v1
• Report.WbsDefinition_v1
• Report.WbsValue_v1

Viewing columns in tables

You can use SQL Server Management Studio to view the names of columns in each table in the custom reports database.

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 database.
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.

      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.