True 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 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 OrderMonth,OrderMonth,System.Int64,Month_x0028_Orders_x002E_OrderDate_x0029_ 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 ByMonth OrderMonth,System.Int64 OrderID_Count,System.Int64 OrderMonth ByMonth Orders OrderID Count OrderID_Count 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,3 Transparent 0,0.1,7.5,2.9 bpReportDescription Arial,8 0,0,0,0 Text15 Basically, we created a Datasource from other Datasource. We wanted to group by a calculated column OrderMonth which was set to Month(Orders.OrderDate), so we could total the number of orders per month (ignore the year), but the calculated column does not seem to work as a group by. It allows me to configure it, but it does not produce correct results. When run I want to see a report that looks like: Month Count 1 10 2 4 3 6 4 14 5 50 6 19 7 10 8 60 9 10 10 20 11 10 12 14 Is there any way to accomplish the above report, or is the Calculated Column going to work as the "group by" in the datasource?? Black HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, ReportTitleBand1 Transparent 0,3.6,8.3,0.6 None;[255:0:0];1;Solid;False;4;Black [92:92:92] 0.1,0,7.4,0.6 Arial,10 0,0,0,0 Text11 this databand should only have 12 entries ... it is grouped by a calculated column that only has the values 1 thru 12. But you can see that the grouping does not work. [255:255:255] HeaderBand1 Transparent 0,4.6,8.3,0.2 Transparent 1.5,0,0.6,0.2 Arial,10 0,0,0,0 Text7 {ByMonth.OrderMonth} Black Transparent 0.4,0,1.1,0.2 Arial,10 0,0,0,0 Text8 OrderMonth Black Transparent 3.8,0,0.6,0.2 Arial,10 0,0,0,0 Text9 {ByMonth.OrderID_Count} Black Transparent 2.7,0,1.1,0.2 Arial,10 0,0,0,0 Text10 OrderID_Count Black ByMonth DataBand2 Transparent 0,5.2,8.3,0.2 Transparent 1.1,0,0.6,0.2 Arial,10 0,0,0,0 Text1 {Orders.OrderID} Black Transparent 0,0,1.1,0.2 Arial,10 0,0,0,0 Text2 OrderID Black Transparent 3.5,0,1.3,0.2 Arial,10 0,0,0,0 Text3 {Orders.OrderDate} Black Transparent 2.4,0,1.1,0.2 Arial,10 0,0,0,0 Text4 OrderDate Black Transparent 6.5,0,0.9,0.2 Arial,10 0,0,0,0 Text5 {Orders.OrderMonth} Black Transparent 5.4,0,1.1,0.2 Arial,10 0,0,0,0 Text6 OrderMonth Black Orders DataBand1 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 05/01/2012 04:21:32 PM 02/03/2011 03:10:07 PM Report.mrt f6378957ccbabe82c2330ab571ec201d Report Inches 2012.1.1300 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