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

HTML Reports for web applications - How?

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

    HTML Reports for web applications - How?

    Has anyone created filtered HTML style reports for a web application EASILY? If you have an invoice application running via the WAS and you want to print out an invoice while viewing the web page from an Apple IPad in Safari, Safari's Adobe addin does not allow you to print a pdf report which you might have created in A5.

    So instead, I assume you would create and generate an HTML report with a filter for that particular invoice. Thus, you could press a button on the web app while viewing it on the IPad to generate the HTML report and then print it easily, since it is easy to print any web page on an IPad from within Safari.

    So is there an easy way to build a filtered HTML report such as an invoice with (multiple?) 1:many relations in the A5 developer?
    Regards,
    Chet Sapino
    President,
    SAPINO Enterprises
    6451 Pheasant Rd
    East Syracuse, NY 13057

    #2
    Re: HTML Reports for web applications - How?

    Sreve Workings and Andy Meer have nine videos on HTML reports in Xbasic for Web Apps video series.. They are not easy, but very professional looking. They do make it a little easier with sample files to create a lot of the work that can be downloaded and run via MySQL Toad or Workbench.

    Comment


      #3
      Re: HTML Reports for web applications - How?

      If you have already created an existing Layout Table report in A5, you can easily generate HTML output. Just right click on the layout table report and select "Show XBasic...". Then click the "Convert to HTML" tab and check the "Embed in A5W" checkbox. Click the "Copy to Clipboard" button and paste the code into a blank A5W page. Then just open the A5W page however you want and you will get an HTML report. You can filter the report using arguments. Note: There is a bug with how the generated HTML code passes arguments to the Reporting::reportGenerator class. If you're interested I can document the workaround.

      Comment


        #4
        Re: HTML Reports for web applications - How?

        I have that video series and it is not easy to routinely accomplish.
        Regards,
        Chet Sapino
        President,
        SAPINO Enterprises
        6451 Pheasant Rd
        East Syracuse, NY 13057

        Comment


          #5
          Re: HTML Reports for web applications - How?

          Yes please do. It is important that we have it in our bag of tricks!
          Regards,
          Chet Sapino
          President,
          SAPINO Enterprises
          6451 Pheasant Rd
          East Syracuse, NY 13057

          Comment


            #6
            Re: HTML Reports for web applications - How?

            Dave,

            I click on Report Layout and then Show Basic and there is no tab to Convert to HTML.

            Comment


              #7
              Re: HTML Reports for web applications - How?

              Okay here goes -- If you want to save yourself a lot of time testing the auto-generated HTML code and the workaround for passing arguments, I suggest pasting the "Show Xbasic" code into the Interactive Window and replacing the last line "?outhtml" with the following: a5_show_html(outhtml). This will display your HTML report in a popup window so you can make sure everything is working correctly before pasting the code into an actual A5W page and opening it in a Tabbed UI or something. This is what the last five lines of Xbasic code should look like:

              if filter <> "" then
              rg.ApplyFilter(filter)
              end if
              dim outhtml as c = rg.Generate()
              a5_show_html(outhtml)

              Just remember to put the "?outhtml" back in when you actually paste the code into an A5W page.

              The bug with the generated HTML output is that it does not pass the arguments to the report generator. You need to insert some code for all of your report arguments just before this line: "rg.Load(htmlReportDef)". Here is an example:

              . . .

              dim args as sql::arguments
              args.add("argname1","value1")
              args.add("argname2","value2")
              rg.arguments = args

              rg.Load(htmlReportDef)

              If your report does not have any arguments, then you do not need to do anything.

              That should do it. There is one other problem only if you use "a5_GetArgumentValue()" in a calculated field. Let me know if you do and I will look for my notes on this workaround.

              Comment


                #8
                Re: HTML Reports for web applications - How?

                You will not see this tab on a free-form report. It must by a layout-table or quick report type.

                Comment


                  #9
                  Re: HTML Reports for web applications - How?

                  Those videos are mostly V10 and they mention that this will be much easier in V11. Steve Workings has a video on HTML reporting in his Total Training V11 Series(very good, by the way). I wish he had included one more video on reporting though. In fact if he had a subscription plan for this series I'd be the first to sign up!

                  Comment


                    #10
                    Re: HTML Reports for web applications - How?

                    Any idea why I would be getting this error:

                    Script Error
                    Error:Script:" /a_rpt_inventory.a5w" line:173
                    dim outhtml as c = rg.Generate()
                    No table name specified for database source.

                    My code starts with:
                    dim htmlReportDef as c = <<%html%
                    A5Report::Report
                    source=SQL:::Name::conn
                    select=SELECT * FROM av_inventory
                    ...
                    - Dan Hooley
                    - Custom Desktop or Web database development -

                    Comment


                      #11
                      Re: HTML Reports for web applications - How?

                      This is the first 5 lines of Xbasic output I get when I have "Include stylesheet" turned off. It looks like the comment tag is missing "<!". What version of A5 are you using?

                      dim htmlReportDef as c
                      htmlReportDef = <<%html%
                      <!--A5Report::Report
                      source=SQL:::Name::SQL Server 2008
                      select=SELECT Id, Lastname, FirstName, MiddleName, etc.

                      Comment


                        #12
                        Re: HTML Reports for web applications - How?

                        Alpha Five Application Server/11.0 Build/3244-4076

                        I took that comment tag out because I was getting a different error with it in:

                        Script Error
                        Error:Script:" /a_rpt_inventory.a5w" line:173
                        dim outhtml as c = rg.Generate()
                        Access is denied.
                        .ALB
                        - Dan Hooley
                        - Custom Desktop or Web database development -

                        Comment


                          #13
                          Re: HTML Reports for web applications - How?

                          Does it work inside of the Interactive Window? Copy the code from the "Convert to HTML" tab into the Interactive Window. Replace the last line - "?outhtml" with "a5_show_html(outhtml)". Then run the entire script.

                          Comment


                            #14
                            Re: HTML Reports for web applications - How?

                            Yes, it works fine in the interactive window - with the comment tag in place.
                            - Dan Hooley
                            - Custom Desktop or Web database development -

                            Comment


                              #15
                              Re: HTML Reports for web applications - How?

                              It sounds like a permissions or security problem.

                              Comment

                              Working...
                              X