Table: dbo.Report_Profile_Element
This table will contain an entry for each report contained within a client specific override of a global 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
report_profile_element_KEY | int (4) | NOT NULL | Primary key
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_Report_Profile_Element | report_profile_element_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Report_Profile_Element__Report_Definition__report_definition_KEY | report_definition_KEY | Report_Definition (report_definition_KEY) |
FK_Report_Profile_Element__Report_Profile__report_profile_KEY | report_profile_KEY | Report_Profile (report_profile_KEY) |