Multiple selections for graphs

(5 posts) (2 voices)
  1. Shamgar, Member

    Is there a way to allow the user to select multiple options from a popup or radio list?

    In my case, I want to be able to have a multiple series line chart, where the lines included are based on what is selected by the user from a list.

    Also, do I have to do a separate SQL query for each feature I want to put on a page, even if it's the same query?

  2. myDBR Team, Key Master

    Popup and radio buttons are by default single selection entities. You could have multiple popup's as parameter and put 'None' as the first option. We are considering putting checkbox as one of the user parameter options.

    Also, do I have to do a separate SQL query for each feature I want to put on a page, even if it's the same query?

    Do you have an example what do you mean by same query? All myDBR elements on report are results of SQL query. You can have as many of them as you like in one procedure and if same query repeats itself in procedure you can utilize procedures control of flow language to achieve this.

    --
    myDBR Team

  3. Shamgar, Member

    Well, for example, on one report page I want to have a graph of the data, as well as a table of the same data. Currently I put in the graph options, then the query, then the table options, then the query again. I'm just curious if there's a more efficient way to do this that will still be caught appropriately by mydbr.

    For those circumstances where you need to reuse the result set (sometimes outcome of complex queries), sometimes best approach is to consider using temporary tables for storing result set. Since temporary tables are connection specific they are quite suitable for this kind of scenario. Also, being connection specific, you do not have to worry about conflicts with multiple users.

    --
    myDBR Team

  4. Shamgar, Member

    And yes, the checkboxes was what I was specifically looking for. In thinking about it some more, I'm not sure how exactly that would be handled, since I don't *think* the stored procedures can handle variable argument lists, but if there's a way it would be really handy.

    There is couple of options of doing this. As said, we'll see if we can produce nice enough solution for this in future releases.

    --
    myDBR Team

  5. Shamgar, Member

    And yes, the checkboxes was what I was specifically looking for. In
    thinking about it some more, I'm not sure how exactly that would be
    handled, since I don't *think* the stored procedures can handle
    variable argument lists, but if there's a way it would be really handy.

  6. myDBR Team, Key Master

    And yes, the checkboxes was what I was specifically looking for. In thinking about it some more, I'm not sure how exactly that would be handled, since I don't *think* the stored procedures can handle variable argument lists, but if there's a way it would be really handy.

    There are a couple of options how to do this cleanly. The feature itself is on the TODO- list. No fixed version yet.

    --
    myDBR Team


Reply

You must log in to post.