New call-to-action
Results 1 to 19 of 19

Thread: How do I create a report based on the parameters of the filter date

  1. #1
    Member
    Real Name
    dicky.kurniawan2501
    Join Date
    Jul 2014
    Posts
    58

    Default How do I create a report based on the parameters of the filter date

    Hi

    I want to make a print feature on my program, I apply it with a web-based alpha:
    -to date, I use data types: datetime
    Allows the data currently displayed all the data from January to August
    Allows the print button i connect it to report that I have made
    For example:

    -I filter from 1 July 2014 to 31 July 2014 and then I want to display a report of that date. How do I create the parameters for the report?
    -How ways to get the summing of the total amount, FX, CIF according in the picture that I attach?

    How to make a parameter to choose the print at the time of going to print according to the data of my filters?

    1.png 2.png 3.png

    thank you

  2. #2
    "Certified" Alphaholic
    Real Name
    Govindan Gandhi
    Join Date
    Aug 2008
    Location
    New York, NY
    Posts
    4,294

    Default Re: How do I create a report based on the parameters of the filter date

    Did you try to use time for the arguments, as suggested last time?
    I don't have data with datetime to test or show, if you are not able to accomplish then I will create a table to see if I can help.
    thanks for reading

    gandhi

    version 11 3381 - 4096
    mysql backend
    http://www.alphawebprogramming.blogspot.com
    ggandhi344@gmail.com
    Skype:ggandhi344@gmail.com
    1 914 924 5171

  3. #3
    Member
    Real Name
    dicky.kurniawan2501
    Join Date
    Jul 2014
    Posts
    58

    Default Re: How do I create a report based on the parameters of the filter date

    Quote Originally Posted by GGandhi View Post
    Did you try to use time for the arguments, as suggested last time?
    I don't have data with datetime to test or show, if you are not able to accomplish then I will create a table to see if I can help.

    already. but the result is empty.

    thanks Gandhi

  4. #4
    "Certified" Alphaholic
    Real Name
    Govindan Gandhi
    Join Date
    Aug 2008
    Location
    New York, NY
    Posts
    4,294

    Default Re: How do I create a report based on the parameters of the filter date

    You had same question on a different thread, I remember seeing, a thread with Keith and I. You asked me and I suggested at that time.
    I will search and give he thread link.
    Hope my memory is good.
    thanks for reading

    gandhi

    version 11 3381 - 4096
    mysql backend
    http://www.alphawebprogramming.blogspot.com
    ggandhi344@gmail.com
    Skype:ggandhi344@gmail.com
    1 914 924 5171

  5. #5
    "Certified" Alphaholic
    Real Name
    Govindan Gandhi
    Join Date
    Aug 2008
    Location
    New York, NY
    Posts
    4,294

    Default Re: How do I create a report based on the parameters of the filter date

    http://msgboard.alphasoftware.com/al...er+report+date

    Here is that link. You asked towards the end, the second from last I suggested at that time.
    memory is good, I pass.
    thanks for reading

    gandhi

    version 11 3381 - 4096
    mysql backend
    http://www.alphawebprogramming.blogspot.com
    ggandhi344@gmail.com
    Skype:ggandhi344@gmail.com
    1 914 924 5171

  6. #6
    "Certified" Alphaholic
    Real Name
    Govindan Gandhi
    Join Date
    Aug 2008
    Location
    New York, NY
    Posts
    4,294

    Default Re: How do I create a report based on the parameters of the filter date

    Also by looking at your sample report image I see 12:0 after date, are you referring how to remove just leave behind the date?
    thanks for reading

    gandhi

    version 11 3381 - 4096
    mysql backend
    http://www.alphawebprogramming.blogspot.com
    ggandhi344@gmail.com
    Skype:ggandhi344@gmail.com
    1 914 924 5171

  7. #7
    Member
    Real Name
    dicky.kurniawan2501
    Join Date
    Jul 2014
    Posts
    58

    Default Re: How do I create a report based on the parameters of the filter date

    Quote Originally Posted by GGandhi View Post
    You had same question on a different thread, I remember seeing, a thread with Keith and I. You asked me and I suggested at that time.
    I will search and give he thread link.
    Hope my memory is good.
    yes it's me, I'm confused with the datetime. Your memory is good

    thank you

  8. #8
    "Certified" Alphaholic
    Real Name
    Govindan Gandhi
    Join Date
    Aug 2008
    Location
    New York, NY
    Posts
    4,294

    Default Re: How do I create a report based on the parameters of the filter date

    try with time as argument in the selection, if you are not able to do and if the data is not sensitive send a sample to me
    I will see if I can help
    (MySQL is easy for me, mssql I could try)
    thanks for reading

    gandhi

    version 11 3381 - 4096
    mysql backend
    http://www.alphawebprogramming.blogspot.com
    ggandhi344@gmail.com
    Skype:ggandhi344@gmail.com
    1 914 924 5171

  9. #9
    "Certified" Alphaholic
    Real Name
    Govindan Gandhi
    Join Date
    Aug 2008
    Location
    New York, NY
    Posts
    4,294

    Default Re: How do I create a report based on the parameters of the filter date

    Also by looking at your sample report image I see 12:0 after date, are you referring how to remove that, just leave behind the date
    Last edited by GGandhi; 09-24-2014 at 06:14 AM.
    thanks for reading

    gandhi

    version 11 3381 - 4096
    mysql backend
    http://www.alphawebprogramming.blogspot.com
    ggandhi344@gmail.com
    Skype:ggandhi344@gmail.com
    1 914 924 5171

  10. #10
    Member
    Real Name
    dicky.kurniawan2501
    Join Date
    Jul 2014
    Posts
    58

    Default Re: How do I create a report based on the parameters of the filter date

    Quote Originally Posted by GGandhi View Post
    Also by looking at your sample report image I see 12:0 after date, are you referring how to remove that, just leave behind the date
    How do I remove the time as a report and also only displays the date when I filter the distance between the date?

    thanks

  11. #11
    "Certified" Alphaholic
    Real Name
    Govindan Gandhi
    Join Date
    Aug 2008
    Location
    New York, NY
    Posts
    4,294

    Default Re: How do I create a report based on the parameters of the filter date

    when you define the arguments look at the bottom right hand side, it will say advanced option click on that and then select the middle one that says keep only the date and discard time. that should do it.
    thanks for reading

    gandhi

    version 11 3381 - 4096
    mysql backend
    http://www.alphawebprogramming.blogspot.com
    ggandhi344@gmail.com
    Skype:ggandhi344@gmail.com
    1 914 924 5171

  12. #12
    Member
    Real Name
    dicky.kurniawan2501
    Join Date
    Jul 2014
    Posts
    58

    Default Re: How do I create a report based on the parameters of the filter date

    This setting me on the grid components and report and so are the results :

    Pictures.zip

  13. #13
    "Certified" Alphaholic
    Real Name
    Govindan Gandhi
    Join Date
    Aug 2008
    Location
    New York, NY
    Posts
    4,294

    Default Re: How do I create a report based on the parameters of the filter date

    thanks for reading

    gandhi

    version 11 3381 - 4096
    mysql backend
    http://www.alphawebprogramming.blogspot.com
    ggandhi344@gmail.com
    Skype:ggandhi344@gmail.com
    1 914 924 5171

  14. #14
    Member
    Real Name
    dicky.kurniawan2501
    Join Date
    Jul 2014
    Posts
    58

    Default Re: How do I create a report based on the parameters of the filter date

    Quote Originally Posted by GGandhi View Post
    thanks gandhi

  15. #15
    "Certified" Alphaholic
    Real Name
    Govindan Gandhi
    Join Date
    Aug 2008
    Location
    New York, NY
    Posts
    4,294

    Default Re: How do I create a report based on the parameters of the filter date

    I saw the pictures, all look correct but you have one argument
    if you like report between two dates then have two arguments
    such as start and end then you can say between start and end
    you are using same arguments twice. if that work for you then it is fine.
    thanks for reading

    gandhi

    version 11 3381 - 4096
    mysql backend
    http://www.alphawebprogramming.blogspot.com
    ggandhi344@gmail.com
    Skype:ggandhi344@gmail.com
    1 914 924 5171

  16. #16
    Member
    Real Name
    dicky.kurniawan2501
    Join Date
    Jul 2014
    Posts
    58

    Default Re: How do I create a report based on the parameters of the filter date

    okay,that's works

    thanks

  17. #17
    Member
    Real Name
    dicky.kurniawan2501
    Join Date
    Jul 2014
    Posts
    58

    Default Re: How do I create a report based on the parameters of the filter date

    I've managed to filter but when I apply the ui tabbed why appear can not run on a working preview? anything wrong there my settings?

    p1.jpg p2.jpg

    thank you so much

  18. #18
    "Certified" Alphaholic
    Real Name
    Govindan Gandhi
    Join Date
    Aug 2008
    Location
    New York, NY
    Posts
    4,294

    Default Re: How do I create a report based on the parameters of the filter date

    Nothing wrong with your settings.
    It is alpha, as the message indicates.
    Switch to live preview or publish and test in your machine and see how that works.
    If happy publish to your production server.
    thanks for reading

    gandhi

    version 11 3381 - 4096
    mysql backend
    http://www.alphawebprogramming.blogspot.com
    ggandhi344@gmail.com
    Skype:ggandhi344@gmail.com
    1 914 924 5171

  19. #19
    Member
    Real Name
    dicky.kurniawan2501
    Join Date
    Jul 2014
    Posts
    58

    Default Re: How do I create a report based on the parameters of the filter date

    thanks gandhi

Similar Threads

  1. Create date ranges based on user input
    By ssmoore1 in forum Application Server Version 10 - Web/Browser Applications
    Replies: 0
    Last Post: 10-17-2010, 05:39 PM
  2. Report based on a filter
    By Mark Pearson in forum Application Server Version 9 - Web/Browser Applications
    Replies: 10
    Last Post: 08-30-2009, 10:14 PM
  3. How do I show selected filter parameters for a report in the report
    By Robert Rough in forum Alpha Five Version 7
    Replies: 14
    Last Post: 10-03-2006, 02:36 PM
  4. Date Based dropdown list filter does not filter
    By Steve Bovino in forum Web Application Server v6
    Replies: 17
    Last Post: 10-15-2005, 08:36 AM
  5. Passing Filter Parameters to Report
    By Jim Stephenson in forum Alpha Five Version 5
    Replies: 2
    Last Post: 06-21-2004, 05:50 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
  •