This is a migrated thread and some comments may be shown as answers.

dynamic run-time chart generation

1 Answer 28 Views
Chart (obsolete as of Q1 2013)
This is a migrated thread and some comments may be shown as answers.
This question is locked. New answers and comments are not allowed.
Russ
Top achievements
Rank 1
Russ asked on 20 Nov 2011, 06:27 AM
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.



1 Answer, 1 is accepted

Sort by
0
Ves
Telerik team
answered on 23 Nov 2011, 01:41 PM
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.

Tags
Chart (obsolete as of Q1 2013)
Asked by
Russ
Top achievements
Rank 1
Answers by
Ves
Telerik team
Share this question
or