Table: dbo.Global_Report_Profile_Element
This table will contain an entry for each report contained within a report profile. Each entry will have a key to link to a report definition, and a report option xml file. Together, the report definition xml and the report option xml describe how to print a report.
Columns
NameTypeConstraintsDescription
global_report_profile_element_KEYint (4)NOT NULLPrimary key
global_report_profile_KEYint (4)NOT NULLThe key of the parent report profile to which this report profile element is linked.
report_definition_KEYint (4)NOT NULLThe report profile definition KEY. Links us to a report/report definition record.
report_option_xmlnvarchar (-1)NOT NULLcontains the xml string of the descriptions for this report profile report.
Primary key
NameColumnsDescription
PK_Global_Report_Profile_Elementglobal_report_profile_element_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Global_Report_Profile_Element__Global_Report_Profile__global_report_profile_KEYglobal_report_profile_KEYGlobal_Report_Profile (global_report_profile_KEY)
FK_Global_Report_Profile_Element__Report_Definition__report_definition_KEYreport_definition_KEYReport_Definition (report_definition_KEY)

Schema diagram