md report

Database Table

Name	md_report
Prefix	rpt
Group Item	Admin module, Report Setup
Initial Build	2006.02

Overview

md_report is a metadata table. Report names, locations, parameters, and other report properties are stored in this table so that users can launch reports in netFORUM.

Columns

Name	Description	Datatype	Notes
rpt_key	Unique Key	av_key
rpt_name	Report Name	nvarchar(50)
rpt_description	Report Description	nvarchar(128)
rpt_path	Report Path	nvarchar(128)
rpt_file_name	File Name	nvarchar(128)
rpt_rdl_path	RDL Path	nvarchar(128)
rpt_rdl_file_name	RDL File Name	nvarchar(128)
rpt_hastoolbar	Has Toolbar?	av_flag
rpt_enabledrilldown	Enable Drill Down?	av_flag
rpt_separatepages	Separate Pages?	av_flag
rpt_pagetotreeratio	Page to Tree Ratio	av_float
rpt_obj_key	Report Object	av_key
rpt_sql	Override SQL	av_text
rpt_external	Run Report From	av_flag
rpt_has_parameters	Has Parameters?	av_flag
rpt_ignore_stored_images_flag	Ignore Stored Images?	av_flag
rpt_output_format	Output Format	nvarchar(10)
rpt_report_provider	Report Provider	nvarchar(50)
rpt_enable_dashboard_flag	Enable Dashboard	av_flag
rpt_cached_flag	report cached	av_flag
rpt_data_driven_subscription_flag	data-driven subscription	av_flag
rpt_subscription_query	data-driven subscription query	av_text
rpt_email_to	Map email To	nvarchar
rpt_email_cc	Map email Cc	nvarchar
rpt_email_reply_to	Map reply-to	nvarchar
rpt_email_subject	Map email subject	nvarchar
rpt_add_user	Add User	av_user
rpt_add_date	Add Date	av_date
rpt_change_user	Change User	av_user
rpt_change_date	Change Date	av_date
rpt_delete_flag	Delete Flag	av_delete_flag
rpt_entity_key	Entity Key	av_key

Parent Tables

Parent Table	Parent Key	Child Key	Join
md_object	obj_key	rpt_obj_key	rpt_obj_key = obj_key

Child Tables

Child Table	Parent Key	Child Key	Join
cm_group_item_link	rpt_key	cgl_rpt_key	cgl_rpt_key = rpt_key
md_report_parameter	rpt_key	rpp_rpt_key	rpp_rpt_key = rpt_key
ts_report_task	rpt_key	tsr_rpt_key	tsr_rpt_key = rpt_key