Alpha Video Training
Results 1 to 6 of 6

Thread: How do you show a date range on a quarterly and yearly report?

  1. #1
    Member
    Real Name
    Pat Domanski
    Join Date
    Jun 2009
    Posts
    79

    Default How do you show a date range on a quarterly and yearly report?

    Hello,

    How do you show the date range that was used on a quarterly and yearly report so that the date range prints with the report? I am using an ASK variable when the report is running. I thank you for your help.

    Regards,

    Pat

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

    Default Re: How do you show a date range on a quarterly and yearly report?

    Pat,
    The ask variables show up in the drag-drop list and can be utilized....either directly or a calculated field can be created (XY Icon from top menu) and then the calculated field will show up in the drag-drop list.
    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
    __________________________________________




  3. #3
    "Certified" Alphaholic Tom Henkel's Avatar
    Real Name
    Tom Henkel
    Join Date
    May 2002
    Location
    New Jersey, USA
    Posts
    1,877

    Default Re: How do you show a date range on a quarterly and yearly report?

    Whre are you asking for the dates? In the report itself, or prior to the report in a dialog box?

    In either case, the variables are available to you. You just need to take them from the dragdrop list and place them on the header of the report.

    Tom

  4. #4
    Member
    Real Name
    Pat Domanski
    Join Date
    Jun 2009
    Posts
    79

    Default Re: How do you show a date range on a quarterly and yearly report?

    Hi Mike,

    I did not see the ask variables in the drag-drop list, but I drag over the "Current Filter" from the "System" drag-drop list. See JPG attachment. I don't understand why the ask variable is not listed in the drag-drop list?

    But how do I make it read as follows: "From 04/2/2010 to 04/27/2010" instead of the way it looks now? I have attached the ZIP file as well. Again, thank you.

    Regards,

    Pat



    Quote Originally Posted by MikeC View Post
    Pat,
    The ask variables show up in the drag-drop list and can be utilized....either directly or a calculated field can be created (XY Icon from top menu) and then the calculated field will show up in the drag-drop list.

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

    Default Re: How do you show a date range on a quarterly and yearly report?

    Pat,
    I wasn't thinking I guess.....the ask variable would show up but only if it had been dimmed as a Global variable. I checked out the Report Filter, found the Ask variable names, and then used them in creating a calculated field for what you want (check out the XY menu icon).

    Attachment 24385
    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
    __________________________________________




  6. #6
    Member
    Real Name
    Pat Domanski
    Join Date
    Jun 2009
    Posts
    79

    Default Re: How do you show a date range on a quarterly and yearly report?

    Hello Mike,

    I thank you for your help and I have a better understanding of how it works too.

    Regards,

    Pat



    Quote Originally Posted by MikeC View Post
    Pat,
    I wasn't thinking I guess.....the ask variable would show up but only if it had been dimmed as a Global variable. I checked out the Report Filter, found the Ask variable names, and then used them in creating a calculated field for what you want (check out the XY menu icon).

    Attachment 24385

Similar Threads

  1. How do you create a quarterly and yearly report using dates?
    By Patd in forum Alpha Five Version 10 - Desktop Applications
    Replies: 12
    Last Post: 04-12-2010, 10:54 AM
  2. Report by Date Range
    By eboughey1 in forum Application Server Version 9 - Web/Browser Applications
    Replies: 3
    Last Post: 02-17-2009, 03:47 PM
  3. Report with prompt for date range
    By Dave Wilson in forum Alpha Five Version 6
    Replies: 6
    Last Post: 11-02-2005, 10:20 AM
  4. Date range in report
    By BWilliams in forum Alpha Five Version 6
    Replies: 11
    Last Post: 11-09-2004, 11:39 AM
  5. Date Range in Report
    By Jerry Gray in forum Alpha Five Version 6
    Replies: 4
    Last Post: 08-21-2004, 04:23 PM

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
  •