True Interpretation Demo Demo http://www.bplogix.com/support/reports/SampleData/Demo.xml http://www.bplogix.com/support/reports/SampleData/Demo.xsd Categories CategoryID,System.Int32 CategoryName,System.String Description,System.String Picture,System.Byte[] Categories Demo.Categories Countries CountriesID,System.Int32 Flag,System.Byte[] CountryName,System.String Countries Demo.Countries 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 Demo.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 Demo.Employees Order Details OrderID,System.Int32 ProductID,System.Int32 UnitPrice,System.Decimal Quantity,System.Int16 Discount,System.Single Order Details Demo.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 Demo.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 Demo.Products Shippers ShipperID,System.Int32 CompanyName,System.String Phone,System.String Shippers Demo.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 Demo.Suppliers States Name,System.String USPS,System.String Population,System.Int32 Capital,System.String States Demo.States Auto Rank,System.Double Country,System.String Year2009,System.Double Year2005,System.Double Year2000,System.Double Auto Demo.Auto GlobalGrowth Region,System.String Year2006,System.Double Year2007,System.Double Year2008,System.Double Year2009,System.Double GlobalGrowth Demo.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 Demo.Opec proave CategoryID,System.Int32 CategoryName,System.String Description,System.String Description,EqualTo,Cheeses,,String CategoryID proave Categories CategoryName CategoryName Description Description Employees ReportsTo Employees EmployeesEmployees EmployeeID Products ProductID Products ProductsOrder_Details ProductID Orders OrderID Orders OrdersOrder_Details OrderID Customers CustomerID Customers CustomersOrders CustomerID Shippers ShipVia Shippers ShippersOrders ShipperID Employees EmployeeID Employees EmployeesOrders EmployeeID Categories CategoryID Categories CategoriesProducts CategoryID Suppliers SupplierID Suppliers SuppliersProducts SupplierID Orders OrderID Orders_2 OrdersOrderDetails OrderID Products ProductID Products_2 ProductsOrderDetails ProductID bp_INTERNAL_VARS,bp_ReportName,bp_ReportName,System.String,list_x0020_of_x0020_products,True,False bp_INTERNAL_VARS,bp_ReportDescription,bp_ReportDescription,System.String,,True,False bp_INTERNAL_VARS,bp_ReportID,bp_ReportID,System.String,_x0035_544b02f_x002D_c7be_x002D_43b3_x002D_a86b_x002D_d1c05404c6da,True,False bp_INTERNAL_VARS,bp_ViewURL,bp_ViewURL,System.String,http_x003A__x002F__x002F_localhost_x003A_8080_x002F_wd_x002F_report_obj_view_x002E_aspx_x003F_ID_x003D_,True,False bp_INTERNAL_VARS,bp_PropURL,bp_PropURL,System.String,http_x003A__x002F__x002F_localhost_x003A_8080_x002F_wd_x002F_report_obj_prop_x002E_aspx_x003F_ID_x003D_,True,False bp_INTERNAL_VARS,bp_TaskURL,bp_TaskURL,System.String,http_x003A__x002F__x002F_localhost_x003A_8080_x002F_wd_x002F_report_obj_prop_x002E_aspx_x003F_TLID_x003D_,True,False bp_INTERNAL_VARS,bp_PictureURL,bp_PictureURL,System.String,http_x003A__x002F__x002F_localhost_x003A_8080_x002F_wd_x002F_image_x002E_aspx_x003F_type_x003D_P_x0026_UID_x003D_,True,False bp_INTERNAL_VARS,bp_SignatureURL,bp_SignatureURL,System.String,http_x003A__x002F__x002F_localhost_x003A_8080_x002F_wd_x002F_image_x002E_aspx_x003F_type_x003D_S_x0026_UID_x003D_,True,False bp_INTERNAL_VARS,bp_ReportURL,bp_ReportURL,System.String,http_x003A__x002F__x002F_localhost_x003A_8080_x002F_wd_x002F_report_x002E_aspx_x003F_ID_x003D_,True,False bp_INTERNAL_VARS,bp_InterfaceURL,bp_InterfaceURL,System.String,http_x003A__x002F__x002F_localhost_x003A_8080_x002F_wd_x002F_,True,False bp_INTERNAL_VARS,bp_LogoURL,bp_LogoURL,System.String,http_x003A__x002F__x002F_www_x002E_bplogix_x002E_com_x002F_images_x002F_bplogo_x002E_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__x002E_54,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_x002E_com,True,False bp_INTERNAL_VARS,bp_UserUID,bp_UserUID,System.String,_x0038_75d561b_x002D_4f90_x002D_4b93_x002D_9dca_x002D_15cbfc843131,True,False bp_INTERNAL_VARS,bp_UserName,bp_UserName,System.String,test,True,False EngineV2 Catalog None;Black;2;Solid;False;4;Black Transparent Transparent 0,27.3,19,0.4 None;[193:152:89];1;Solid;False;4;Black Transparent 6.8,0,12.2,0.4 Footer1 Arial,9 3a2c047ee1c64bb5864ae2a106d43eaf Right 0,0,0,0 Text4 {PageNofM} [102:77:38] Typographic Center 88138f4246fa4d6fa2da67ea7b7a15f7 PageFooterBand1 Transparent 0,0.4,19,2 Bottom;[193:152:89];1;Solid;False;4;Black Transparent 9.4,0,9.6,0.8 Title1 Arial,19 36befd79fef94c3c872b02003d351236 Right 0,0,0,0 Text20 Stimulsoft [193:152:89] Typographic Expression Center Bottom;[193:152:89];1;Solid;False;4;Black Transparent 0,0,9.4,0.8 Title1 Arial,19 e1f3b536661845a1b6956d2b4903e5bd 0,0,0,0 Text23 List of Products [193:152:89] Typographic Expression Center None;[102:77:38];1;Solid;False;4;Black Transparent True 0,1,14.6,0.8 Title2 Arial,9 ac9d76b1fba74f8e9c81b25ba159d7c6 0,0,0,0 Text17 {ReportDescription} [102:77:38] HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Typographic Expression None;[102:77:38];1;Solid;False;4;Black Transparent True 14.6,1,4.4,0.8 Title2 Arial,9 7987407307ac4c209fd103e3469bb7e7 Right 0,0,0,0 Text18 Date: {Today.ToString("Y")} [102:77:38] yyyy, MMMM HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Typographic Expression b51f204089d24f078e5e668cfc9e0daa ReportTitleBand2 Transparent 0,3.2,19,1 All;[193:152:89];1;Solid;False;4;Black [242:234:221] 0,0,19,1 Header3 Arial,9,Bold c8685cdfc3854f72935030271d8504ab Center 0,0,0,0 Text5 Category Name [193:152:89] Typographic Expression Center HeaderBand1 None;[193:152:89];1;Solid;False;4;Black Transparent 0,5,19,1 Left, Right;[193:152:89];1;Solid;False;4;Black Transparent True 0,0,19,1 Data1 Arial,9 True 4b6c7b3c5758414f9695185ef64b99c8 Categories.CategoryName Category Categories.Description ReportAlias Categories.CategoryID CatID 0,0,0,0 DataProducts_ProductName {Line}. {Categories.CategoryName} [102:77:38] HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Typographic Expression Center Categories Data2 DataProducts ASC CategoryName Transparent 0,6.8,19,0.2 Top;[193:152:89];1;Solid;False;4;Black Transparent True 0,0,19,0.2 Footer1 Arial,9 cb569f950a0d41dfbca6a624f0f33acc True 4b6c7b3c5758414f9695185ef64b99c8 Categories.CategoryName Category Categories.CategoryName ReportAlias 0,0,0,0 Text7 [102:77:38] HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Typographic Expression Center FooterBand1 Transparent 0,7.8,19,2.2 Transparent 0.6,0.2,17,2 Arial,10 0,0,0,0 Text28 This databand uses the proave datasource (which is a datasource from datasource on Categories). The proave datasource has a filter which now seems to be ignored. In previous builds, it worked. This databand should ONLY show the category with the description Cheeses ... but the filter seems to be ignored. Black HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Expression HeaderBand2 Transparent 0,10.8,19,0.8 Transparent 3.6,0,2.8,0.6 Arial,10 0,0,0,0 Text15 {proave.CategoryID} Black Transparent 0.8,0,2.8,0.6 Arial,10 0,0,0,0 Text16 CategoryID Black Transparent 9.8,0,1.6,0.6 Arial,10 0,0,0,0 Text1 {proave.CategoryName} Black Transparent 7,0,2.8,0.6 Arial,10 0,0,0,0 Text3 CategoryName Black Transparent 15,0,1.6,0.6 Arial,10 0,0,0,0 Text6 {proave.Description} Black Transparent 12.2,0,2.8,0.6 Arial,10 0,0,0,0 Text8 Description Black proave DataBand3 Transparent 0,12.4,19,1.2 Transparent 0.2,0.2,18.2,0.6 Arial,10 bd5fc44a792aa9e811e25c2488f88ed7 0,0,0,0 Text30 This section goes after the Categories data source directly. There is no filter and it should show all records. Black Expression 2ed665ae534519abcfc65c2488f83e0f HeaderBand4 Transparent 0,14.4,19,1 Transparent 4.8,0,1.6,0.6 Arial,10 0,0,0,0 Text9 {Categories.CategoryID} Black Transparent 2,0,2.8,0.6 Arial,10 0,0,0,0 Text10 CategoryID Black Transparent 9.6,0,3.6,0.6 Arial,10 0,0,0,0 Text11 {Categories.Description} Black Transparent 6.6,0,2.8,0.6 Arial,10 0,0,0,0 Text12 Description Black Transparent 16.8,0,1.6,0.6 Arial,10 0,0,0,0 Text13 {proave.CategoryName} Black Transparent 14,0,2.8,0.6 Arial,10 0,0,0,0 Text14 CategoryName Black Categories DataBand2 468cecb8155a44019d5fe1a8a26a8439 1,1,1,1 CatalogPage 29.7 21 Arial,100 [50:0:0:0] List of Products None;Black;2;Solid;False;4;Black Transparent Transparent 0,27.3,19,0.4 None;[193:152:89];1;Solid;False;4;Black Transparent 6.8,0,12.2,0.4 Footer1 Arial,9 5699926f632d495d857486f90b9a462c Right 0,0,0,0 Text19 {PageNofM} [102:77:38] Typographic Center 0d901c3b669f4e829b60a2b949babec5 PageFooterBand2 Transparent 0,0.4,19,3.8 None;[193:152:89];1;Solid;False;4;Black Transparent 0,0,19,3.4 Title1 Arial,19 55bb9d43b025431cb699f4a4b67620af Center 0,0,0,0 Text2 Category: "{this["Category"]}" ReportAlias: "{this["ReportAlias"]}" CatID: "{this["CatID"]}" [193:152:89] Typographic Expression Center a4fd434c908043b5a8b44af4eb56be53 ReportTitleBand1 Transparent 0,5,19,1.2 Transparent 3.8,0.2,1.6,0.6 Arial,10 0,0,0,0 Text21 {proave.CategoryID} Black Transparent 1,0.2,2.8,0.6 Arial,10 0,0,0,0 Text22 CategoryID Black Transparent 9,0.2,1.6,0.6 Arial,10 0,0,0,0 Text24 {proave.CategoryName} Black Transparent 6.2,0.2,2.8,0.6 Arial,10 0,0,0,0 Text25 CategoryName Black Transparent 14.8,0.2,1.6,0.6 Arial,10 0,0,0,0 Text26 {proave.Description} Black Transparent 12,0.2,2.8,0.6 Arial,10 0,0,0,0 Text27 Description Black proave DataBand1 4b6c7b3c5758414f9695185ef64b99c8 1,1,1,1 DetailPage 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.Base.Dll Stimulsoft.Controls.Dll Stimulsoft.Report.Dll List of Products 03/11/2013 06:08:42 PM 05/29/2004 10:59:00 AM The sample demonstrates how to use drill-down reports. List of Products.mrt 249aa1d6238d5a1e12085c2468be4993 Report Centimeters 2013.1.1512 CSharp False None;[193:152:89];1;Solid;False;4;Black Transparent Arial,19 Right Title1 [193:152:89] Center False None;[102:77:38];1;Solid;False;4;Black Transparent Arial,9 Title2 [102:77:38] Center False None;[193:152:89];1;Solid;False;4;Black Transparent Arial,19 Header1 [193:152:89] Center False None;[193:152:89];1;Solid;False;4;Black Transparent Arial,12,Bold Center Header2 [193:152:89] Center False True True All;[193:152:89];1;Solid;False;4;Black [242:234:221] Arial,9,Bold Center Header3 [193:152:89] Center False All;[193:152:89];1;Solid;False;4;Black Transparent Arial,9,Bold Center Header4 [193:152:89] Center False None;[193:152:89];1;Solid;False;4;Black Transparent Arial,9 Data1 [102:77:38] Center False False False False False [240:237:232] Arial,9 Data2 Black False None;[193:152:89];1;Solid;False;4;Black [240:237:232] Arial,9 Data3 [102:77:38] Center False Top;[193:152:89];1;Solid;False;4;Black Transparent Arial,9 Footer1 [102:77:38] Center False None;[193:152:89];1;Solid;False;4;Black Transparent Arial,12,Bold Right Footer2 [193:152:89] Center 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