By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,392 Members | 1,556 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,392 IT Pros & Developers. It's quick & easy.

Report properties question?

P: n/a
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
Sep 26 '08 #1
Share this Question
Share on Google+
4 Replies


P: n/a
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
Sep 26 '08 #2

P: n/a
On Sep 26, 12:39*pm, fredg <fgutk...@example.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
Sep 26 '08 #3

P: n/a
On Sep 26, 1:05*pm, zufie <john.marru...@illinois.govwrote:
On Sep 26, 12:39*pm, fredg <fgutk...@example.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
Sep 26 '08 #4

P: n/a
On Sep 26, 3:10*pm, zufie <john.marru...@illinois.govwrote:
On Sep 26, 1:05*pm, zufie <john.marru...@illinois.govwrote:


On Sep 26, 12:39*pm, fredg <fgutk...@example.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
Sep 26 '08 #5

This discussion thread is closed

Replies have been disabled for this discussion.