44ce9029-6bc8-4088-9b9d-a3ec288fe642
SQL
11in
String
true
true
paramCompanyName
String
true
true
paramAddress
String
true
Start Date
String
true
EndDate
String
true
Year End Date
String
true
Level Name
true
8.5in
0.05in
false
0.4in
0.5in
0.29in
1eeb1b05-bef6-4686-8aa7-5c7cc173bb1a
8.27in
HeadType
System.String
Description
System.String
ValueUptoStartDate
System.Double
ValueTheseDates
System.Double
DummyDataSource
true
ReportData
dtIncomeExpenditure
7.36in
ReportData_dtIncomeExpenditure
=Fields!HeadType.Value
=IIF(Previous(Fields!HeadType.Value)="", True, False)
textbox15
19
true
textbox17
18
true
textbox19
17
true
textbox21
16
true
0.15in
15
true
=Fields!HeadType.Value
textbox6
14
true
textbox7
13
true
textbox9
12
true
0.22in
7
true
="TOTAL " & Fields!HeadType.Value
textbox2
6
true
=Sum(Fields!ValueUptoStartDate.Value)
textbox56
5
true
=Sum(Fields!ValueTheseDates.Value)
textbox54
4
true
=Sum(Fields!ValueUptoStartDate.Value + Fields!ValueTheseDates.Value)
0.22in
3
true
=Fields!Description.Value
2
true
=Fields!ValueUptoStartDate.Value
ValueTheseDates
1
true
=Fields!ValueTheseDates.Value
true
=Fields!ValueUptoStartDate.Value + Fields!ValueTheseDates.Value
0.19in
2
textbox20
33
true
=Parameters!CompanyName.Value
2
textbox45
32
true
="Print Date & Time: " & Format(Now(), "dd MMM yyyy, hh:mm:ss tt")
0.25in
4
textbox29
31
true
=Parameters!Address.Value
0.25in
4
textbox12
30
true
0.1in
2
29
true
="Income Expenditure (" & Parameters!LevelName.Value & ")"
2
textbox16
28
true
="Date range: " & Parameters!StartDate.Value & " to " & Parameters!EndDate.Value
0.24in
27
true
Description
26
true
Value from
textbox52
25
true
Value from
24
true
Total Value
0.19in
textbox10
23
true
textbox11
22
true
=Format(CDate(Parameters!YearEndDate.Value), "dd.MM.yy") & " to " & Format(DateAdd("d", -1, CDate(Parameters!StartDate.Value)), "dd.MM.yy")
21
true
=Format(CDate(Parameters!StartDate.Value), "dd.MM.yy") & " to " & Format(CDate(Parameters!EndDate.Value), "dd.MM.yy")
textbox13
20
true
0.19in
true
3.46in
1.3in
1.3in
1.3in
textbox35
11
true
NET PROFIT (INCOME - EXPENDITURE)
10
true
=SUM(IIF(Fields!HeadType.Value="INCOME", Fields!ValueUptoStartDate.Value, (-1*Fields!ValueUptoStartDate.Value)))
9
true
=SUM(IIF(Fields!HeadType.Value="INCOME", Fields!ValueTheseDates.Value, (-1*Fields!ValueTheseDates.Value)))
8
true
=SUM(IIF(Fields!HeadType.Value="INCOME", (Fields!ValueUptoStartDate.Value + Fields!ValueTheseDates.Value), (-1*(Fields!ValueUptoStartDate.Value + Fields!ValueTheseDates.Value))))
0.22in
2.22in
en-US
true
0.03583in
true
="Page " & Globals!PageNumber & " of " & Globals!TotalPages
0.20583in
true
0.4in
11.69in