I am using a combination of RadSplitters with sliding panes and static panes to display monthly sales data.
The static panes section has 3 radgrids showing Period data, Year-To-Date data and lastly Year-On-Year data
The sliding panes section has to panes the first being a general information and help area telling the user what to do and the second has two comboboxes (both integers) and a checkboxlist (string) - all of which determine the select parameters for the sql datasource.
After making selections each radgrid visibility is set to true and then databound
I have no problem in getting the selected value for each and applying to the datasource, howevere mut problem arises when making multple selections in the checkbox list. For example the user may wish to combine sales departments and view the net result. The second selection only populates the grid when the first is unchecked. How can I stop this to return all or some departments?
SqlDataSource as follows :-
<asp:SqlDataSource ID="YellowBookPeriodSummaryData" runat="server" ConnectionString="<%$ ConnectionStrings:Intranet_DBConnectionString %>"
SelectCommand="SELECT TOP 100 PERCENT Year, Period, SUM(Qty) AS Quantity, SUM(Volume) AS [Vol Sq Ft], SUM(NetSales) AS [Net Value], SUM(StdCost) * - 1 AS Cost, SUM(Margin) AS [Margin ()], (SUM(NetSales) + SUM(StdCost)) / SUM(NetSales) * 100 AS [Margin (%)] FROM Tbl_Sales_Downloads WHERE (SalesCategory IN (@Category)) GROUP BY Year, Period HAVING (Year = @Year) AND (Period = @Period)">
<SelectParameters>
<asp:ControlParameter ControlID="CheckBoxList1" Name="Category" PropertyName="SelectedValue"
Type="String" />
<asp:ControlParameter ControlID="CbxYear" Name="Year" PropertyName="SelectedValue"
Type="Int64" />
<asp:ControlParameter ControlID="CbxPeriod" Name="Period" PropertyName="SelectedValue"
Type="Int64" />
</SelectParameters>
</asp:SqlDataSource>
Any Ideas welcomed
thanks in advance
Chris