Connection1 Connection1 http://www.bplogix.com/support/reports/SampleData/Demo.xml http://www.bplogix.com/support/reports/SampleData/Demo.xsd 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 Connection1.Suppliers ByCountry Country,System.String Country.Count1,System.Int64 Country_Count2,System.Int64 Country ByCountry Suppliers Country Count Country.Count1 Country Count Country_Count2 Categories CategoryID,System.Int32 CategoryName,System.String Description,System.String Picture,System.Byte[] Categories Connection1.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 Connection1.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 Connection1.Employees Order Details OrderID,System.Int32 ProductID,System.Int32 UnitPrice,System.Decimal Quantity,System.Int16 Discount,System.Single Order Details Connection1.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 Orders Connection1.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 Connection1.Products Shippers ShipperID,System.Int32 CompanyName,System.String Phone,System.String Shippers Connection1.Shippers Countries CountriesID,System.Int32 Flag,System.Byte[] CountryName,System.String Countries Connection1.Countries States Name,System.String USPS,System.String Population,System.Int32 Capital,System.String States Connection1.States Auto Rank,System.Double Country,System.String Year2009,System.Double Year2005,System.Double Year2000,System.Double Auto Connection1.Auto GlobalGrowth Region,System.String Year2006,System.Double Year2007,System.Double Year2008,System.Double Year2009,System.Double GlobalGrowth Connection1.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 Connection1.Opec 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 EngineV2 None;Black;2;Solid;False;4;Black Transparent Transparent 0,0.2,8.3,1.5 Transparent 0,0.1,7.5,1.2 bpReportDescription Arial,8 0,0,0,0 Text15 This sample shows the bug in sort columns. Notice you cannot click Country.Count1 header to sort. But Country_Count2 you can sort on. This is important because when you create a Datasource from Other Datasource, the Results tab by default creates variables WITH a period ... the very character that prevents the sorting from working. Black HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, ReportTitleBand1 Transparent 0,2.1,8.3,0.3 Transparent 0,0,1.6,0.2 Arial,10 DataBand2.Country 0,0,0,0 Text12 Country Black Transparent 1.8,0,1.8,0.2 Arial,10 DataBand2.Country_Count1 0,0,0,0 Text14 Country.Count1 Black Transparent 3.8,0,1.8,0.2 Arial,10 DataBand2.Country_Count2 0,0,0,0 Text17 Country_Count2 Black HeaderBand2 Transparent 0,2.8,8.3,0.2 Transparent 0,0,1.6,0.2 Arial,10 0,0,0,0 Text11 {ByCountry.Country} Black Transparent 1.8,0,1.8,0.2 Arial,10 0,0,0,0 Text13 {ByCountry.Country_Count1} Black Transparent 3.8,0,1.8,0.2 Arial,10 0,0,0,0 Text16 {ByCountry.Country_Count2} Black ByCountry DataBand2 3670432d18b14cc2b89a57c419a86a1a 0.1,0.1,0.1,0.1 Page1 11 8.5 Letter 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 5/3/2012 9:55:12 AM 2/3/2011 3:10:07 PM E:\Report.mrt 6b31d56033b241749bcd223d3bb7288a Report Inches 2012.2.1303 CSharp 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,9,Bold Center bpColumnHeader [74:75:76] Center True Transparent Style should be set on Column Data Arial,8 bpColumnData [74:75:76] Center True True Transparent Style should be set for the Report Title Arial,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,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,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,8 bpColumnDataBorder [74:75:76] Center True True Top;[138:138:138];1;Solid;False;4;Black Transparent Arial,8 bpFooterData Black LightCoral Arial,8 Style1 EmptyBrush Pink Arial,18 Style2 Black All;[74:75:76];1;Solid;False;4;Black GradientBrush,[249:249:249],[227:227:227],90 Style based on formating of 'Text2' component Arial,9,Bold Center ColumnHeader [74:75:76] Center Left, Right;[138:138:138];1;Solid;False;4;[138:138:138] Transparent Style based on formating of 'Text1' component Arial,9 ColumnData [74:75:76] Center Transparent Style based on formating of 'Text12' component Arial,20,Bold ReportTitle [104:146:191] Left, Right;[138:138:138];1;Solid;False;4;Black [236:244:255] Arial,8 OddRow Black Left, Right;[138:138:138];1;Solid;False;4;Black Transparent Arial,8 EvenRow Black All;[138:138:138];1;Solid;False;4;Black Transparent Arial,8 Border Black False False True True Transparent Arial,8 bpReportDescription Black