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
Name | Type | Constraints | Description
global_report_profile_element_KEY | int (4) | NOT NULL | Primary key
global_report_profile_KEY | int (4) | NOT NULL | The key of the parent report profile to which this report profile element is linked.
report_definition_KEY | int (4) | NOT NULL | The report profile definition KEY. Links us to a report/report definition record.
report_option_xml | nvarchar (-1) | NOT NULL | contains the xml string of the descriptions for this report profile report.

Primary key
Name | Columns | Description
PK_Global_Report_Profile_Element | global_report_profile_element_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Global_Report_Profile_Element__Global_Report_Profile__global_report_profile_KEY | global_report_profile_KEY | Global_Report_Profile (global_report_profile_KEY) |
FK_Global_Report_Profile_Element__Report_Definition__report_definition_KEY | report_definition_KEY | Report_Definition (report_definition_KEY) |