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

Can`t print PDF/Tempreport

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

    Can`t print PDF/Tempreport

    Hi there,

    since my application is hosted by a professional hoster I have this prob while looking a report. On my machine it works fine.
    Any help is appreciated.

    Best
    Matthias

    Errors in: event.AfterValidate code:
    'Alpha Five Printer' (for creating PDF, RTF and HTML output) is not installed. Re-install Alpha Five Application Server

    #2
    Re: Can`t print PDF/Tempreport

    Who is your host? Have you contacted them about the message? That would seem appropriate here.
    -Steve
    sigpic

    Comment


      #3
      Re: Can`t print PDF/Tempreport

      It is Zebrahost but he told me that is a problem concerning programming :-(.

      Best Matthias

      Comment


        #4
        Re: Can`t print PDF/Tempreport

        I don't believe this is a hosting issue. The WAS is installed correctly. In fact Matthias reinstalled it himself after getting that error message.

        If someone could let us know how to install the Alpha Five printer (without having to install Alpha Five on the server itself) that would be great.

        I believe this is an alias issue in the Web Publishing Profile.
        Affordable Alpha Five, PHP, MySQL Hosting.
        Serving Webmasters since 2000.ZebraHost

        Comment


          #5
          Re: Can`t print PDF/Tempreport

          to make it clear: this is definitively not a hosting issue. This is a programming one. But I can't get the right command. After setting the command "install A5 printer driver" he told me that there is a stack underflow. That shows me it is definitively a programming error.
          Any suggestions?

          Best Matthias

          Comment


            #6
            Re: Can`t print PDF/Tempreport

            Thanks Matthias:

            Just so that anyone reading Matthais' post understands correctly. When Matthais says "he told me there is a stack underflow" the "he'" is the program.

            Matthais' English is way better than my German.
            Affordable Alpha Five, PHP, MySQL Hosting.
            Serving Webmasters since 2000.ZebraHost

            Comment


              #7
              Re: Can`t print PDF/Tempreport

              Well then, I think the next thing we oughta do is see the AfterValidate code.

              I, too, doubt that this is a WAS installation issue, especially if other people are successfully producing pdfs with that host -- I take this assumption to be true.

              So, let's see the code?
              -Steve
              sigpic

              Comment


                #8
                Re: Can`t print PDF/Tempreport

                Matthias,

                Is the pdf printer installed on the WAS?
                Do it manually, not via code. I have done it manually and all works good.

                Walter

                Comment


                  #9
                  Re: Can`t print PDF/Tempreport

                  Walter:

                  Can you describe how to do that manually?

                  Thanks.
                  Affordable Alpha Five, PHP, MySQL Hosting.
                  Serving Webmasters since 2000.ZebraHost

                  Comment


                    #10
                    Re: Can`t print PDF/Tempreport

                    Clive,

                    Go to Program files , a5v8 applicationserver folder, look for the InstallAmyuniPrinters.exe

                    This should do the trick.

                    Walter

                    Comment


                      #11
                      Re: Can`t print PDF/Tempreport

                      Walter,

                      this I installed this via code. This created the message `stack underflow'. Would be great if it works if its installed manually.

                      Thanks. Guess that Clive will do it. I can't install any printers on his machine.

                      Matthias

                      Comment


                        #12
                        Re: Can`t print PDF/Tempreport

                        Here is the After Validate File:
                        Whats wrong with it? The error message ist `stack underflow'.

                        Matthias

                        if atc("alpha five printer", ui_printers_get() ) = 0 then
                        a5_installamyuni()
                        end if

                        period = CurrentForm.Controls.Report_List

                        if CurrentForm.Controls.Report_Type = "1" then
                        dim filter as c
                        dim order as c
                        Filter = "Re_account = \"CA11048\""
                        Order = "str(Jahr,19,5)+str(Monat,19,5)"
                        Dim filename as c
                        filename = session.session_folder + "tempreport.pdf"
                        filename = report.saveas("WTR Limit-Checker@[PathAlias.ADB_Path]\wtr.set","pdf",filter,order,filename,.f.)
                        if file.exists(filename)
                        currentform.RedirectTarget = session.session_url + "tempreport.pdf?" + time("hms3")

                        end if
                        else
                        IF eval_valid("period") = .f. Then
                        goto skipreport
                        end if
                        dim filter as c
                        dim order as c
                        Filter = "(Monat = "+convert_type(period,"C")+" ) .and. (Re_account = \"CA11048\" )"
                        Order = ""
                        Dim filename as c
                        filename = session.session_folder + "tempreport.pdf"
                        filename = report.saveas("WTR Limit-Checker@[PathAlias.ADB_Path]\wtr.set","pdf",filter,order,filename,.f.)
                        if file.exists(filename)
                        currentform.RedirectTarget = session.session_url + "tempreport.pdf?" + time("hms3")
                        end if
                        skipreport:

                        end if

                        Comment


                          #13
                          Re: Can`t print PDF/Tempreport

                          Walter:

                          We have been able to get it running manually. Which server did you get it working on?

                          Clive
                          Affordable Alpha Five, PHP, MySQL Hosting.
                          Serving Webmasters since 2000.ZebraHost

                          Comment


                            #14
                            Re: Can`t print PDF/Tempreport

                            Matthias,

                            I can see a couple of possibilities.

                            First, the help for UI_PRINTERS_GET() says it is for desktop use only. I would take it out of your script.

                            Second, there is a space in your report name. This often causes problems. You should close up the space or make it an underscore character.

                            Pat
                            Pat Bremkamp
                            MindKicks Consulting

                            Comment


                              #15
                              Re: Can`t print PDF/Tempreport

                              A couple other things about your script.

                              You define
                              Code:
                              period = CurrentForm.Controls.Report_List
                              then later you say
                              Code:
                              IF eval_valid("period") = .f. Then
                              goto skipreport
                              end if
                              that is unnecessary because it will always exist...because you defined it.

                              Later, you use
                              Code:
                              Filter = "(Monat = "+convert_type(period,"C")+" ) .and. (Re_account = \"CA11048\" )"
                              However, all fields on a web page are already character, so there is no need to convert period...it is character.

                              Then, it looks like the second part of your script is printing exacly the same report, only with a different filter and order, so you could say

                              Code:
                               
                              dim filter as c 
                              dim order as c 
                              if CurrentForm.Controls.Report_Type = "1" then
                              Filter = "Re_account = \"CA11048\""
                              Order = "str(Jahr,19,5)+str(Monat,19,5)"
                              else
                              Filter = "Monat="+quote(period)+".and. Re_account=\"CA11048\""
                              Order = ""
                              end if
                              Dim filename as c 
                              filename = session.session_folder + "tempreport.pdf"
                              filename = report.saveas("WTR_[EMAIL="WTR_Limit-Checker@"]Limit-Checker@[/EMAIL][PathAlias.ADB_Path]\wtr.set","pdf",filter,order,filename,.f.)
                              if file.exists(filename) 
                              currentform.RedirectTarget = session.session_url + "tempreport.pdf?" + time("hms3")
                              Pat
                              Pat Bremkamp
                              MindKicks Consulting

                              Comment

                              Working...
                              X