Alpha Software Mobile Development Tools:   Alpha Anywhere    |   Alpha TransForm subscribe to our YouTube Channel  Follow Us on LinkedIn  Follow Us on Twitter  Follow Us on Facebook

Announcement

Collapse

The Alpha Software Forum Participation Guidelines

The Alpha Software Forum is a free forum created for Alpha Software Developer Community to ask for help, exchange ideas, and share solutions. Alpha Software strives to create an environment where all members of the community can feel safe to participate. In order to ensure the Alpha Software Forum is a place where all feel welcome, forum participants are expected to behave as follows:
  • Be professional in your conduct
  • Be kind to others
  • Be constructive when giving feedback
  • Be open to new ideas and suggestions
  • Stay on topic


Be sure all comments and threads you post are respectful. Posts that contain any of the following content will be considered a violation of your agreement as a member of the Alpha Software Forum Community and will be moderated:
  • Spam.
  • Vulgar language.
  • Quotes from private conversations without permission, including pricing and other sales related discussions.
  • Personal attacks, insults, or subtle put-downs.
  • Harassment, bullying, threatening, mocking, shaming, or deriding anyone.
  • Sexist, racist, homophobic, transphobic, ableist, or otherwise discriminatory jokes and language.
  • Sexually explicit or violent material, links, or language.
  • Pirated, hacked, or copyright-infringing material.
  • Encouraging of others to engage in the above behaviors.


If a thread or post is found to contain any of the content outlined above, a moderator may choose to take one of the following actions:
  • Remove the Post or Thread - the content is removed from the forum.
  • Place the User in Moderation - all posts and new threads must be approved by a moderator before they are posted.
  • Temporarily Ban the User - user is banned from forum for a period of time.
  • Permanently Ban the User - user is permanently banned from the forum.


Moderators may also rename posts and threads if they are too generic or do not property reflect the content.

Moderators may move threads if they have been posted in the incorrect forum.

Threads/Posts questioning specific moderator decisions or actions (such as "why was a user banned?") are not allowed and will be removed.

The owners of Alpha Software Corporation (Forum Owner) reserve the right to remove, edit, move, or close any thread for any reason; or ban any forum member without notice, reason, or explanation.

Community members are encouraged to click the "Report Post" icon in the lower left of a given post if they feel the post is in violation of the rules. This will alert the Moderators to take a look.

Alpha Software Corporation may amend the guidelines from time to time and may also vary the procedures it sets out where appropriate in a particular case. Your agreement to comply with the guidelines will be deemed agreement to any changes to it.



Bonus TIPS for Successful Posting

Try a Search First
It is highly recommended that a Search be done on your topic before posting, as many questions have been answered in prior posts. As with any search engine, the shorter the search term, the more "hits" will be returned, but the more specific the search term is, the greater the relevance of those "hits". Searching for "table" might well return every message on the board while "tablesum" would greatly restrict the number of messages returned.

When you do post
First, make sure you are posting your question in the correct forum. For example, if you post an issue regarding Desktop applications on the Mobile & Browser Applications board , not only will your question not be seen by the appropriate audience, it may also be removed or relocated.

The more detail you provide about your problem or question, the more likely someone is to understand your request and be able to help. A sample database with a minimum of records (and its support files, zipped together) will make it much easier to diagnose issues with your application. Screen shots of error messages are especially helpful.

When explaining how to reproduce your problem, please be as detailed as possible. Describe every step, click-by-click and keypress-by-keypress. Otherwise when others try to duplicate your problem, they may do something slightly different and end up with different results.

A note about attachments
You may only attach one file to each message. Attachment file size is limited to 2MB. If you need to include several files, you may do so by zipping them into a single archive.

If you forgot to attach your files to your post, please do NOT create a new thread. Instead, reply to your original message and attach the file there.

When attaching screen shots, it is best to attach an image file (.BMP, .JPG, .GIF, .PNG, etc.) or a zip file of several images, as opposed to a Word document containing the screen shots. Because Word documents are prone to viruses, many message board users will not open your Word file, therefore limiting their ability to help you.

Similarly, if you are uploading a zipped archive, you should simply create a .ZIP file and not a self-extracting .EXE as many users will not run your EXE file.
See more
See less

Pass Date from and Date to Entered into Report

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Pass Date from and Date to Entered into Report

    Hi,

    Thank you in advance to all those that have helped me.

    I have a question pls.

    I have used summaraize operations to create me totals and have used the following to collect data from date to date range and put into a table for me.

    (date_1 >= var->AskD_From_Date ) .and. (date_1 <= var->AskD_To_Date )

    The way it works is by clicking on a button which activates the above summarize operation then the report is launched by using this data collected by the above.

    What I would like to do is to add in the footer of teh report the from and to date via a text field.

    Is there anyway to do this?

    Thank You

    Joe

  • #2
    Re: Pass Date from and Date to Entered into Report

    No. That's one of the reasons I suggested you learn other methods of obtaining user input.

    If you use form variables or xdialog variables and dim them as global you can reference them in the form design ie place them in the report footer.
    There can be only one.

    Comment


    • #3
      Re: Pass Date from and Date to Entered into Report

      Hi Stan,

      Thank you for the reply. I guess its all a learning experience.

      Is there a sample database with how variables are used?

      Joe

      Comment


      • #4
        Re: Pass Date from and Date to Entered into Report

        Joe, try this.

        In your report design, remove the filter expression. Then use the "V" tool on the report design toolbar to define two global variables of data type "D". (for date) One will be for the beginning date, the other for the ending date, right?

        Then drag / drop both variables into your report layout's page or report header band.

        Save your report.

        Now open your form in design mode and define the same variables as Global, and drop them on your form layout. Run your form. Insert begin and end dates into the variables and push your button to call your report.

        The values entered in the form should now appear in the report at print / preview time. Pat yourself on your back, you've just passed variables from the form to the report.

        This sequence is step 1.

        Step 2 is using the variables in your report layout to re-define the required filter expression.

        Have fun, let us know how this goes.

        Comment


        • #5
          Re: Pass Date from and Date to Entered into Report

          Hi Joe,

          I did put this reply into the other thread too.

          Try these two videos: http://screencast.com/t/MZgX7iWE and http://screencast.com/t/QYbzRb0Vm1

          Hope they help you.
          Regards
          Keith Hubert
          Alpha Guild Member
          London.
          KHDB Management Systems
          Skype = keith.hubert


          For your day-to-day Needs, you Need an Alpha Database!

          Comment


          • #6
            Re: Pass Date from and Date to Entered into Report

            Thanks for your reply Keith.

            Tom has been a great help as well and showed me on skype how to achieve this.

            Will test it shortly.

            Joe

            Comment


            • #7
              Re: Pass Date from and Date to Entered into Report

              OK Thanks Keith your screencasts are very helpful.

              Tried using the filter condition below and was hoping for the date pop up messages to appear but its not when the summarize operation is activated.

              Is this possible or do I need to tackle it another way?

              The variables are vd_begin_date and vd_end_date.

              (date_1 >= var->vd_begin_date ) .and. (date_1 <= var->vd_end_date )

              Thanks Again

              Joe

              Comment


              • #8
                Re: Pass Date from and Date to Entered into Report

                Hi Joe,
                Tried using the filter condition below and was hoping for the date pop up messages to appear but its not when the summarize operation is activated.
                I don't understand this, what has this got to do with selecting records for your report?
                Regards
                Keith Hubert
                Alpha Guild Member
                London.
                KHDB Management Systems
                Skype = keith.hubert


                For your day-to-day Needs, you Need an Alpha Database!

                Comment


                • #9
                  Re: Pass Date from and Date to Entered into Report

                  Hi Keith,

                  This is all sorted and is all working.

                  A lack of sleep was the culprit. Works well.

                  Thank you to everyone for replying and helping me out.
                  Joe

                  Comment


                  • #10
                    Re: Pass Date from and Date to Entered into Report

                    Originally posted by wolf View Post
                    Hi Keith,

                    This is all sorted and is all working.

                    A lack of sleep was the culprit. Works well.

                    Thank you to everyone for replying and helping me out.
                    Joe
                    Hi Joe
                    Please describe the way you solved this other than sleep LOL
                    It's quite an important topic.

                    Comment


                    • #11
                      Re: Pass Date from and Date to Entered into Report

                      Hello,

                      I opened up my report in design mode and clicked on the v button to add variables. Clicked on Global and added them here so they can be shared through out the program.

                      The variables I added are vd_begin_date and vd_end_date

                      eg

                      vd_begin_date = {}
                      vd_end_date = {}

                      Put the above in global and save.

                      These now appear under the variables section near the tool box in reports. You can add both to the report and you can add for example Report Date Range from to
                      in between the two you just dragged onto the form. The dates that pop up here are from when you add the dates on the form latter on below.

                      Next in my Summarize operation I added

                      Field -> "Filter" next column Summarization I added Null next column in operation I added (date_1 >= var->vd_begin_date ) .and. (date_1 <= var->vd_end_date )

                      You can use Alpha genies to create this code if you like.

                      In my wisdom I expected pop box to appear to add the dates once the summarize operation was activated by clicking on it but nothing happened so had to activate this another way.

                      Next I opened up a form in design mode and added the variables again in global.

                      I then dragged these from the toolbar section onto the forms. With Alphas magic 2 text boxes were added for the dates with the calendar pop up.

                      I added a button and added some code on activate to run the summarize operation, followed by opening the report.

                      Running the Report

                      I ran the form, added the dates then clicked on the button.

                      What happens here is very simple. The summarize operation is activated first and collects the data within date range via the variables (via the form where I added these manually) and puts this into the output table for me.

                      Then the report was activated (when I clicked on the button after the summarize operation) and I have the report with the required data.

                      The report itself when run had its own scripts to show the top 20 with the data showing only with t fields. T for True.

                      That's it really.

                      Hope this helps and its easy to understand.
                      Last edited by wolf; 03-24-2013, 06:09 AM.

                      Comment


                      • #12
                        Re: Pass Date from and Date to Entered into Report

                        Hi Joe,
                        I added a button and added some code on activate to run the summarize operation, followed by opening the report.
                        I hope you mean OnPush rather than OnActivate?

                        It seems to me that you are not collecting the range dates from a dialog box as shown in the two videos I made for you.

                        The way you have it, a user can press the report button without selecting any dates. That does lead to frustration on the part of the user, as they then have to start over, when they could of been made to collect the dates in the first place.
                        Last edited by Keith Hubert; 03-24-2013, 07:00 AM.
                        Regards
                        Keith Hubert
                        Alpha Guild Member
                        London.
                        KHDB Management Systems
                        Skype = keith.hubert


                        For your day-to-day Needs, you Need an Alpha Database!

                        Comment


                        • #13
                          Re: Pass Date from and Date to Entered into Report

                          Its good.
                          To avoid overpopulating the global var population I standardise on one start date and finish date var used in any every other aspect of the system for reporting

                          Comment


                          • #14
                            Re: Pass Date from and Date to Entered into Report

                            Hi Keith,

                            Yep your right.
                            I tried the Dialog box early this morning and did not get it to work.

                            Just applied it again now and it works well.

                            If anyone is going to use the text fields best thing to do is disable the button and on change event or something similiar of the second date you can activate the button again.

                            Your way though is better.

                            Yep if I need to create 20 reports I would only use the 2 variables for all reports.

                            Thanks

                            Joe

                            Comment


                            • #15
                              Re: Pass Date from and Date to Entered into Report

                              Keith one question.

                              If there is no data, the report will be blank.

                              Is there a way to avoid this or show a message box eg no data in report?

                              Joe

                              Comment

                              Working...
                              X