-
Notifications
You must be signed in to change notification settings - Fork 1
/
BillingDetails.frx
86 lines (86 loc) · 8.59 KB
/
BillingDetails.frx
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
<?xml version="1.0" encoding="utf-8"?>
<Report ScriptLanguage="CSharp" ReportInfo.Created="03/12/2022 15:44:41" ReportInfo.Modified="03/12/2022 17:48:18" ReportInfo.CreatorVersion="2022.1.0.0">
<Dictionary>
<BusinessObjectDataSource Name="BillingDetailsData" ReferenceName="BillingDetailsData" DataType="null" Enabled="true">
<Column Name="RptSubTitle" DataType="System.String"/>
<BusinessObjectDataSource Name="Customers" DataType="null" Enabled="true">
<Column Name="CustomerId" DataType="System.Int64"/>
<Column Name="Name" DataType="System.String"/>
<BusinessObjectDataSource Name="WorkItems" DataType="null" Enabled="true">
<Column Name="WorkItemId" DataType="System.Int64"/>
<Column Name="Title" DataType="System.String"/>
<Column Name="DateCreated" DataType="System.DateTime"/>
<Column Name="IsCompleted" DataType="System.Boolean" BindableControl="CheckBox"/>
<Column Name="IsFixedPriced" DataType="System.Boolean" BindableControl="CheckBox"/>
<BusinessObjectDataSource Name="TimeEntries" DataType="null" Enabled="true">
<Column Name="Description" DataType="System.String"/>
<BusinessObjectDataSource Name="Details" DataType="null" Enabled="true">
<Column Name="TimeStart" DataType="System.DateTime"/>
<Column Name="TimeEnd" DataType="System.DateTime"/>
<Column Name="DurationHrs" DataType="System.Int32"/>
<Column Name="DurationMins" DataType="System.Int32"/>
</BusinessObjectDataSource>
<Column Name="TotalDurationHrs" DataType="System.Int32"/>
<Column Name="TotalDurationMins" DataType="System.Int32"/>
</BusinessObjectDataSource>
<Column Name="TotalDurationHrs" DataType="System.Int32"/>
<Column Name="TotalDurationMins" DataType="System.Int32"/>
</BusinessObjectDataSource>
<Column Name="TotalDurationHrs" DataType="System.Int32"/>
<Column Name="TotalDurationMins" DataType="System.Int32"/>
</BusinessObjectDataSource>
</BusinessObjectDataSource>
</Dictionary>
<ReportPage Name="Page1" Landscape="true" PaperWidth="297" PaperHeight="210" RawPaperSize="9" Watermark.Font="Arial, 60pt">
<ReportTitleBand Name="ReportTitle1" Width="1047.06" Height="45.36">
<TextObject Name="Text1" Width="1048.95" Height="23.79" Anchor="Top, Left, Right" Text="Billing Details Report" HorzAlign="Center" Font="Arial, 14.25pt, style=Bold"/>
<TextObject Name="Text2" Top="26.46" Width="1047.06" Height="18.9" Text="[BillingDetailsData.RptSubTitle]" HorzAlign="Center" Font="Arial, 11.25pt"/>
</ReportTitleBand>
<PageHeaderBand Name="PageHeader1" Top="49.36" Width="1047.06" Height="43.47">
<TextObject Name="Text4" Width="94.5" Height="18.9" Text="Customer" VertAlign="Bottom" Font="Arial, 10pt, style=Bold"/>
<TextObject Name="Text6" Left="34.02" Top="18.9" Width="226.8" Height="18.9" Text="WorkItem" VertAlign="Bottom" Font="Arial, 10pt, style=Bold"/>
<TextObject Name="Text9" Left="260.82" Top="18.9" Width="90.72" Height="18.9" Text="Date Created" VertAlign="Bottom" Font="Arial, 10pt, style=Bold"/>
<TextObject Name="Text10" Left="355.17" Width="75.6" Height="18.9" Text="Completed" VertAlign="Bottom" Font="Arial, 10pt, style=Bold"/>
<TextObject Name="Text12" Left="433.06" Width="45.36" Height="37.8" Text="Fixed Price" VertAlign="Bottom" Font="Arial, 10pt, style=Bold"/>
<TextObject Name="Text14" Left="480.98" Width="241.92" Height="18.9" Text="Time Entry" VertAlign="Bottom" Font="Arial, 10pt, style=Bold"/>
<TextObject Name="Text16" Left="726.68" Width="120.96" Height="18.9" Text="TimeStart" VertAlign="Bottom" Font="Arial, 10pt, style=Bold"/>
<TextObject Name="Text18" Left="850.5" Width="120.96" Height="18.9" Text="TimeEnd" VertAlign="Bottom" Font="Arial, 10pt, style=Bold"/>
<TextObject Name="Text20" Left="971.46" Width="71.82" Height="18.9" Text="H:M" VertAlign="Bottom" Font="Arial, 10pt, style=Bold"/>
<LineObject Name="Line2" Top="37.8" Width="1047.06"/>
</PageHeaderBand>
<GroupHeaderBand Name="GroupHeader1" Top="96.83" Width="1047.06" Height="18.9" Condition="[BillingDetailsData.Customers.Name]">
<TextObject Name="Text7" Width="241.92" Height="18.9" Text="[[BillingDetailsData.Customers.Name]]" Font="Arial, 10pt"/>
<GroupHeaderBand Name="GroupHeader2" Top="119.73" Width="1047.06" Height="18.9" Condition="[BillingDetailsData.Customers.WorkItems.Title]">
<TextObject Name="Text3" Left="34.02" Width="223.02" Height="18.9" Text="[[BillingDetailsData.Customers.WorkItems.Title]]" Font="Arial, 10pt"/>
<TextObject Name="Text8" Left="260.82" Width="90.72" Height="18.9" Text="[BillingDetailsData.Customers.WorkItems.DateCreated]" Format="Date" Format.Format="d" Font="Arial, 10pt"/>
<TextObject Name="Text11" Left="355.17" Width="75.6" Height="18.9" Text="[IIf([BillingDetailsData.Customers.WorkItems.IsCompleted],"Yes","No")]" HorzAlign="Center" Font="Arial, 10pt"/>
<TextObject Name="Text13" Left="433.06" Width="45.36" Height="18.9" Text="[IIf([BillingDetailsData.Customers.WorkItems.IsFixedPriced],"Yes","No")]" HorzAlign="Center" Font="Arial, 10pt"/>
<GroupHeaderBand Name="GroupHeader3" Top="142.63" Width="1047.06" Height="37.8" Condition="[BillingDetailsData.Customers.WorkItems.TimeEntries.Description]">
<TextObject Name="Text5" Left="480.98" Width="241.92" Height="18.9" Text="[[BillingDetailsData.Customers.WorkItems.TimeEntries.Description]]" Font="Arial, 10pt"/>
<DataBand Name="Data1" Top="184.43" Width="1047.06" Height="18.9" DataSource="Customers">
<TextObject Name="Text15" Left="726.68" Width="120.96" Height="18.9" Text="[BillingDetailsData.Customers.WorkItems.TimeEntries.Details.TimeStart]" Format="Date" Format.Format="d" Font="Arial, 10pt"/>
<TextObject Name="Text17" Left="850.5" Width="120.96" Height="18.9" Text="[BillingDetailsData.Customers.WorkItems.TimeEntries.Details.TimeEnd]" Format="Date" Format.Format="d" Font="Arial, 10pt"/>
<TextObject Name="Text19" Left="971.46" Width="71.82" Height="18.9" Text="[ToString([BillingDetailsData.Customers.WorkItems.TimeEntries.Details.DurationHrs])] + ":" + [ToString([BillingDetailsData.Customers.TotalDurationMins])]" Font="Arial, 10pt"/>
</DataBand>
<GroupFooterBand Name="GroupFooter3" Top="207.33" Width="1047.06" Height="22.68">
<LineObject Name="Line1" Left="971.46" Width="71.82"/>
<TextObject Name="Text21" Left="971.46" Width="71.82" Height="18.9" Text="[ToString([BillingDetailsData.Customers.WorkItems.TotalDurationHrs])]+":"+[ToString([BillingDetailsData.Customers.WorkItems.TotalDurationMins])]" Font="Arial, 10pt, style=Bold"/>
<TextObject Name="Text22" Left="438.48" Width="532.98" Height="18.9" Text=""Total for Time Entry '"+[BillingDetailsData.Customers.WorkItems.TimeEntries.Description]+"':'" HorzAlign="Right" Font="Arial, 10pt, style=Bold"/>
<LineObject Name="Line3" Left="480.06" Top="18.9" Width="559.44"/>
</GroupFooterBand>
</GroupHeaderBand>
<GroupFooterBand Name="GroupFooter2" Top="234.01" Width="1047.06" Height="37.8">
<TextObject Name="Text23" Left="971.46" Width="71.82" Height="18.9" Text="[ToString([BillingDetailsData.Customers.WorkItems.TotalDurationHrs])]+":"+[ToString([BillingDetailsData.Customers.WorkItems.TotalDurationMins])]" Font="Arial, 10pt, style=Bold"/>
<TextObject Name="Text24" Left="253.26" Width="718.2" Height="18.9" Text=""Total for Work Item '"+[BillingDetailsData.Customers.WorkItems.Title]+"':'" HorzAlign="Right" Font="Arial, 10pt, style=Bold"/>
<LineObject Name="Line4" Left="34.02" Top="18.9" Width="1005.48"/>
</GroupFooterBand>
</GroupHeaderBand>
<GroupFooterBand Name="GroupFooter1" Top="275.81" Width="1047.06" Height="37.8">
<TextObject Name="Text25" Left="971.46" Width="71.82" Height="18.9" Text="[ToString([BillingDetailsData.Customers.TotalDurationHrs])]+":"+[ToString([[BillingDetailsData.Customers.TotalDurationMins]])]" Font="Arial, 10pt, style=Bold"/>
<TextObject Name="Text26" Left="147.42" Width="824.04" Height="18.9" Text=""Total for Customer '"+[BillingDetailsData.Customers.Name]+"':'" HorzAlign="Right" Font="Arial, 10pt, style=Bold"/>
<LineObject Name="Line5" Top="18.9" Width="1039.5"/>
</GroupFooterBand>
</GroupHeaderBand>
<PageFooterBand Name="PageFooter1" Top="317.61" Width="1047.06" Height="18.9"/>
</ReportPage>
</Report>