ML
    • Recent
    • Categories
    • Tags
    • Popular
    • Users
    • Groups
    • Register
    • Login

    Any Crystal Reports Wizards Here?

    Scheduled Pinned Locked Moved IT Discussion
    12 Posts 4 Posters 1.3k Views
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • anthonyhA
      anthonyh @DustinB3403
      last edited by

      @DustinB3403 said in Any Crystal Reports Wizards Here?:

      So you need to show two records, if the second record matches a particular field in the first record correct?

      Why not create a sub-report that will list all records that match anything in the first record?

      Because this is already a sub-report. 😄

      The desired output is to show the newest record. If the second newest record has the same "name" as the newest record, I need to display both (as this is a flag for the users of said report that they need to fix something in the system).

      1 Reply Last reply Reply Quote 0
      • anthonyhA
        anthonyh
        last edited by

        I THINK I KNOW WHATS HAPPENING!

        The first record is getting suppressed because it doesn't have a "previous" record to match to!

        So I just need to implement logic to say "if this is record 1 don't do anything".

        1 Reply Last reply Reply Quote 0
        • DustinB3403D
          DustinB3403
          last edited by

          Without seeing the report / database it's difficult.

          But I understand a bit better.

          What is your filtering parameter setup for?

          1 Reply Last reply Reply Quote 0
          • anthonyhA
            anthonyh
            last edited by

            BOOM. Adding not(OnFirstRecord) to my logic makes it work beautifully.

            1 Reply Last reply Reply Quote 1
            • DustinB3403D
              DustinB3403
              last edited by

              Glad you got it sorted, wasn't to bad was it?

              anthonyhA 1 Reply Last reply Reply Quote 0
              • aaron-closed accountA
                aaron-closed account Banned
                last edited by

                This post is deleted!
                DustinB3403D 1 Reply Last reply Reply Quote 0
                • DustinB3403D
                  DustinB3403 @aaron-closed account
                  last edited by

                  @aaron said in Any Crystal Reports Wizards Here?:

                  I'm not a wizard, but have used it before and you have my sympathy for even touching it.

                  I don't think Crystal is that bad at all really.

                  It's just a matter of correlating the database records and aligning them to the tables that you need the data on. Everything else is often as simple as just doing the math.

                  aaron-closed accountA wirestyle22W 2 Replies Last reply Reply Quote 0
                  • aaron-closed accountA
                    aaron-closed account Banned @DustinB3403
                    last edited by

                    This post is deleted!
                    1 Reply Last reply Reply Quote 0
                    • wirestyle22W
                      wirestyle22 @DustinB3403
                      last edited by

                      @DustinB3403 said in Any Crystal Reports Wizards Here?:

                      @aaron said in Any Crystal Reports Wizards Here?:

                      I'm not a wizard, but have used it before and you have my sympathy for even touching it.

                      I don't think Crystal is that bad at all really.

                      It's just a matter of correlating the database records and aligning them to the tables that you need the data on. Everything else is often as simple as just doing the math.

                      Database management is my least favorite part of my job

                      1 Reply Last reply Reply Quote 0
                      • anthonyhA
                        anthonyh @DustinB3403
                        last edited by

                        @DustinB3403 lol, no it wasn't.

                        1 Reply Last reply Reply Quote 0
                        • 1 / 1
                        • First post
                          Last post