1 Reply Latest reply on Sep 28, 2015 5:40 PM by erolst

    create a report showing attendance in multiple events

    ejolesch

      I have a database made up of 3 tables, Company, Event, and Registration.

       

      I have created a report showing all of the events each company attend, summarized by Company.

       

      What I am trying to figure out is how to create two different reports

       

      One Report showing only the Companies that are attending only one event

      and the

      Other Report showing companies that will be attending more than one event.

       

      Can anyone offer me a suggestion or guidance as to how to accomplish this?

       

      Thanks

      Elliot

        • 1. Re: create a report showing attendance in multiple events
          erolst

          Use the fast summary technique:

           

          Create a summary field in registration that counts the primary key.

           

          Find your Registration records for the given date range (by querying the related Event table), or use the entire found set.

           

          Then use the same script with different script parameters:

           

          # [ after you've established the found set ]

          Set Variable [ $action; Value:"reportOnMulti" // "reportOnOne" ]

          # [ simulate a script parameter ]

          Sort Records [ Keep records in sorted order; Specified Sort Order: Registration::id_company; ascending ] [ Restore; No dialog ]

          Go to Record/Request/Page

          [ First ]

          Loop

            Set Variable [ $countThisGroup; Value:GetSummary ( Registration::sCountID ;

          Registration::id_company ) ]

            Set Variable [ $nextGroupAt; Value:Get ( RecordNumber ) + $countThisGroup ]

            If [ Case (

          $action = "reportOnOne" ; $countThisGroup > 1 ; $countThisGroup = 1

          )]

              Omit Multiple Records [ $countThisGroup ] [ No dialog ]

              Exit Loop If [ not Get ( FoundCount ) ]

            Else

              Exit Loop If [ $nextGroupAt > Get ( FoundCount ) ]

              Go to Record/Request/Page [ $nextGroupAt ] [ No dialog ]

            End If

          End Loop