Announcement

Collapse
No announcement yet.

Bug in PDF-Report with WHERE-Clause

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

  • Bug in PDF-Report with WHERE-Clause

    Hi,

    given report type: Records per Line

    SQL-Command (Master):

    Code:
    SELECT MasterID, field1, field2, field3 FROM table_master WHERE MasterID = 1
    SQL-Command (SubSelect):

    Code:
    SELECT SubID, MasterID, field1, field2, field3 FROM table_sub WHERE MasterID = {MasterID}
    This works fine ...


    I want now a multipage pdf and change the SQL-Command (Master) to:

    Code:
    SELECT MasterID, field1, field2, field3 FROM table_master WHERE MasterID IN (1, 2)
    In this case, SC prints a "mixed" record set ... = Bug!
    Last edited by RHS; 08-09-2013, 04:12 AM. Reason: ID -> MasterID
    Best regards: - Reinhard -

    I use ScriptCase 8 Enterprise Edition, Version 8.(latest)

  • #2
    Hello,

    Issue reported to our bugs team.

    regards,
    Bernhard Bernsmann

    Comment


    • #3
      Hello Reinhard,

      Our bugs team followed all steps you described but was unable to simulate the issue.

      Could you export your application to bugs@scriptcase.net?

      regards,
      Bernhard Bernsmann

      Comment


      • #4
        Hello Bernhard,

        i have send two test applications and the sql file.
        Best regards: - Reinhard -

        I use ScriptCase 8 Enterprise Edition, Version 8.(latest)

        Comment


        • #5
          Hello,

          I will "update" them as well.

          regards,
          Bernhard Bernsmann

          Comment


          • #6
            E-Mail send: at 14.08.2013
            Response at: 21.08.2013 ("We simulate your problem ...")
            Solution: ?
            Best regards: - Reinhard -

            I use ScriptCase 8 Enterprise Edition, Version 8.(latest)

            Comment


            • #7
              Hello Reinhard,

              I will get in touch with our bugs team.

              regards,
              Bernhard Bernsmann

              Comment


              • #8
                Hello Reinhard,

                I was informed by our development team that this is actually the default behavior of Records per Line Report.

                regards,
                Bernhard Bernsmann

                Comment


                • #9
                  Originally posted by bartho View Post
                  [...] this is actually the default behavior of Records per Line Report.
                  Yes, but that is regardless a bug!

                  This "information" has by the way now take nearly a month. Do you understand why most people do not think much of netmake support? Or pay for it ...?
                  Best regards: - Reinhard -

                  I use ScriptCase 8 Enterprise Edition, Version 8.(latest)

                  Comment


                  • #10
                    @John L. Santos: this problem / bug is not solved ...
                    Best regards: - Reinhard -

                    I use ScriptCase 8 Enterprise Edition, Version 8.(latest)

                    Comment


                    • #11
                      Hello Reinhard,

                      I will contact our bugs team.

                      Thanks!

                      Comment


                      • #12
                        Hello,

                        I talked last week with the developers regarding this problem. It really is a default behavior of the application,
                        the application Report PDF uses the FPDF PHP class, and not even the FPDF allows this behavior.
                        We're checking out a workaround using a foreach, as used in the body of the PDF.
                        Once I get some feedback, I send you a response.
                        Best Regards,
                        John L. Santos

                        Bug Tracker Team
                        NetMake - IT Solutions

                        Comment

                        Working...
                        X