1 Reply Latest reply on Jun 23, 2009 9:55 AM by philmodjunk

    creating reports within a specific time frame as specified by the user

    njoyce

      Title

      creating reports within a specific time frame as specified by the user

      Post

      Hi,

       

      I want to be able to create a report of certain information that occured between two dates, but i want the user to be able to specify those dates each time. So, basically I have a button that says something like "give me all the studies between specified dates" and when it's clicked, something pops up that allows the user to specify the dates and then report generated is only for that specified time period. 

       

      is this possible?

       

      thanks!

        • 1. Re: creating reports within a specific time frame as specified by the user
          philmodjunk
            

          If want to use a pop-up, the simplest is to use Show Custom Dialog and specify two global date fields as input field 1 and input field 2.

           

          Then this script will find your records:

           

          Enter Find Mode []

          Set Field [yourtable::yourdatefield; globaldatefield1 & "..." & globaldatefield2]

          Set Error Capture [on]

          Perform find []

          Set Error Capture [off]

           

           

          The one problem with using Show Custom Dialog is that no validation is automatically performed on the input fields. It may be better to place the two global fields next to your button and dispense with the pop-up.