%@ CodeTemplate Debug="True" Language="C#" Debug="True" TargetLanguage="XML" Description="Creates a master/detail report in RDL format." %>
<%@ Property Name="ReportName" Type="System.String" Default="Master/Detail Report" Category="Summary" Description="The name of the report." %>
<%@ Property Name="MasterDisplayColumns" Type="CodeSmith.CustomProperties.StringCollection" Category="Master" Description="The columns to include in the master view." %>
<%@ Property Name="DetailDisplayColumns" Type="CodeSmith.CustomProperties.StringCollection" Category="Detail" Description="The columns to include in the master view." %>
<%@ Assembly Name="SchemaExplorer" %>
<%@ Assembly Name="CodeSmith.CustomProperties" %>
<%@ Import Namespace="SchemaExplorer" %>
<%@ Import Namespace="System.Text" %>
<% ValidateProperties(); %>
1in
2
0.375in
textbox10
0.25in
5.25in
true
<%= ReportName %>
1
textbox9
0.375in
3.875in
true
<%= MasterTable.Database.Name %>
0.875in
<% for (int i = 0; i < MasterDetailKeySchema.PrimaryKeyMemberColumns.Count; i++) { %>
=Fields!<%= MasterDetailKeySchema.PrimaryKeyMemberColumns[i].Name %>.Value
<% } %>
6.25in
<%= MasterTable.Database.Name %>
7
<%= MasterDisplayColumns.Count * .25 %>in
0in
5.75in
6
0.25in
<% for (int i = 0; i < DetailDisplayColumns.Count; i++) { %>
Header">
7
<%= MasterDisplayColumns.Contains(DetailDisplayColumns[i]) ? "Expr" + i : DetailDisplayColumns[i] %>Header
true
true
<%= MasterDisplayColumns.Contains(DetailDisplayColumns[i]) ? "Expr" + i : DetailDisplayColumns[i] %>
<% } %>
0.25in
<% for (int i = 0; i < DetailDisplayColumns.Count; i++) { %>
">
3
<%= MasterDisplayColumns.Contains(DetailDisplayColumns[i]) ? "Expr" + i : DetailDisplayColumns[i] %>
true
true
=Fields!<%= MasterDisplayColumns.Contains(DetailDisplayColumns[i]) ? "Expr" + i : DetailDisplayColumns[i] %>.Value
<% } %>
<%= MasterDisplayColumns.Count * .25 %>in
<% for (int i = 0; i < DetailDisplayColumns.Count; i++) { %>
0.75in
<% } %>
5.75in
<% for (int i = 0; i < MasterDisplayColumns.Count; i++) { %>
5
<%= i * .25 %>in
<%= MasterDisplayColumns[i] %>
0.25in
2.375in
true
=First(Fields!<%= MasterDisplayColumns[i] %>.Value)
<% } %>
2.625in
1in
<%= Guid.NewGuid() %>
SQL
<%= MasterTable.Database.ConnectionString %>
true
6.5in
<% for (int i = 0; i < MasterDisplayColumns.Count; i++) { %>
<%= MasterDisplayColumns[i] %>
<%= MasterTable.Columns[MasterDisplayColumns[i]].SystemType.FullName %>
<% } %>
<% for (int i = 0; i < DetailDisplayColumns.Count; i++) { %>
">
<%= MasterDisplayColumns.Contains(DetailDisplayColumns[i]) ? "Expr" + i : DetailDisplayColumns[i] %>
<%= DetailTable.Columns[DetailDisplayColumns[i]].SystemType.FullName %>
<% } %>
<%= MasterTable.Database.Name %>
<%= GenerateSQLStatement() %>
1in
true
true
<%= Guid.NewGuid() %>
1in