dynamic run-time chart generation

2 posts, 0 answers
  1. Russ
    Russ avatar
    2 posts
    Member since:
    Oct 2011

    Posted 20 Nov 2011 Link to this post

    Hello,

    I'm new to Telerik (programming in general) so forgive the brutish design.  As such, I was wondering if I could get some general design/feasibility pointers on this project.  If "design" questions are not the purpose here, by all means let me know.  

    I'm trying to build a system that allows users to select options and items that will then generate a report for them (see attached pic if needed).  I'm sure this has been done a thousand times but surprisingly I haven't found much online.

    My approach was to build multi-level modular Sql text command that UI control input result groups would snap into, roughly:

    public string MasterCmdStr = selectPart +
    wherePart +
    groupByPart +
    orderByPart;

    private string Level1CmdStr()
    {
    string selectPart = GetSelectPart();
    string wherePart = GetWherePart();
    string groupByPart = GetGroupByPart();
    string OrderByPart = GetOrderByPart();

    //apply final logic, snytax checking, logic checking
    }

    private string GetSelectPart()
    {
    string yAxisCat = BuildCmdYAxis();
            string xAxisCat = BuildCmdYAxis();
           

    //compile results with other parts, alter syntax
    }

    private string BuildCmdYAxis()
    {
      string contextCat = radDropDownList3.Text;
      string chartType = radDropDownList4.Text;
    xAxisItems = GetRadListControl5();

    //compile results, apply logic...etc
    }

    etc...

    I'm quickly finding out that this might get out of control... due to the complexity of sql queries I want to enable (multiple WHEREs mixed with multiple GROUP BYs) and due to the need to customize radchart settings per query to make output presentable (like the requirements to format the X Axis if a user selects a DateTime context).

    So, am I way out of my league here?  Is there a better way to approach this?

    Thanks for any help.



  2. Ves
    Admin
    Ves avatar
    2879 posts

    Posted 23 Nov 2011 Link to this post

    Hi Russ,

    This forum is dedicated to RadChart for winforms, so you may need to check other forums, oriented to general questions (like this one) to get more attention/suggestions. However, if a specific RadChart issue arises, do not hesitate to post it here or in a support ticket.

    Best regards,
    Ves
    the Telerik team

    Q3’11 of RadControls for WinForms is available for download (see what's new). Get it today.

  3. UI for WinForms is Visual Studio 2017 Ready
Back to Top