Alpha Video Training
Results 1 to 6 of 6

Thread: txndate macro help

  1. #1
    Member
    Real Name
    Julianna Brady
    Join Date
    Jun 2010
    Posts
    3

    Default txndate macro help

    Hi,

    I am wanting to change the txndate macro from "all" to specific dates. I am trying to create a report where I can see who has not order in a specific amount of time (not just the 30 days the software comes with). With this report I am wanting to be able to change the amount of time. Can someone give me an idea of how I can do this? Thank you.

  2. #2
    Volunteer Moderator
    Real Name
    Alan Buchholz
    Join Date
    Oct 2000
    Location
    Delavan, Wisconsin
    Posts
    9,644

    Default Re: txndate macro help

    Julianne

    I'm not sure where you are starting from. Can you fill in the blanks for me?
    Al Buchholz
    Bookwood Systems, LTD
    Weekly QReportBuilder Webinars Thursday 1 pm CST

    Occam's Razor - KISS
    Normalize till it hurts - De-normalize till it works.
    Advice offered and questions asked in the spirit of learning how to fish is better than someone giving you a fish.
    When we triage a problem it is much easier to read sample systems than to read a mind.

  3. #3
    Member
    Real Name
    Julianna Brady
    Join Date
    Jun 2010
    Posts
    3

    Default Re: txndate macro help

    Hi, essentially I am just wanting to change the No Invoices in 30 days report so I can see who hasn't ordered in 1 yr, 1 yr, etc. I was just trying to build the report from scratch because I couldn't find a way to modify the other one. Thank you.

  4. #4
    "Certified" Alphaholic
    Real Name
    Mike Christensen
    Join Date
    Nov 2005
    Location
    Michigan U.P.
    Posts
    5,937

    Default Re: txndate macro help

    Julianna,
    I revamped that report to something that works a bit differently and more modifiable by other users.

    It involved creating a subtract operation and then running the report. I converted the operation into a script. The date parameter is used in the operation. But currently is 30 days and hard coded. It would have to be changed slightly to use a date variable that could be created in a number of ways.

    Import the two files in the zip from the SHARE area of QRB....the QRBR is the report definition and the TXT is the script.


    Attachment 25226
    Mike
    __________________________________________
    It is only when we forget all our learning that we begin to know.
    It's not what you look at that matters, it's what you see.
    Henry David Thoreau
    __________________________________________




  5. #5
    Member
    Real Name
    Julianna Brady
    Join Date
    Jun 2010
    Posts
    3

    Default Re: txndate macro help

    Thanks! I installed it. Now how do I change the amount of days?

    Sincerely,

    Julianna

  6. #6
    "Certified" Alphaholic
    Real Name
    Mike Christensen
    Join Date
    Nov 2005
    Location
    Michigan U.P.
    Posts
    5,937

    Default Re: txndate macro help

    If you want this to be completely dynamic for the user, then some form of dialog box will have to be used to choose a date that a variable is then set to that can be used by the subtract operation.

    An xdialog box for dates can be created with genies using the Action Scripting. I would try making the variable a "shared" one...for sure not a local and possibly may have to be global.

    Once done, then the filter in the operation script can be set to the variable instead of the hard coded 30 days.

    Hope this steers you to the right path.
    Mike
    __________________________________________
    It is only when we forget all our learning that we begin to know.
    It's not what you look at that matters, it's what you see.
    Henry David Thoreau
    __________________________________________




Similar Threads

  1. Macro substitution
    By frankbicknell in forum Application Server Version 10 - Web/Browser Applications
    Replies: 3
    Last Post: 03-23-2010, 02:24 PM
  2. Macro Programming? Something like that?
    By Ralf in forum Alpha Five Version 8
    Replies: 5
    Last Post: 09-23-2007, 11:54 AM
  3. Recording a Macro?
    By flucky07 in forum Alpha Five Version 7
    Replies: 13
    Last Post: 04-04-2007, 11:29 PM
  4. Macro
    By yoshi higashio in forum Alpha Four Version 6 and Prior
    Replies: 6
    Last Post: 03-01-2003, 09:40 AM
  5. macro
    By BWilliams in forum Alpha Five Version 5
    Replies: 2
    Last Post: 09-30-2002, 08:26 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •