True
Connection
Connection
C:\Program Files (x86)\Stimulsoft Reports.Web 2012.3\Bin\Data\Demo.xml
C:\Program Files (x86)\Stimulsoft Reports.Web 2012.3\Bin\Data\Demo.xsd
Categories
CategoryID,System.Int32
CategoryName,System.String
Description,System.String
Picture,System.Byte[]
Categories
Connection.Categories
Customers
CustomerID,System.String
CompanyName,System.String
ContactName,System.String
ContactTitle,System.String
Address,System.String
City,System.String
Region,System.String
PostalCode,System.String
Country,System.String
Phone,System.String
Fax,System.String
Customers
Connection.Customers
Employees
EmployeeID,System.Int32
LastName,System.String
FirstName,System.String
Title,System.String
TitleOfCourtesy,System.String
BirthDate,System.DateTime
HireDate,System.DateTime
Address,System.String
City,System.String
Region,System.String
PostalCode,System.String
Country,System.String
HomePhone,System.String
Extension,System.String
Photo,System.Byte[]
Notes,System.String
ReportsTo,System.Int32
Employees
Connection.Employees
Order Details
OrderID,System.Int32
ProductID,System.Int32
UnitPrice,System.Decimal
Quantity,System.Int16
Discount,System.Single
Order Details
Connection.Order Details
Orders
OrderID,System.Int32
CustomerID,System.String
EmployeeID,System.Int32
OrderDate,System.DateTime
RequiredDate,System.DateTime
ShippedDate,System.DateTime
ShipVia,System.Int32
Freight,System.Decimal
ShipName,System.String
ShipAddress,System.String
ShipCity,System.String
ShipRegion,System.String
ShipPostalCode,System.String
ShipCountry,System.String
OrderMonth,OrderMonth,System.DateTime,DateSerial_x0028_Orders.OrderDate.Year_x002C_Orders.OrderDate.Month_x002C_15_x0029_
Orders
Connection.Orders
Products
ProductID,System.Int32
ProductName,System.String
SupplierID,System.Int32
CategoryID,System.Int32
QuantityPerUnit,System.String
UnitPrice,System.Decimal
UnitsInStock,System.Int16
UnitsOnOrder,System.Int16
ReorderLevel,System.Int16
Discontinued,System.Boolean
Products
Connection.Products
Shippers
ShipperID,System.Int32
CompanyName,System.String
Phone,System.String
Shippers
Connection.Shippers
Suppliers
SupplierID,System.Int32
CompanyName,System.String
ContactName,System.String
ContactTitle,System.String
Address,System.String
City,System.String
Region,System.String
PostalCode,System.String
Country,System.String
Phone,System.String
Fax,System.String
HomePage,System.String
Suppliers
Connection.Suppliers
Countries
CountriesID,System.Int32
Flag,System.Byte[]
CountryName,System.String
Countries
Connection.Countries
States
Name,System.String
USPS,System.String
Population,System.Int32
Capital,System.String
States
Connection.States
Auto
Rank,System.Double
Country,System.String
Year2009,System.Double
Year2005,System.Double
Year2000,System.Double
Auto
Connection.Auto
GlobalGrowth
Region,System.String
Year2006,System.Double
Year2007,System.Double
Year2008,System.Double
Year2009,System.Double
GlobalGrowth
Connection.GlobalGrowth
Opec
Year,System.Double
Iran,System.Double
Iraq,System.Double
Kuwait,System.Double
Saudi_x0020_Arabia,System.Double
UAE,System.Double
Venezuela,System.Double
Libya,System.Double
Nigeria,System.Double
Opec
Connection.Opec
DataSource
OrderMonth,System.DateTime
Freight.Avg,System.Decimal
Freight.Count,System.Int64
OrderID,LessThan,_x0031_0351,,Numeric
OrderMonth
DataSource
Orders
Freight
Avg
Freight.Avg
Freight
Count
Freight.Count
ASC
OrderMonth
Orders
OrderID
Orders
OrdersOrderDetails
OrderID
Products
ProductID
Products
ProductsOrderDetails
ProductID
Customers
CustomerID
Customers
CustomersOrders
CustomerID
Employees
EmployeeID
Employees
EmployeesOrders
EmployeeID
Shippers
ShipVia
Shippers
ShippersOrders
ShipperID
Categories
CategoryID
Categories
CategoriesProducts
CategoryID
Suppliers
SupplierID
Suppliers
SuppliersProducts
SupplierID
bp_INTERNAL_VARS,bp_ReportName,bp_ReportName,System.String,test_x0020_date,True,False
bp_INTERNAL_VARS,bp_ReportDescription,bp_ReportDescription,System.String,,True,False
bp_INTERNAL_VARS,bp_ReportID,bp_ReportID,System.String,d1173faf-21a9-4241-bdc5-44f3c34488b6,True,False
bp_INTERNAL_VARS,bp_ViewURL,bp_ViewURL,System.String,http:_x002F__x002F_localhost:8080_x002F_wd_x002F_report_obj_view.aspx_x003F_ID_x003D_,True,False
bp_INTERNAL_VARS,bp_PropURL,bp_PropURL,System.String,http:_x002F__x002F_localhost:8080_x002F_wd_x002F_report_obj_prop.aspx_x003F_ID_x003D_,True,False
bp_INTERNAL_VARS,bp_TaskURL,bp_TaskURL,System.String,http:_x002F__x002F_localhost:8080_x002F_wd_x002F_report_obj_prop.aspx_x003F_TLID_x003D_,True,False
bp_INTERNAL_VARS,bp_PictureURL,bp_PictureURL,System.String,http:_x002F__x002F_localhost:8080_x002F_wd_x002F_image.aspx_x003F_type_x003D_P_x0026_UID_x003D_,True,False
bp_INTERNAL_VARS,bp_SignatureURL,bp_SignatureURL,System.String,http:_x002F__x002F_localhost:8080_x002F_wd_x002F_image.aspx_x003F_type_x003D_S_x0026_UID_x003D_,True,False
bp_INTERNAL_VARS,bp_ReportURL,bp_ReportURL,System.String,http:_x002F__x002F_localhost:8080_x002F_wd_x002F_report.aspx_x003F_ID_x003D_,True,False
bp_INTERNAL_VARS,bp_InterfaceURL,bp_InterfaceURL,System.String,http:_x002F__x002F_localhost:8080_x002F_wd_x002F_,True,False
bp_INTERNAL_VARS,bp_LogoURL,bp_LogoURL,System.String,http:_x002F__x002F_www.bplogix.com_x002F_images_x002F_bplogo.gif,True,False
bp_INTERNAL_VARS,bp_ServerName,bp_ServerName,System.String,BP_x0020_Logix_x0020_Server_x0020_Name_x0020_Approve,True,False
bp_INTERNAL_VARS,bp_ServerVersion,bp_ServerVersion,System.String,_x0032_.51,True,False
bp_INTERNAL_VARS,bp_PartitionID,bp_PartitionID,System.String,_x0033_6,True,False
bp_INTERNAL_VARS,bp_PartitionName,bp_PartitionName,System.String,p1e,True,False
bp_INTERNAL_VARS,bp_UserID,bp_UserID,System.String,user1,True,False
bp_INTERNAL_VARS,bp_UserEmail,bp_UserEmail,System.String,jay_x0040_bplogix.com,True,False
bp_INTERNAL_VARS,bp_UserUID,bp_UserUID,System.String,_x0038_75d561b-4f90-4b93-9dca-15cbfc843131,True,False
bp_INTERNAL_VARS,bp_UserName,bp_UserName,System.String,test,True,False
EngineV2
None;Black;2;Solid;False;4;Black
Transparent
Transparent
0,0.4,19,9.8
95, 72, 29
GradientBrush,[255:255:255],[255:255:219],90
100, 95, 72, 29
100, 95, 72, 29
Silver
Gainsboro
False
100, 95, 72, 29
100, 95, 72, 29
[10:145:122:79]
[10:145:122:79]
1
95, 72, 29
Tahoma,8
95, 72, 29
<Color>95, 72, 29</Color>
<Direction>LeftToRight</Direction>
<Font>Tahoma,12,Bold</Font>
95, 72, 29
Tahoma,8
95, 72, 29
<Color>95, 72, 29</Color>
<Direction>LeftToRight</Direction>
<Font>Tahoma,12,Bold</Font>
95, 72, 29
Tahoma,8
95, 72, 29
<Color>95, 72, 29</Color>
<Direction>BottomToTop</Direction>
<Font>Tahoma,12,Bold</Font>
95, 72, 29
Tahoma,8
Left
95, 72, 29
<Color>95, 72, 29</Color>
<Direction>TopToBottom</Direction>
<Font>Tahoma,12,Bold</Font>
[255:255:255]
0.2,0.2,18.4,3.8
Orders
OrderID,LessThan,_x0031_0351,,Numeric
Chart1
Orders.OrderDate
194, 117, 53
Firebrick
44, 0, 0
[244:167:103]
94, 17, 0
[255:217:153]
95, 72, 29
Wheat
Arial,7
95, 72, 29
8, 6
-
Series 1
Black
True
Orders.Freight
8, 6
-
Tahoma,8
95, 72, 29
95, 72, 29
<Brush>[95:72:29]</Brush>
<Font>Tahoma,12,Bold</Font>
95, 72, 29
GradientBrush,[255:255:255],[255:255:219],90
100, 95, 72, 29
100, 95, 72, 29
Silver
Gainsboro
False
100, 95, 72, 29
100, 95, 72, 29
[10:145:122:79]
[10:145:122:79]
1
25
95, 72, 29
Tahoma,8
MMM yy
95, 72, 29
<Color>95, 72, 29</Color>
<Direction>LeftToRight</Direction>
<Font>Tahoma,12,Bold</Font>
95, 72, 29
Tahoma,8
95, 72, 29
<Color>95, 72, 29</Color>
<Direction>LeftToRight</Direction>
<Font>Tahoma,12,Bold</Font>
95, 72, 29
Tahoma,8
95, 72, 29
<Color>95, 72, 29</Color>
<Direction>BottomToTop</Direction>
<Font>Tahoma,12,Bold</Font>
95, 72, 29
Tahoma,8
Left
95, 72, 29
<Color>95, 72, 29</Color>
<Direction>TopToBottom</Direction>
<Font>Tahoma,12,Bold</Font>
[255:255:255]
0.4,4.2,18.4,4
DataSource
Chart2
DataSource.OrderMonth
194, 117, 53
Firebrick
44, 0, 0
[244:167:103]
94, 17, 0
[255:217:153]
95, 72, 29
Wheat
Arial,7
95, 72, 29
8, 6
-
Series 1
Black
True
DataSource.Freight_Avg
95, 72, 29
Wheat
Arial,7
95, 72, 29
8, 6
-
ASC
OrderMonth
Tahoma,8
95, 72, 29
95, 72, 29
<Brush>[95:72:29]</Brush>
<Font>Tahoma,12,Bold</Font>
ReportTitleBand1
Transparent
0,11,19,0.6
Transparent
0.2,0,4.2,0.6
Arial,10
0,0,0,0
Text1
{Orders.OrderID}
Black
DataColumn
Transparent
4.6,0,4.2,0.6
Arial,10
cf52764761bd480b98eaf7393c0b39b2
0,0,0,0
Text2
{Orders.OrderDate}
Black
DataColumn
Transparent
9,0,4.2,0.6
Arial,10
ab39c167c78b4abb9b0b09184a9c127e
0,0,0,0
Text3
{Orders.Freight}
Black
DataColumn
Transparent
13.4,0,5.4,0.6
Arial,10
0,0,0,0
Text4
{Order_Details.Orders.OrderMonth}
Black
Orders
OrderID,LessThan,_x0031_0351,,Numeric
DataBand1
Tan
0,12.4,19,1.8
Transparent
0.8,0,16.4,0.8
Arial,10
0,0,0,0
Text11
Notice that their are duplicate OrderMonths in this DataBand. There should not be ... the items are grouped by OrderMonth.
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Expression
Transparent
0,1.2,2.8,0.6
Arial,10
0,0,0,0
Text6
OrderMonth
Black
Transparent
5,1.2,2.8,0.6
Arial,10
0,0,0,0
Text8
Freight.Avg
Black
Transparent
9.8,1.2,2.8,0.6
Arial,10
0,0,0,0
Text10
Freight.Count
Black
ColumnHeaderBand1
Transparent
0,15,19,0.6
Transparent
0,0,4.4,0.6
Arial,10
0,0,0,0
Text5
{DataSource.OrderMonth}
Black
Transparent
5,0,1.6,0.6
Arial,10
0,0,0,0
Text7
{DataSource.Freight_Avg}
Black
Transparent
9.8,0,1.6,0.6
Arial,10
0,0,0,0
Text9
{DataSource.Freight_Count}
Black
DataSource
DataBand2
ASC
OrderMonth
933baed0334149178c1ac82be3ab90fc
1,1,1,1
Page1
29.7
21
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
Report
2/11/2013 12:30:23 PM
2/6/2013 8:45:41 AM
a9b9a319d6676b03feeecaf388b0d8d4
Report
Centimeters
2012.3.1500
CSharp
LightCoral
Arial Unicode MS,8
Style1
EmptyBrush
True
All;[74:75:76];1;Solid;False;4;Black
GradientBrush,[249:249:249],[227:227:227],90
Style should be set on Column Header Text Box
Arial Unicode MS,9,Bold
Center
bpColumnHeader
[74:75:76]
Center
True
Transparent
Style should be set on Column Data
Arial Unicode MS,8
bpColumnData
[74:75:76]
Center
True
True
Transparent
Style should be set for the Report Title
Arial Unicode MS,20,Bold
bpReportTitle
[104:146:191]
True
True
Left, Right;[138:138:138];1;Solid;False;4;Black
[236:244:255]
Style should be set for Odd Rows on the DataBand
Arial Unicode MS,8
bpOddRow
Black
Center
True
True
Left, Right;[138:138:138];1;Solid;False;4;Black
White
Style should be set for Even Rows on the DataBand
Arial Unicode MS,8
bpEvenRow
Black
Center
True
Left, Right;[138:138:138];1;Solid;False;4;Black
Transparent
Style should be set Column Data that require borders on left and right
Arial Unicode MS,8
bpColumnDataBorder
[74:75:76]
Center
True
True
Top;[138:138:138];1;Solid;False;4;Black
Transparent
Arial Unicode MS,8
bpFooterData
Black
False
False
True
True
Transparent
Arial Unicode MS,8
bpReportDescription
Black