Report properties question?

[zufie]

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

[fredg]

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

[zufie]

On Sep 26, 12:39*pm, fredg <[e-mail]:

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

[zufie]

On Sep 26, 1:05*pm, zufie <[e-mail]:

On Sep 26, 12:39*pm, fredg <[e-mail]:

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

[zufie]

On Sep 26, 3:10*pm, zufie <[e-mail]:

On Sep 26, 1:05*pm, zufie <[e-mail]:

On Sep 26, 12:39*pm, fredg <[e-mail]:

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