dynamic run-time chart generation

[Russ]

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.

[Ves]

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