Is there a proper technique of some sort to have the calendar or just a way to pass a specific date to an existing quick report spec?  Basically all the other retrieve information in the spec are always the same but there are times a user wants to run the report for yesterday or a specific date instead of today. 

Somewhere I thought I remember seeing something on this but no matter how I search I am not finding it.

presently I am using the code below. My thought if there is not some magical Lantica / Hammer Data / Sesame Forum recommended technique is to build the entire retrieve spec in sbasic with the calendar popup for the user to select and then run the saved sort spec,  and   RunQuickReportSpec.

Thoughts on doing this?

Thanks


var VStr as string
var vRun as int

     // Loads an already saved retrieve spec for use
     vStr = @SpecCommand(SPEC_OPERATION_LOAD, SPEC_TYPE_RETRIEVE, "DailyPosting")
     
     // Runs the currently loaded retrieve spec
     vStr = @SpecCommand(SPEC_OPERATION_RUN, SPEC_TYPE_RETRIEVE, "")
     
     // Loads an already saved sort spec for use
     vStr = @SpecCommand(SPEC_OPERATION_LOAD, SPEC_TYPE_SORT, "DailyPosting")
     
     // Runs the currently loaded sort spec
     vStr = @SpecCommand(SPEC_OPERATION_RUN, SPEC_TYPE_SORT, "")
     
     if(@Mode() = 1)
     {
           vRun = @LoadQuickReportSpec("DailyPosting")
           if(vRun = 1)
           {
                 RunQuickReportSpec(REPORT_MODE_HTML_PREVIEW, PRINT_ORIENTATION_LANDSCAPE)

                 // Clears the current retrieve spec
                 vStr = @SpecCommand(SPEC_OPERATION_CLEAR, SPEC_TYPE_RETRIEVE, "")
           }
     }

Ray as always you are the BEST!

This is such a nice and elegant solution that works like a charm. I can see so many ways to use this technique and with very minor tweaking can easily see using it to create ranges with start dates and end dates.

This is the perfect building block type of Sbasic code that is ideal to add to my  toolbox of code you have given me over the years.

Thanks for taking your time to do this for me, once again this is proof that Hammer Data / Lantica  has the best people and surely the best customer service (actually customer care!) of any company around.

your effort is really appreciated, Thanks Again!