58c077ef-da67-445a-8cc2-60008c49a79b
ALLPLAN
11in
String
@405@
String
@20@
String
true
@410@
String
true
@411@
DateTime
true
@401@
String
true
@402@
Integer
1
true
Hier kann die Startseite eingetragen werden
String
true
@70@
String
true
@302@
String
true
@69@
Boolean
True
true
Hier kann das Firmenlogo ausgeblendet werden
Boolean
True
Hier kann die Grafik ausgeblendet werden
String
true
Kommentar
String
true
Distinct(Fields!Name_Object.Value)
true
String
true
Distinct(Fields!Material.Value)
true
Boolean
True
true
Hier kann die Matrix ausgeblendet werden
String
Ausgabe sortiert nach Bauteil oder Material
Bauteile
Material
Boolean
False
true
Zeigt jedes Bauteil einzeln an
Boolean
False
true
Berechnet das eingebaute Volumen der Bauteile statt des Bruttovolumens
true
8.5in
0.25cm
true
0.4cm
2cm
true
14.5cm
11
FitProportional
=Parameters!Display_Logo.Value=false
="file:///" + Parameters!Company_Logo.Value
1.4cm
2.9cm
15.9cm
10
true
2cm
0.4cm
=Parameters!Note.Value
2.5cm
15.9cm
9
true
2cm
0.4cm
=System.String.Format("{0:d} / {1}",Parameters!Date.Value,Parameters!Time.Value)
2.1cm
15.9cm
8
true
2cm
0.4cm
=Parameters!Edited_By.Value
1.7cm
15.9cm
7
true
2cm
0.4cm
=Parameters!Project_Name.Value
2.9cm
2cm
6
true
0.4cm
Hinweis:
2.5cm
2cm
5
true
0.4cm
Datum / Zeit:
2.1cm
2cm
4
true
0.4cm
Ersteller:
1.7cm
2cm
3
true
0.4cm
Projekt:
3.4cm
17.9cm
2
0cm
1.55cm
17.9cm
1
0cm
0.75cm
13.5cm
true
0.71cm
Sparrenkonstruktion
3.7cm
true
0.5cm
2cdc5b66-aa6c-4050-9ab9-72a8741b687e
21cm
Name_Object
System.String
ComponentID
System.String
Material
System.String
Thickness
System.Double
Height
System.Double
Length
System.Double
Piece
System.Int32
TotalLength
System.Double
BruttoVolume
System.Double
Volume
System.Double
Graphics
System.Byte[]
Story
System.String
StoryIndex
System.Int32
DummyDataSource
SELECT
@508@[Name=Material],
@10@[Name=ComponentID],
[Name=Name_Object|f=_IF_(@506@)@506@_ELSE_@498@],
@452@[Name=Story],
@452@[Name=StoryIndex]
FROM [Type=0,Filter=@OBJ@>.eq.901.and.@OBJ@<.eq.930;]
SELECT
@221@[Name=Thickness|Dim=3|Fmt=F8.3],
@222@[Name=Height|Dim=3|Fmt=F8.3],
@220@[Name=Length|Fmt=F8.3],
@215@[Name=Piece],
@223@[Name=Volume|Fmt=F10.4],
[Name=TotalLength|f=@220@*@215@|Dim=3|Fmt=F8.2],
[Name=BruttoVolume|f=(@221@*@222@)*@220@*@215@|Dim=9],
@205@[Name=Graphics|Projection=4|Hidden=1|GText=HD]
FROM [Type=5]
AllplanReport
Room
Allplan GmbH
18cm
1cm
3cm
3cm
1
AllplanReport
2.5cm
= Fields!Thickness.Value*1000 & "/" & Fields!Height.Value*1000
textbox27
true
Gesamt
Material_1
true
= Fields!Thickness.Value*1000 & "/" & Fields!Height.Value*1000
3.5cm
=IIF(Parameters!Sorting.Value = "Bauteile",Fields!Name_Object.Value,Fields!Material.Value)
=IIF(Parameters!Sorting.Value = "Material",Fields!Name_Object.Value,Fields!Material.Value)
Ascending
textbox26
true
Gesamt
textbox39
true
=IIF(Parameters!Sorting.Value = "Bauteile",Fields!Name_Object.Value,Fields!Material.Value)
=IIF(Parameters!Display_Matrix.Value=True,false,true)
=Fields!Name_Object.Value
In
=Parameters!Bauteile.Value
=Fields!Material.Value
In
=Parameters!Material.Value
7cm
0.5cm
textbox31
true
Länge [m]
textbox25
true
=IIF(Parameters!Volumen.Value=False,"Bruttovolumen ","Gesamtvolumen ")& "[m³]"
12cm
true
Querschnitte
0.5cm
Length
true
=Sum(Fields!Length.Value)
Volume
true
=FormatNumber(IIF(Parameters!Volumen.Value=false, Sum(Fields!Thickness.Value*Fields!Height.Value*Fields!TotalLength.Value*Fields!Piece.Value),Sum(Fields!Volume.Value)),4)
AllplanReport
=Fields!Name_Object.Value
In
=Parameters!Bauteile.Value
=Fields!Material.Value
In
=Parameters!Material.Value
=Fields!StoryIndex.Value
4
textbox24
true
=Fields!Story.Value
textbox28
true
textbox29
true
textbox30
true
textbox33
true
textbox35
true
textbox36
true
true
0.8cm
=IIF(Parameters!Sorting.Value = "Bauteile",Fields!Name_Object.Value,Fields!Material.Value)
=IIF(Parameters!Sorting.Value = "Material",Fields!Material.Value,Fields!Name_Object.Value)
Ascending
=Fields!Length.Value
Ascending
4
textbox3
true
=IIF(Parameters!Sorting.Value = "Bauteile",Fields!Name_Object.Value,Fields!Material.Value)
textbox6
true
textbox7
true
textbox8
true
textbox22
true
textbox9
true
textbox10
true
true
0.5cm
=Fields!Thickness.Value
=Fields!Height.Value
=Fields!Material.Value
=Fields!Material.Value
Ascending
=Fields!Thickness.Value
Ascending
=Fields!Height.Value
Ascending
17.9cm
=IIF(Parameters!Display_Graphics.Value=True,false,true)
2
FitProportional
=IIF(Parameters!Bauteile_einzeln.Value=True,"Zoom:"+Fields!ComponentID.Value+",Mark:"+Fields!ComponentID.Value,0)
image/jpeg
=Fields!Graphics.Value
true
=IIF(Parameters!Sorting.Value = "Bauteile",Fields!Material.Value,Fields!Name_Object.Value)
true
=Fields!Thickness.Value*1000
true
/
true
=Fields!Height.Value*1000
true
=Fields!Length.Value
true
true
=IIF(Parameters!Bauteile_einzeln.Value=True,"",Sum(Fields!Piece.Value))
true
=Sum(Fields!Length.Value)
true
=IIF(Parameters!Volumen.Value=false, FormatNumber(Sum(Fields!Thickness.Value*Fields!Height.Value*Fields!TotalLength.Value*Fields!Piece.Value),4),FormatNumber(Sum(Fields!Volume.Value),4))
1cm
=IIF(Parameters!Display_Graphics.Value=False,False,True)
2
textbox67
true
true
=IIF(Parameters!Sorting.Value = "Bauteile",Fields!Material.Value,Fields!Name_Object.Value)
true
=Fields!Thickness.Value*1000
textbox2
true
/
true
=Fields!Height.Value*1000
true
=Fields!Length.Value
textbox23
true
true
=IIF(Parameters!Bauteile_einzeln.Value=True,"",Sum(Fields!Piece.Value))
true
=Sum(Fields!Length.Value)
true
=IIF(Parameters!Volumen.Value=false, FormatNumber(Sum(Fields!Thickness.Value*Fields!Height.Value*Fields!TotalLength.Value*Fields!Piece.Value),4),FormatNumber(Sum(Fields!Volume.Value),4))
0.5cm
=Fields!Thickness.Value
=Fields!Height.Value
=Fields!Length.Value
=Fields!Material.Value
=IIF(Parameters!Bauteile_einzeln.Value=True,Fields!ComponentID.Value,"")
=Fields!Length.Value
Ascending
2
textbox1
true
=IIF(Parameters!Sorting.Value = "Material","Material","Bauteil")
true
=IIF(Parameters!Sorting.Value = "Bauteile","Material","Bauteil")
3
true
Querschnitt
true
Länge
textbox20
true
true
=IIF(Parameters!Bauteile_einzeln.Value=true, "","Stück")
true
Gesamtlänge
true
=IIF(Parameters!Volumen.Value=False,"Bruttovolumen","Gesamtvolumen")
0.4cm
textbox5
true
textbox34
true
textbox12
true
textbox13
true
[mm]
textbox14
true
/
textbox15
true
[mm]
textbox16
true
[m]
textbox21
true
textbox17
true
textbox18
true
[m]
true
[m³]
0.4cm
true
2.75cm
2.75cm
2.5cm
1cm
0.25cm
1cm
1.25cm
0.4cm
1.1cm
2.2cm
2.7cm
6.8cm
8.5cm
true
0.9cm
15cm
4
true
=Parameters!Telephone_Number.Value + " " + Parameters!E_Mail.Value
0.5cm
15cm
3
true
0.5cm
=Parameters!Company_Address.Value
0.1cm
15cm
2
true
0.45cm
=Parameters!Company_Name.Value
0.08cm
17.9cm
1
0cm
0.1cm
2.7cm
true
15.2cm
0.5cm
=Globals!PageNumber+Parameters!PageNo_1.Value-1 & "/" &Globals!TotalPages+Parameters!PageNo_1.Value-1
1.35cm
true
0.4cm
29.7cm