0 Replies Latest reply: Oct 29, 2009 12:25 PM by GuinnessDrinker _ RSS

    Runtime parameter

    GuinnessDrinker _

      Hello

      Can anyone help?

      Is it possible to display data from a table using runtime parameters of a date to display only that data which relates to the runtime date There is a date column in the data

      In essence the same as running a filter to pick only data with the required date

        • Runtime parameter
          Grant Perkins

          Hi GuinnessDrinker,

           

          If I have understood your requirement correctly the answer is yes. Just set up a Calculated field for the Runtime Parameter (watch for 'Save between runs' and making it a required field) and then create a filter that uses the RT file for its value.

           

          If you want to automate it I seem to recall that that is also catered for though I must confess it is not something I can recall trying out in anger in script.

           

          HTH.

           

           

          Grant

            • Runtime parameter
              GuinnessDrinker _

              Thanks for your quick reply Grant

              Maybe I didn't explain very well or I don't know monarch as well as I thought I did

               

              below is an example of the data

               

               

              Date             Amount

              2009-01-10     1

              2009-01-11     2

              2009-01-11     2

              2009-01-12     3

              2009-01-12     3

              2009-01-12     4

              2009-01-12     5

              2009-01-13     6

              2009-01-14     7

              2009-01-14     7

              2009-01-14     7

              2009-01-14     7

              2009-01-14     7

              /CODE

               

              What I want to do is somehow enter a runtime parameter to filter out all but the data that is for the required date

              Does that make sense

              • Runtime parameter
                Data Kruncher

                Don't get angry; just use the /set command line parameter to make it easy.

                 

                /set:FieldName=FieldValue[/code]will do the trick.

                 

                Be sure to test and ue the CtoD function if necessary in your filter expression.

                 

                HTH,

                Kruncher