Jump to content
We've recently updated our Privacy Statement, available here ×

mwarner_2

Members
  • Posts

    58
  • Joined

  • Last visited

Community Answers

  1. mwarner_2's post in How to manage a LOV using $X parameter in input control was marked as the answer   
    Create a date parameter in your main report.  Let's name it "Select_Date".
    Export the report to the server.
    In JS Server, under input controls, create an input control with a Parameter name of"Select_Date".  Make it a single select query.  In the input control's Define the Query, you make a query like "Select DATA_RIFERIMENTO from Oracle_table_exact_name".  For both the Value Column and the Visible Column enter DATA_RIFERIMENTO.  Don't forget to press Add after entering the Visible Column.
    In JS Server, find and edit your imported report, specifically edit the input controls.  Click on Controls and Resources.  Click on the "Select_Date" control.  Select an Input Control for the Repository.  Choose your JS Server input control called "Select_Date".  Save the changes to the report. 
    When you run the report, the JS Server input control runs, and its "Select DATA_RIFERIMENTO from Oracle_table_exact_name" SQL runs and fetches the dates, and displays them in the Select_Date report parameter.
×
×
  • Create New...