0
SQL
DataSource
DocumentNoSystem.StringCustomerNameSystem.StringCustomerAddressSystem.StringDocumentDateSystem.DateTimeDescriptionSystem.StringQuantitySystem.DecimalUnitPriceSystem.DecimalLineAmountSystem.DecimalAmountFormatSystem.StringShowUnitPriceCompanyPicture
8cm2.5cm
3cm3.5cm
0.1cmtruetrue=First(Fields!CustomerName.Value) + Chr(177) + First(Fields!CustomerAddress.Value) + Chr(177) + First(Fields!DocumentNo.Value) + Chr(177) + Format(First(Fields!DocumentDate.Value), "d")40.7cmtruetrueDescriptiontruetrueQuantitytruetrueUnit price=IIF(First(Fields!ShowUnitPrice.Value) = True, False, True)truetrueAmount0.6cmtruetrue=Fields!Description.Valuetruetrue=Fields!Quantity.Valuetruetrue=Fields!UnitPrice.Value=IIF(Fields!ShowUnitPrice.Value = True, False, True)truetrue=Fields!LineAmount.Value0.7cmtruetrueTotal3truetrue=Sum(Fields!LineAmount.Value)
=Fields!DocumentNo.Value
Between
trueAfter
Aftertrue
Before
DataSet_Result
0cm0cm2.1cm17cm
2.1cm
17cm
4cmtruetrue
truetrueSales Invoice0cm0cm0.9cm9cmDatabase
=Convert.ToBase64String(First(Fields!CompanyPicture.Value, "DataSet_Result"))
image/pngFitProportional
0cm11cm1.8cm6cmtruetrue="Invoice " & Choose(3, Split(CStr(ReportItems!HeaderValues.Value), Chr(177)))1.1cm0cm0.6cm9cmtruetrue="Date: " & Choose(4, Split(CStr(ReportItems!HeaderValues.Value), Chr(177)))1.7cm0cm0.6cm9cmtruetrue=Choose(1, Split(CStr(ReportItems!HeaderValues.Value), Chr(177)))2.5cm0cm0.6cm9cmtruetrue=Choose(2, Split(CStr(ReportItems!HeaderValues.Value), Chr(177)))3.1cm0cm0.6cm9cm
1cmtruetrue
truetrue="Printed by " & User!UserID0.2cm0cm0.6cm9cmtruetrue="Page " & Globals!PageNumber & " of " & Globals!TotalPages0.2cm11cm0.6cm6cm
29.7cm21cm
2cm2cm2cm2cm
en-US
Cm