Report properties question?

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • zufie
    #1

    Report properties question?

    I have a report that return all the records (materials ordered) by all
    callers each day.

    I want the report to just show all the records (materials ordered) by
    each individual caller each day
    on a separate page.

    I tried Hide Duplicates property, Force New Page all to no success.

    Here is the code to my qry/record source for my report:

    SELECT Trim([Last Name]) & ", " & Trim([First Name]) & " " &
    Trim([Middle Initial]) AS Expr2, [qry DaysReport1].*, Caller.[Last
    Name], Caller.[First Name]
    FROM [qry DaysReport1] INNER JOIN Caller ON [qry DaysReport1].[Caller
    ID] = Caller.[Caller ID];

    What must I change on Properties of my report?

    Thanks,
    John


    Tags: None
    • fredg
      #2
      Re: Report properties question?

      On Fri, 26 Sep 2008 10:03:59 -0700 (PDT), zufie wrote:
      I have a report that return all the records (materials ordered) by all
      callers each day.
      >
      I want the report to just show all the records (materials ordered) by
      each individual caller each day
      on a separate page.
      >
      I tried Hide Duplicates property, Force New Page all to no success.
      >
      Here is the code to my qry/record source for my report:
      >
      SELECT Trim([Last Name]) & ", " & Trim([First Name]) & " " &
      Trim([Middle Initial]) AS Expr2, [qry DaysReport1].*, Caller.[Last
      Name], Caller.[First Name]
      FROM [qry DaysReport1] INNER JOIN Caller ON [qry DaysReport1].[Caller
      ID] = Caller.[Caller ID];
      >
      What must I change on Properties of my report?
      >
      Thanks,
      John
      In Report Design View, click on View + Sorting and Grouping.
      In the Field/Expression column, write
      Expr2

      In the lower panel set
      Group Header = Yes.

      Back in report design view, click on the group header. Set the Group
      Header Force New Page property to BeforeSection. Place the Expr2
      control in the Group Header.
      --
      Fred
      Please respond only to this newsgroup.
      I do not reply to personal e-mail

        Comment

        • zufie
          #3
          Re: Report properties question?

          On Sep 26, 12:39 pm, fredg <fgutk...@examp le.invalidwrote :
          On Fri, 26 Sep 2008 10:03:59 -0700 (PDT), zufie wrote:
          I have a report that return all the records (materials ordered) by all
          callers each day.
          >
          I want the report to just show all the records (materials ordered) by
          each individual caller each day
          on a separate page.
          >
          I tried Hide Duplicates property, Force New Page all to no success.
          >
          Here is the code to my qry/record source for my report:
          >
          SELECT Trim([Last Name]) & ", " & Trim([First Name]) & " " &
          Trim([Middle Initial]) AS Expr2, [qry DaysReport1].*, Caller.[Last
          Name], Caller.[First Name]
          FROM [qry DaysReport1] INNER JOIN Caller ON [qry DaysReport1].[Caller
          ID] = Caller.[Caller ID];
          >
          What must I change on Properties of my report?
          >
          Thanks,
          John
          >
          In Report Design View, click on View + Sorting and Grouping.
          In the Field/Expression column, write
          Expr2
          >
          In the lower panel set
          Group Header = Yes.
          >
          Back in report design view, click on the group header. Set the Group
          Header Force New Page property to BeforeSection. Place the Expr2
          control in the Group Header.
          --
          Fred
          Please respond only to this newsgroup.
          I do not reply to personal e-mail- Hide quoted text -
          >
          - Show quoted text -
          Fred,
          You are a GENIUS!!!!!!!!! !!!!!!!!!!!!

          You made my day!!!!!!!!!!!! !!!!!!!!

          THANK YOU!!!!!!!!!

          John

            Comment

            • zufie
              #4
              Re: Report properties question?

              On Sep 26, 1:05 pm, zufie <john.marru...@ illinois.govwro te:
              On Sep 26, 12:39 pm, fredg <fgutk...@examp le.invalidwrote :
              >
              >
              >
              >
              >
              On Fri, 26 Sep 2008 10:03:59 -0700 (PDT), zufie wrote:
              I have a report that return all the records (materials ordered) by all
              callers each day.
              >
              I want the report to just show all the records (materials ordered) by
              each individual caller each day
              on a separate page.
              >
              I tried Hide Duplicates property, Force New Page all to no success.
              >
              Here is the code to my qry/record source for my report:
              >
              SELECT Trim([Last Name]) & ", " & Trim([First Name]) & " " &
              Trim([Middle Initial]) AS Expr2, [qry DaysReport1].*, Caller.[Last
              Name], Caller.[First Name]
              FROM [qry DaysReport1] INNER JOIN Caller ON [qry DaysReport1].[Caller
              ID] = Caller.[Caller ID];
              >
              What must I change on Properties of my report?
              >
              Thanks,
              John
              >
              In Report Design View, click on View + Sorting and Grouping.
              In the Field/Expression column, write
              Expr2
              >
              In the lower panel set
              Group Header = Yes.
              >
              Back in report design view, click on the group header. Set the Group
              Header Force New Page property to BeforeSection. Place the Expr2
              control in the Group Header.
              --
              Fred
              Please respond only to this newsgroup.
              I do not reply to personal e-mail- Hide quoted text -
              >
              - Show quoted text -
              >
              Fred,
              You are a GENIUS!!!!!!!!! !!!!!!!!!!!!
              >
              You made my day!!!!!!!!!!!! !!!!!!!!
              >
              THANK YOU!!!!!!!!!
              >
              John- Hide quoted text -
              >
              - Show quoted text -
              One more question I am now trying to figure out how to keep a series
              of 4 questions form repeating under the Detail section of my report
              for each caller?

              That is, the report returns all the records (materials ordered) by
              each individual caller each day on a separate page very nicely, but my
              series of 4 questions repeats after each row of materials ordered by a
              single caller.

              So if a caller orders 2 materials (2 rows of data) then my report
              returns one row of materials ordered by that caller, followed by the 4
              questions, then another row of materials ordered by the caller,
              followed by a 2nd copy of the same 4 questions.

              I tried the same fix you showed me above but this time with the 4
              questions but was not successful.

              Thanks

              John

                Comment

                • zufie
                  #5
                  Re: Report properties question?

                  On Sep 26, 3:10 pm, zufie <john.marru...@ illinois.govwro te:
                  On Sep 26, 1:05 pm, zufie <john.marru...@ illinois.govwro te:
                  >
                  >
                  >
                  >
                  >
                  On Sep 26, 12:39 pm, fredg <fgutk...@examp le.invalidwrote :
                  >
                  On Fri, 26 Sep 2008 10:03:59 -0700 (PDT), zufie wrote:
                  I have a report that return all the records (materials ordered) by all
                  callers each day.
                  >
                  I want the report to just show all the records (materials ordered) by
                  each individual caller each day
                  on a separate page.
                  >
                  I tried Hide Duplicates property, Force New Page all to no success.
                  >
                  Here is the code to my qry/record source for my report:
                  >
                  SELECT Trim([Last Name]) & ", " & Trim([First Name]) & " " &
                  Trim([Middle Initial]) AS Expr2, [qry DaysReport1].*, Caller.[Last
                  Name], Caller.[First Name]
                  FROM [qry DaysReport1] INNER JOIN Caller ON [qry DaysReport1].[Caller
                  ID] = Caller.[Caller ID];
                  >
                  What must I change on Properties of my report?
                  >
                  Thanks,
                  John
                  >
                  In Report Design View, click on View + Sorting and Grouping.
                  In the Field/Expression column, write
                  Expr2
                  >
                  In the lower panel set
                  Group Header = Yes.
                  >
                  Back in report design view, click on the group header. Set the Group
                  Header Force New Page property to BeforeSection. Place the Expr2
                  control in the Group Header.
                  --
                  Fred
                  Please respond only to this newsgroup.
                  I do not reply to personal e-mail- Hide quoted text -
                  >
                  - Show quoted text -
                  >
                  Fred,
                  You are a GENIUS!!!!!!!!! !!!!!!!!!!!!
                  >
                  You made my day!!!!!!!!!!!! !!!!!!!!
                  >
                  THANK YOU!!!!!!!!!
                  >
                  John- Hide quoted text -
                  >
                  - Show quoted text -
                  >
                  One more question I am now trying to figure out how to keep a series
                  of 4 questions form repeating under the Detail section of my report
                  for each caller?
                  >
                  That is, the report returns all the records (materials ordered) by
                  each individual caller each day on a separate page very nicely, but my
                  series of 4 questions repeats after each row of materials ordered by a
                  single caller.
                  >
                  So if a caller orders 2 materials (2 rows of data) then my report
                  returns one row of materials ordered by that caller, followed by the 4
                  questions, then another  row of materials ordered by the caller,
                  followed by a 2nd copy of the same 4 questions.
                  >
                  I tried the same fix you showed me above but this time with the 4
                  questions but was not successful.
                  >
                  Thanks
                  >
                  John- Hide quoted text -
                  >
                  - Show quoted text -
                  Never mind, I got it!

                  I was on the right track and in this case needed to select Group
                  Footer = Yes

                  Thank you!

                  J

                    Comment

                    Previous template Next
                    Working...