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

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
    ACCEPTED ANSWER

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

    ‏2009-07-30T02:21:36Z  in response to SystemAdmin
    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
      ACCEPTED ANSWER

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

      ‏2009-07-30T08:37:36Z  in response to wudongf
      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
        ACCEPTED ANSWER

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

        ‏2009-07-30T09:09:41Z  in response to SystemAdmin
        Hi,

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

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

          ‏2009-07-30T09:11:54Z  in response to wudongf
          It just displays graph without the textbox and button.
          • wudongf
            wudongf
            289 Posts
            ACCEPTED ANSWER

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

            ‏2009-07-30T09:36:29Z  in response to SystemAdmin
            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
              ACCEPTED ANSWER

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

              ‏2009-07-30T13:02:05Z  in response to wudongf
              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
                ACCEPTED ANSWER

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

                ‏2009-07-30T13:04:50Z  in response to SystemAdmin
                PFA model with changes as the reference
                • wudongf
                  wudongf
                  289 Posts
                  ACCEPTED ANSWER

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

                  ‏2009-07-31T05:38:27Z  in response to SystemAdmin
                  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
                    ACCEPTED ANSWER

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

                    ‏2009-08-14T14:10:18Z  in response to wudongf
                    Yes it worked Dong, Thanks a lot.