KomtekConnection
+X7RCUZKk4XiS01sY4ikJ95azQDNbPL9aQihyWRc4xuNyNEJxmx7ZXJ43TTDmHd723jZCcZx+sVhXM309Rz2D8Nw94lKQfPlYhXo+G/QaT/6bGUJYQN7mWkThPDlPSF/2xTbK0tWQ91hSdWAYNhiKsPy0StGXeqBfl/RZHVMpJfRGPvLTG5C
KomtekConnection
Kontroll
AvtLnr,System.Int32
Eiendom,System.String
Varenr,System.Int32
Varenavn,System.String
Grunnlag,System.Double
Enhet,System.String
Enhetspris,System.Double
Andel,System.String
Korr,System.Double
Fra,System.DateTime
Til,System.DateTime
Beløp,System.Decimal
Aar,System.Int32
30
Kontroll
KomtekConnection
SELECT FL_Fakturert.AvtLnr, CONVERT(varchar, FL_Avt.Gnr) + '/' + CONVERT(varchar, FL_Avt.Bnr) + '/' + CONVERT(varchar, FL_Avt.Fnr)
+ '/' + CONVERT(varchar, FL_Avt.Snr) AS Eiendom, FL_Fakturert.Vare AS Varenr, FL_Fakturert.Varenavn, FL_Fakturert.Antall AS Grunnlag,
UPPER(FL_Fakturert.Enhet) AS Enhet, FL_Fakturert.Enhetspris, CONVERT(varchar, FL_Fakturert.SamTeller) + '/' + CONVERT(varchar,
FL_Fakturert.SamNevner) AS Andel, FL_Fakturert.Rabatt AS Korr, FL_Fakturert.AvgFra AS Fra, FL_Fakturert.Avgtil AS Til,
CAST(FL_Fakturert.Belop AS decimal(11, 2)) AS Beløp, FL_Fakturert.Aar
FROM FL_Fakturert LEFT OUTER JOIN
FL_Avt ON FL_Fakturert.AvtLnr = FL_Avt.AvtLnr LEFT OUTER JOIN
FL_AvgiftsType ON FL_Fakturert.Avgiftstype = FL_AvgiftsType.ATNr
WHERE (FL_Fakturert.Aar > DATEPART(YEAR, GETDATE()) - 4)
ORDER BY FL_Fakturert.AvtLnr
FaktAar
Aar,System.Int32
30
FaktAar
KomtekConnection
SELECT DISTINCT Aar
FROM FL_Fakturert
WHERE (Aar > DATEPART(YEAR, GETDATE()) - 4)
ORDER BY Aar DESC
,Aar,Fra_x0020_år,Velg_x0020__x0028_fra_x0029__x0020_år._x0020_Nullstill_x003F__x0020_Fjerntallet.,System.Int32,_x0032_014,False,False,True,False,_x003C__x003F_xml_x0020_version_x003D__x0022_1.0_x0022__x0020_encoding_x003D__x0022_utf-16_x0022__x0020_standalone_x003D__x0022_yes_x0022__x003F__x003E__x003C_StiSerializer_x0020_version_x003D__x0022_1.02_x0022__x0020_type_x003D__x0022_Net_x0022__x0020_application_x003D__x0022_State_x0022__x003E__x003C_ItemsInitializationType_x003E_Columns_x003C__x002F_ItemsInitializationType_x003E__x003C_KeysColumn_x003E_FaktAar.Aar_x003C__x002F_KeysColumn_x003E__x003C_ValuesColumn_x003E_FaktAar.Aar_x003C__x002F_ValuesColumn_x003E__x003C_Keys_x0020_isList_x003D__x0022_true_x0022__x0020_count_x003D__x0022_0_x0022__x0020__x002F__x003E__x003C_Values_x0020_isList_x003D__x0022_true_x0022__x0020_count_x003D__x0022_0_x0022__x0020__x002F__x003E__x003C__x002F_StiSerializer_x003E_
,Avtale,Avtale,Angi_x0020_avtalenummer._x0020_Nullstill_x003F__x0020_Fjern_x0020_tallet.,System.Int32,,False,False,True
,IsVare,Vare,Velg_x0020_en_x0020_vare_x0020_fra_x0020_en_x0020_liste._x0020_Nullstill_x003F__x0020_Fjern_x0020_teksten.,System.String,,False,False,True,False,_x003C__x003F_xml_x0020_version_x003D__x0022_1.0_x0022__x0020_encoding_x003D__x0022_utf-16_x0022__x0020_standalone_x003D__x0022_yes_x0022__x003F__x003E__x003C_StiSerializer_x0020_version_x003D__x0022_1.02_x0022__x0020_type_x003D__x0022_Net_x0022__x0020_application_x003D__x0022_State_x0022__x003E__x003C_ItemsInitializationType_x003E_Columns_x003C__x002F_ItemsInitializationType_x003E__x003C_KeysColumn_x003E_Kontroll.Varenavn_x003C__x002F_KeysColumn_x003E__x003C_ValuesColumn_x003E_Kontroll.Varenavn_x003C__x002F_ValuesColumn_x003E__x003C_Keys_x0020_isList_x003D__x0022_true_x0022__x0020_count_x003D__x0022_0_x0022__x0020__x002F__x003E__x003C_Values_x0020_isList_x003D__x0022_true_x0022__x0020_count_x003D__x0022_0_x0022__x0020__x002F__x003E__x003C__x002F_StiSerializer_x003E_
,IsAndel,Andel,Eksempel._x0020_Skriv_x0020_antall_x0020_slik:_x0020_1_x002F_2_x0020_._x0020_Nullstill_x003F__x0020_Fjern_x0020_teksten.,System.String,,False,False,True
,Grunnlag,Grunnlag,Skriv_x0020_både_x0020_Fra_x0020_og_x0020_Til._x0020_Nullstill_x003F__x0020_Sett_x0020__x0027_til_x0027__x0020_som_x0020_0.,Stimulsoft.Report.DoubleRange,Double_x002C__x005F_x0030__x002C__x005F_x0030_,False,False,True
,Belop,Beløp,Skriv_x0020_både_x0020_Fra_x0020_og_x0020_Til._x0020_Nullstill_x003F__x0020_Sett_x0020__x0027_til_x0027__x0020_som_x0020_0.,Stimulsoft.Report.DecimalRange,Decimal_x002C__x005F_x0030__x002C__x005F_x0030_,False,False,True
,FraDato,Fra_x0020_dato,Velg_x0020_både_x0020_Fra_x0020_og_x0020_Til.,Stimulsoft.Report.DateTimeRange,DateTime_x002C__x005F_x0031__x005F_x002F_1_x005F_x002F_1990_x005F_x0020_12:00:00_x005F_x0020_AM_x002C__x005F_x0031__x005F_x002F_1_x005F_x002F_2015_x005F_x0020_12:00:00_x005F_x0020_AM,False,False,True
,TilDato,Til_x0020_dato,Skriv_x0020_både_x0020_Fra_x0020_og_x0020_Til.,Stimulsoft.Report.DateTimeRange,DateTime_x002C__x005F_x0031__x005F_x002F_1_x005F_x002F_1990_x005F_x0020_12:00:00_x005F_x0020_AM_x002C__x005F_x0031__x005F_x002F_1_x005F_x002F_2015_x005F_x0020_12:00:00_x005F_x0020_AM,False,False,True
EngineV2
None;Black;2;Solid;False;4;Black
Transparent
Top;Black;1;Solid;False;4;Black
Transparent
0,18,27.7,1
None;[152:155:107];1;Solid;False;4;Black;True
[255:255:255]
26,0.2,1.6,0.6
Arial,10
27fa25a8fc8b410db308e1310dfd1674
Right
0,0,0,0
Text13
{PageNumber}
[0:0:0]
Center
None;[152:155:107];1;Solid;False;4;Black;True
[255:255:255]
4,0.2,2.2,0.6
Arial,10
e316006c4d474b5c8618c408618b61eb
0,0,0,0
Text12
{Today}
[0:0:0]
dd/MM/yyyy
Center
None;[152:155:107];1;Solid;False;4;Black;True
[255:255:255]
1,0.2,3,0.6
Arial,10
c61499ece45c43faa54bc8ff8e924f71
0,0,0,0
Text10
KOMTEK Rapport
[0:0:0]
Expression
Center
None;[152:155:107];1;Solid;False;4;Black;True
[255:255:255]
0.2,0.2,0.6,0.6
72e2bedc8d7346f19a0546d09d4d266c
iVBORw0KGgoAAAANSUhEUgAAABgAAAAXCAIAAACeQxh6AAAABGdBTUEAALGPC/xhBQAAAAlwSFlzAAAOvAAADrwBlbxySQAAALxJREFUOE+1jzkSgCAQBP3/t3gDDzAiJyADHGALV47iUDuw3IWZag4/4ojQ0GdwAxVnZNjVPTbGFGGMWNJQ0S5CRghBAwPLnlpji6taaxoqcNTsKuWbIjW12j3gQEpJwwS4zLvCn7UWK+dcWs2DCIKI4z+8pZBcBXGlFL6vWhKhBUaAFlukhqDzUirFPy1KbnG5TM6Sy7ZUDn5dlA2X4KlbZEOKR34o4p4zFPcfFktSxeV/iqCK40n4u7z3FzAPybDeFZ6fAAAAAElFTkSuQmCC
Image2
085d7c14817a4a62ae8951699027d6f5
PageFooterBand1
Transparent
0,0.4,27.7,1.4
Bottom;Black;1;Double;False;4;Black
Transparent
0,0,27.6,1.4
True
Arial,20,Bold
Right
0,0,0,0
ReportTitleText
Kontroll - Fakturert
Black
Expression
Center
ReportTitle
Bottom;Black;1;Solid;False;4;Black
Transparent
0,2.6,27.7,0.6
Transparent
True
3.6,0,0.8,0.6
Arial,9,Bold
f34ad7b794364ebcba36c9f2a3aca8c8
DataKontroll.Varenr
0,0,0,0
Text5
År
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Expression
Center
Transparent
True
0,0,1.6,0.6
Arial,9,Bold
DataKontroll.AvtLnr
0,0,0,0
HeaderTextKontroll1
Avtale
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Expression
Center
Transparent
True
4.6,0,1.6,0.6
Arial,9,Bold
DataKontroll.Varenr
0,0,0,0
HeaderTextKontroll3
Vare
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Expression
Center
Transparent
True
11.8,0,2.2,0.6
Arial,9,Bold
Right
DataKontroll.Grunnlag
0,0,0,0
HeaderTextKontroll5
Grunnlag
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Center
Transparent
True
20.8,0,1,0.6
Arial,9,Bold
DataKontroll.Fra
0,0,0,0
HeaderTextKontroll10
Fra
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Expression
Center
Transparent
True
25.6,0,2,0.6
Arial,9,Bold
Right
DataKontroll.Beløp
0,0,0,0
HeaderTextKontroll12
Beløp
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Center
Transparent
True
22.6,0,1,0.6
Arial,9,Bold
7ff2a31e22c742748ef6aedf6336ad89
DataKontroll.Til
0,0,0,0
Text1
Til
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Expression
Center
Transparent
True
18.4,0,1,0.6
Arial,9,Bold
d07d010402164cb1a1462610756f4d8a
Center
DataKontroll.Andel
0,0,0,0
Text2
Andel
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Expression
Center
Transparent
True
19.4,0,1.2,0.6
Arial,9,Bold
b1b71830d3c24aa2b96bfaad96072685
Center
0,0,0,0
Text3
Korr%
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Expression
Center
Transparent
True
16.2,0,1.8,0.6
Arial,9,Bold
d3654a063905449889cd0af719fb04b8
Center
DataKontroll.Enhetspris
0,0,0,0
Text4
Enhetspris
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Expression
Center
HeaderKontroll
Transparent
0,4,27.7,0.6
Transparent
True
0,0,1.8,0.4
Arial,8,Bold
0,0,0,0
DataTextKontroll1
{Kontroll.AvtLnr}
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Wysiwyg
Center
Transparent
True
2,0,1.6,0.4
Arial,8
0,0,0,0
DataTextKontroll2
{Kontroll.Eiendom}
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Wysiwyg
Center
Transparent
True
4.6,0,1.6,0.4
Arial,8
0,0,0,0
DataTextKontroll3
{Kontroll.Varenr}
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Wysiwyg
Center
Transparent
True
6.2,0,5,0.4
Arial,8
0,0,0,0
DataTextKontroll4
{Kontroll.Varenavn}
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Wysiwyg
Center
Transparent
True
11.2,0,2.8,0.4
Arial,8
Right
0,0,0,0
DataTextKontroll5
{Kontroll.Grunnlag}
Black
,
1
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Wysiwyg
Center
Transparent
True
14.2,0,1.4,0.4
Arial,8
0,0,0,0
DataTextKontroll6
{Kontroll.Enhet}
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Wysiwyg
Center
Transparent
True
15.6,0,2.4,0.4
Arial,8
Right
0,0,0,0
DataTextKontroll7
{Kontroll.Enhetspris}
Black
,
12
2
kr
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Wysiwyg
Center
Transparent
True
18.6,0,1,0.4
Arial,8
0,0,0,0
DataTextKontroll8
{Kontroll.Andel}
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Wysiwyg
Center
Transparent
True
19.6,0,1.2,0.4
Arial,8
0,0,0,0
DataTextKontroll9
{Kontroll.Korr}
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Wysiwyg
Center
Transparent
True
20.8,0,2,0.4
Arial,8
0,0,0,0
DataTextKontroll10
{Kontroll.Fra}
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Wysiwyg
Center
Transparent
True
22.6,0,2,0.4
Arial,8
0,0,0,0
DataTextKontroll11
{Kontroll.Til}
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Wysiwyg
Center
Transparent
True
24.6,0,3,0.4
Arial,8,Bold
Right
0,0,0,0
DataTextKontroll12
{Kontroll.Beløp}
Black
,
12
2
kr
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Wysiwyg
Center
Transparent
True
3.6,0,0.8,0.4
Arial,8
e44e5a7c8e724ed6b392481924211c31
0,0,0,0
Text6
{Kontroll.Aar}
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Wysiwyg
DataColumn
Center
Kontroll
_x007B__x0028_Kontroll.AvtLnr_x0020__x003D__x003D__x0020_Avtale_x0020__x007C__x007C__x0020__x0020_Avtale_x0020__x003D__x003D__x0020_0_x0029__x007D_
_x007B__x0028_Kontroll.Varenavn_x0020__x003D__x003D__x0020_IsVare_x0020__x007C__x007C__x0020_IsVare_x0020__x003D__x003D__x0020__x0022__x0022__x0029__x0020__x007D_
_x007B__x0028__x0028_Kontroll.Grunnlag_x0020__x003E__x003D__x0020_Grunnlag.From_x0020__x0026__x0026__x0020_Kontroll.Grunnlag_x0020__x003C__x0020_Grunnlag.To_x0029__x0020__x0020__x007C__x007C__x0020__x0020_Grunnlag.To_x0020__x003D__x003D__x0020_0_x0029__x007D_
_x007B__x0028__x0028_Kontroll.Beløp_x0020__x003E__x003D__x0020_Belop.From_x0020__x0026__x0026__x0020_Kontroll.Beløp_x0020__x003C__x0020_Belop.To_x0029__x0020__x0020__x007C__x007C__x0020__x0020_Belop.To_x0020__x003D__x003D__x0020_0_x0029__x007D_
_x007B__x0028_Kontroll.Andel_x0020__x003D__x003D__x0020_IsAndel_x0020__x007C__x007C__x0020_IsAndel_x0020__x003D__x003D__x0020__x0022__x0022__x0029__x007D_
_x007B__x0028_Kontroll.Fra_x0020__x003E__x003D__x0020_FraDato.From_x0020__x0026__x0026__x0020_Kontroll.Fra_x0020__x003C__x0020_FraDato.To_x0029__x007D_
_x007B__x0028_Kontroll.Til_x0020__x003E__x003D__x0020_TilDato.From_x0020__x0026__x0026__x0020_Kontroll.Til_x0020__x003C__x0020_TilDato.To_x0029__x007D_
_x007B__x0028_Kontroll.Aar_x0020__x003E__x003D__x0020_Aar_x0020__x007C__x007C__x0020_Aar_x0020__x003D__x003D__x0020_0_x0029__x007D_
DataKontroll
ASC
AvtLnr
ASC
Aar
ASC
Fra
Top;Black;1;Double;False;4;Black
Transparent
0,5.4,27.7,0.6
Transparent
True
0,0,1.6,0.6
Arial,10,Bold
0,0,0,0
FooterTextKontroll1
Antall {Count()}
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Expression
Center
Transparent
True
7.8,0.2,6.2,0.4
Arial,10,Bold
Right
0,0,0,0
FooterTextKontroll5
Grunnlag: {Sum(Kontroll.Grunnlag)}
Black
,
1
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Expression
Center
Transparent
True
21.6,0,6,0.6
Arial,10,Bold
Right
0,0,0,0
FooterTextKontroll12
{Sum(Kontroll.Beløp)}
Black
,
12
2
kr
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Expression
Center
FooterKontroll
18577abf39b44854908c6cc2c6453335
1,1,1,1
Page1
Landscape
21
29.7
Arial,100
[50:0:0:0]
System.Dll
System.Drawing.Dll
System.Windows.Forms.Dll
System.Data.Dll
System.Xml.Dll
Stimulsoft.Controls.Dll
Stimulsoft.Base.Dll
Stimulsoft.Report.Dll
Fakturert - Kontroll
5/16/2013 11:25:30 AM
3/26/2013 3:41:45 PM
C:\Rapporter\TimeOutFeil\KontrollFakturert.xml
340b194be84c4bfc8e978b94afc53386
Fakturert - Kontroll
Centimeters
2013.2.1604
True
CSharp