Topic
  • 9 replies
  • Latest Post - ‏2009-08-14T14:10:18Z by SystemAdmin
SystemAdmin
SystemAdmin
801 Posts

Pinned topic Showing Summary and Drilldown graph based on the input given

‏2009-07-29T09:48:30Z |
Hello,

Am trying to show a graph with Summary and Drilldown builder based on the input given. Initally the graph displays fine with the default value in the variable but when I enter a number and click on submit button the graph doesnt appear. Since we cannot dispay Summary and Drilldown builder on a tag, it just disappears when the button is submitted.

Can anyone help me if there is any other way to achieve this functionality of changing the graph based on the input given. PFA model for reference and the SQL as below:

SQL Statement: SELECT SVPDIF, count(svpld) AS "Open_Calls" FROM sbs400d11.leadsvp WHERE SVPLD >= ? and svpld <= ? and SVPGP = ? and svpyer >= 8 AND SVPDES = 'CUSTOMER EARLIEST' GROUP BY SVPDIF ORDER BY SVPDIF
IN Parameter 1: 28/06/09
IN Parameter 2: 29/07/09
IN Parameter 3: [1]

Thanks in advance!!
Updated on 2009-08-14T14:10:18Z at 2009-08-14T14:10:18Z by SystemAdmin
  • wudongf
    wudongf
    289 Posts

    Re: Showing Summary and Drilldown graph based on the input given

    ‏2009-07-30T02:21:36Z  
    Hi,

    In your btnSubmit, you'll need to call another method other than GetInitParams. And in the method, invoke GetInitParams, than call ScheduleVisitsProfileSummaryPage to display your page.
  • SystemAdmin
    SystemAdmin
    801 Posts

    Re: Showing Summary and Drilldown graph based on the input given

    ‏2009-07-30T08:37:36Z  
    • wudongf
    • ‏2009-07-30T02:21:36Z
    Hi,

    In your btnSubmit, you'll need to call another method other than GetInitParams. And in the method, invoke GetInitParams, than call ScheduleVisitsProfileSummaryPage to display your page.
    Hi Dong,

    Thankyou very much for the reply.Out of my head even calling another method doesnt seem to solve the issue and its the same issue as earlier.
    Can pls suggest if am doing anything wrong.

    Thanks,
    Neil.
  • wudongf
    wudongf
    289 Posts

    Re: Showing Summary and Drilldown graph based on the input given

    ‏2009-07-30T09:09:41Z  
    Hi Dong,

    Thankyou very much for the reply.Out of my head even calling another method doesnt seem to solve the issue and its the same issue as earlier.
    Can pls suggest if am doing anything wrong.

    Thanks,
    Neil.
    Hi,

    I see you are process two pages in mthDisplayPage. What happens if you remove the webAppAccess.processPage("pgeDropDown");?
  • SystemAdmin
    SystemAdmin
    801 Posts

    Re: Showing Summary and Drilldown graph based on the input given

    ‏2009-07-30T09:11:54Z  
    • wudongf
    • ‏2009-07-30T09:09:41Z
    Hi,

    I see you are process two pages in mthDisplayPage. What happens if you remove the webAppAccess.processPage("pgeDropDown");?
    It just displays graph without the textbox and button.
  • wudongf
    wudongf
    289 Posts

    Re: Showing Summary and Drilldown graph based on the input given

    ‏2009-07-30T09:36:29Z  
    It just displays graph without the textbox and button.
    Well, this is what I expect.

    We can not call processPage twice to display two pages.

    Can you insert your textbox and button into Summary Page?
  • SystemAdmin
    SystemAdmin
    801 Posts

    Re: Showing Summary and Drilldown graph based on the input given

    ‏2009-07-30T13:02:05Z  
    • wudongf
    • ‏2009-07-30T09:36:29Z
    Well, this is what I expect.

    We can not call processPage twice to display two pages.

    Can you insert your textbox and button into Summary Page?
    Well I have added the button and textbox in summaryPage.html which is given as input in the Summary and Drilldown builder and this gives the textbox and button with the graph upon clicking but it doesnot actually submit the form to change the the graph according to the given input value in the textbox.

    I guess I shd write some onclick Javascript function on the button, but not sure how can I call the page ScheduleVisitsProfileSummaryPage in the function.
  • SystemAdmin
    SystemAdmin
    801 Posts

    Re: Showing Summary and Drilldown graph based on the input given

    ‏2009-07-30T13:04:50Z  
    Well I have added the button and textbox in summaryPage.html which is given as input in the Summary and Drilldown builder and this gives the textbox and button with the graph upon clicking but it doesnot actually submit the form to change the the graph according to the given input value in the textbox.

    I guess I shd write some onclick Javascript function on the button, but not sure how can I call the page ScheduleVisitsProfileSummaryPage in the function.
    PFA model with changes as the reference
  • wudongf
    wudongf
    289 Posts

    Re: Showing Summary and Drilldown graph based on the input given

    ‏2009-07-31T05:38:27Z  
    PFA model with changes as the reference
    Hi,

    You'll still need your button builder (btnSubmit).
    Add one name attribute for the submit input, and place btnSubmit on that input.

    <input type="submit" name="submitname" value="" class="portlet-form-go-button" style="padding-bottom: 20px; margin-bottom: -8px;"/>
  • SystemAdmin
    SystemAdmin
    801 Posts

    Re: Showing Summary and Drilldown graph based on the input given

    ‏2009-08-14T14:10:18Z  
    • wudongf
    • ‏2009-07-31T05:38:27Z
    Hi,

    You'll still need your button builder (btnSubmit).
    Add one name attribute for the submit input, and place btnSubmit on that input.

    <input type="submit" name="submitname" value="" class="portlet-form-go-button" style="padding-bottom: 20px; margin-bottom: -8px;"/>
    Yes it worked Dong, Thanks a lot.