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

Report Totals to different table

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

    Report Totals to different table

    Hello
    I have a report that group records and then produces report totals in the report footer.
    A separate line in the report footer calculates what each total is of as a percentage of the total records of the report.

    Rather than manually transcribe these totals and percentages to another table, is there any way I can post their values to the table, after the report has been run?
    Kind Regards

    Alex
    Database Software Solutions Limited
    www.dbasesolution.co.uk
    http://www.precise360.co.uk
    PRECISE360 -
    LYNCHPIN -

    #2
    Re: Report Totals to different table

    Alex,

    I can't think of a way to achieve this directly from the report. Perhaps it would help if I could see the expression you use to generate the line in the report footer that calculates what percentage each "group" total is. I'm having trouble imagining how this might be done.

    Also, please answer a couple of "context" questions: Is the report based on a single table, or a set of tables? Are you grouping the parent records, or something else?

    Comment


      #3
      Re: Report Totals to different table

      http://msgboard.alphasoftware.com/al...t=write+report
      There can be only one.

      Comment


        #4
        Re: Report Totals to different table

        Originally posted by Tom Cone Jr View Post
        Alex,

        I can't think of a way to achieve this directly from the report. Perhaps it would help if I could see the expression you use to generate the line in the report footer that calculates what percentage each "group" total is. I'm having trouble imagining how this might be done.

        The expression is just a grand total of values against records, (total(Posaval,grp->Grand,grp->Detail) and the percentage field is calc->Posagt/calc->Mtxs*100 where Mtxs is the record count.

        Also, please answer a couple of "context" questions: Is the report based on a single table, or a set of tables? Are you grouping the parent records, or something else?
        Report is based on a single table with no grouping. The report is a simple record listing.

        Kind Regards

        Alex
        Database Software Solutions Limited
        www.dbasesolution.co.uk
        http://www.precise360.co.uk
        PRECISE360 -
        LYNCHPIN -

        Comment


          #5
          Re: Report Totals to different table

          Thanks, Stan.

          Alex, when you check the code used in the example Stan cites, be aware that values are being pulled from objects in the report layout, so report object names are used in the script ( instead of field names from the table ) when getting the values.

          Comment


            #6
            Re: Report Totals to different table

            Hi Stan

            Thanks for the reference. My request is simpler because I have no groups on the report. Is there no way in Action scripting I can pass the values to a separate table, say on Exit.

            Or have I reached the limits of Action Scripting?

            Kind Regards

            Alex
            Database Software Solutions Limited
            www.dbasesolution.co.uk
            http://www.precise360.co.uk
            PRECISE360 -
            LYNCHPIN -

            Comment


              #7
              Re: Report Totals to different table

              no groups? Your first post is misleading. Please clarify.

              expression used to generate the percentages (I requested this but it hasn't been shown). Why not?


              Even better supply sample data and the report layout itself.

              You ask: Is there no way in Action scripting I can pass the values to a separate table, say on Exit.
              I think the answer is no, but I'm now badly confused about what you are attempting.

              Comment


                #8
                Re: Report Totals to different table

                Tom

                It was my mistake in the first message regarding groups. There are no groups.

                Expression used in percentages, I thought I had given this. It is a simple grand total of a report generated calculated field at record level, divided over the number of records in the report.

                Re the what I am trying to achieve.
                It hasn't changed Tom since my opening thread.

                Can I post the values generated by a report to a different table.

                I think Stan has offered an area worth exploring regrading using the objects on the report.
                I'll check this out and come back if I am successful.

                Many thanks for your input.
                It is greatly appreciated.

                Kind Regards

                Alex
                Database Software Solutions Limited
                www.dbasesolution.co.uk
                http://www.precise360.co.uk
                PRECISE360 -
                LYNCHPIN -

                Comment


                  #9
                  Re: Report Totals to different table

                  Alex,

                  Let me see if I got that right. You have a report based on a single table. The report footer contains a calc field that divides the total of a numeric field in each record by the number of records in the report. You want to either update an existing record in a different table, or you want to enter a new record in the other table. You want this to happen each time the report is run. You want the computed average value (from the report) to be passed to the other table. You want to know if this can be done with action scripting.

                  How'd I do?

                  Comment


                    #10
                    Re: Report Totals to different table

                    Originally posted by Tom Cone Jr View Post
                    Alex,

                    Let me see if I got that right. You have a report based on a single table.

                    Correct.

                    The report footer contains a calc field that divides the total of a numeric field in each record by the number of records in the report.

                    Correct


                    You want to either update an existing record in a different table, or you want to enter a new record in the other table.

                    I would like to take the values generated by the report and write them to a different table, creating a new record for each of the grand totals and their percentages.

                    The new table has fields for:
                    Column A (report total of a calculated field occurring at record line level
                    Column A PC = percentage) Column A divided over number of records inn the report.
                    Column B (report total of a calculated field occurring at record line level
                    Column B PC = percentage) Column A divided over number of records inn the report.
                    Column C (report total of a calculated field occurring at record line level
                    Column C PC = percentage) Column A divided over number of records inn the report.

                    etc

                    You want this to happen each time the report is run.
                    Correct

                    You want the computed average value (from the report) to be passed to the other table.
                    Correct. In the report footer the grand total of the calculated field at record level appears under the column and the percentage value appearing below. - for each of the columns -

                    You want to know if this can be done with action scripting.
                    Correct

                    How'd I do?
                    Very Good!


                    Thanks for your help. It is very much appreciated.

                    Kind regards

                    Alex
                    Database Software Solutions Limited
                    www.dbasesolution.co.uk
                    http://www.precise360.co.uk
                    PRECISE360 -
                    LYNCHPIN -

                    Comment


                      #11
                      Re: Report Totals to different table

                      Alex,

                      I've extended the example Stan cited.

                      Unzip the attachment to an empty folder.

                      You'll see that I've made two changes:

                      a) I've created a new table to hold the grand total for the field being summed.

                      b) I've added a new script to the OnRecord event of the Grand Event Section of the Report.

                      Each time the report is run the grand total is written to the new table.

                      You should be able to use this as a pattern for each of your report columns.

                      -- tom
                      Attached Files

                      Comment


                        #12
                        Re: Report Totals to different table

                        Tom

                        Thank you very much for your generous and kind help.

                        Even down to adding notes to the Xbasic.

                        You are indeed a wonderful asset to the Message Board.

                        Kind Regards

                        Alex
                        Database Software Solutions Limited
                        www.dbasesolution.co.uk
                        http://www.precise360.co.uk
                        PRECISE360 -
                        LYNCHPIN -

                        Comment

                        Working...
                        X