ea9af9b5-2e6b-4d8a-82c6-9d59316a5525
SQL
Data Source=DOROTA-PC\SQL2005MSDN;Initial Catalog=BAZA_REKLAM;Integrated Security=True
29.7cm
true
21cm
0.25cm
true
1cm
1cm
1cm
d7fe51ce-bfa1-4e07-a5ae-cbc3e5238ca4
21cm
LastName
System.String
OrganizationName
System.String
Address
System.String
City
System.String
PostalCode
System.String
Country
System.String
Nip
System.String
ContactName
System.String
State
System.String
PhoneNumber
System.String
FaxNumber
System.String
Note
System.String
data
System.DateTime
Adres_Fkatura
System.String
Adres_Kor
System.String
Email
System.String
Aktywny
System.Boolean
Platnik_VAT
System.Boolean
UserName
System.String
http
System.String
regon
System.String
VIES
System.Int16
krs
System.String
Modify_User
System.String
Last_Modify
System.DateTime
CustomerID
System.Int32
FirstName
System.String
testowe
SELECT TOP 20 CustomerID, FirstName, LastName, OrganizationName, Address, City, State, PostalCode, Country, Nip, ContactName, PhoneNumber, FaxNumber,
Note, data, Adres_Fkatura, Adres_Kor, Platnik_VAT, Aktywny, Email, UserName, Last_Modify, Modify_User, http, VIES, regon, krs
FROM KLIENCI
true
REKLAMADataSet
KLIENCI
KLIENCITableAdapter
Fill
GetData
18.75cm
1cm
0.25cm
REKLAMADataSet_KLIENCI
0.5cm
11
3.75cm
3
true
adres korespondencyjny:
Adres_Kor
4.25cm
2
true
3.75cm
=First(Fields!Adres_Kor.Value)
2.25cm
1
true
8.25cm
adres faktura:
Adres_Fkatura
4.75cm
true
10.5cm
=First(Fields!Adres_Fkatura.Value)
9.75cm
17.25cm
0.5cm
9cm
2.78968cm
10
true
5.5cm
0.5cm
=iif(Fields!VIES.Value<>nothing,iif(Fields!VIES.Value=true,"TAK","NIE"),"-")
VIES
9cm
1.25cm
9
true
4.5cm
0.5cm
VIES:
Nip_1
9cm
2.53968cm
8
true
1.5cm
0.5cm
=Fields!Nip.Value
Nip
9cm
1cm
7
true
0.5cm
0.5cm
NIP:
data
0.75cm
3.5cm
6
true
14.25cm
0.5cm
=Fields!data.Value
UserName
0.25cm
3.5cm
5
true
14.25cm
0.5cm
=Fields!UserName.Value
4
2.25cm
17.25cm
textbox24
19
true
adres:
textbox25
18
true
=Fields!Address.Value
textbox26
17
true
tel:
textbox27
16
true
=Fields!PhoneNumber.Value
0.63492cm
textbox15
15
true
miasto:
textbox16
14
true
=Fields!City.Value
textbox17
13
true
fax:
textbox28
12
true
=Fields!FaxNumber.Value
0.63492cm
textbox12
11
true
kod pocztowy:
textbox13
10
true
=Fields!PostalCode.Value
textbox14
9
true
kontakt:
textbox29
8
true
=Fields!ContactName.Value
0.63492cm
2.25cm
5.75cm
1.5cm
7.75cm
3.1746cm
0.5cm
textbox1
1.5cm
17.25cm
3
true
0.5cm
0.63492cm
Dane adresowe:
=Fields!CustomerID.Value
5.75cm
OsobyDoKontaktu
17.25cm
2
0.5cm
2.25cm
FirstName
0.25cm
13.25cm
1
true
0.5cm
0.75cm
=Fields!FirstName.Value & chr(13) & CHR(10) & iif(Fields!LastName.Value = nothing,"",Fields!LastName.Value & chr(13) & CHR(10)) & iif(Fields!OrganizationName.Value = nothing,"",Fields!OrganizationName.Value)
8.25cm
17.25cm
true
0.5cm
0.63492cm
Inne:
0.25cm
true
18cm
=Fields!CustomerID.Value
10.5cm
11cm
en-US
1cm
29.7cm