Conditional Formatting

I have a report that has 5 subreports attached to it. The main report and one
of the subreports comes from the same query. In the main report i have the
store name and % change in the Header. I would like the subreport that comes
from the same query and has the store name is also on the report. When the
main report says store Laurel, I want the subreport to also have Laurel in
black with all of the others store names hidden. I hope this makes sense if
not please let me know and I will try to explain better. Can anyone help?
--
Lisa S.

Lisa wrote:

I have a report that has 5 subreports attached to it. The main report and one
of the subreports comes from the same query. In the main report i have the
store name and % change in the Header. I would like the subreport that comes
from the same query and has the store name is also on the report. When the
main report says store Laurel, I want the subreport to also have Laurel in
black with all of the others store names hidden.


I think you might barking up the wrong tree ;-)

If I'm right, you should be using the subreport control's
Link Master/Child Fields properties (set to the customer
field) to syncronizethe subreport's records to the main
report detail record.

--
Marsh
MVP [MS Access]

Using child and master links was my first choice, however as I said before
both reports are created off the same query so that is not possible that is
why I wanted to use conditional formatting. Can you help?
--
Lisa S.


"Marshall Barton" wrote:

Lisa wrote:

I have a report that has 5 subreports attached to it. The main report and one
of the subreports comes from the same query. In the main report i have the
store name and % change in the Header. I would like the subreport that comes
from the same query and has the store name is also on the report. When the
main report says store Laurel, I want the subreport to also have Laurel in
black with all of the others store names hidden.


I think you might barking up the wrong tree ;-)

If I'm right, you should be using the subreport control's
Link Master/Child Fields properties (set to the customer
field) to syncronizethe subreport's records to the main
report detail record.

--
Marsh
MVP [MS Access]

Lisa wrote:

Using child and master links was my first choice, however as I said before
both reports are created off the same query so that is not possible that is
why I wanted to use conditional formatting. Can you help?


I guess I don't understand what you are trying to
accomplish. Could you explain why using the same table for
the main and sub reports make it impossible?

OTOH, maybe a subreport is not the right approach? More
information about how you are organizing the data in the
report might help me understand your problem.

--
Marsh
MVP [MS Access]

I would like my report to have the store name in the page report header, in
order to do that I had to create a new report, so I used the same query
because it had all of the store names I wanted in it. I want a new report to
beging with every new store name. In the detailed section is where all the
data is I have a store name, % Change for 3 months and a total for the
quarter as well as there total complaints. I want everything to show in the
body except the store names. The only store name I want to show in the body
of the report is the store name listed up at the top.
This is an example of What I want it to look like.


Report Card
Store Name: Sterling, VA Ledo Pizza 112.33%

StoreName Jan-08 Feb-08 Mar-08 %Change TotalComplaints
Sterling, VA Ledo Pizza 112.33% 112.33%
39.00% 53.14% 40.95% 43.90% 1
20.93% 23.05% 22.00% 1
19.49% 30.64% 14.50% 21.16%
19.24% 24.49% 8.09% 16.80%
15.75% 21.51% 13.84% 16.76% 1
11.45% 34.14% 5.69% 15.70%
14.80% 17.88% 9.15% 13.77%
22.73% 29.79% -7.12% 13.67% 2
13.62% 22.53% 5.49% 13.31%
12.21% 13.88% 13.01%
4.69% 47.76% -4.16% 12.18%
11.04% 14.19% 10.80% 11.85%
13.68% 16.72% 5.90% 11.81% 4
3.39% 22.62% 10.41% 11.80% 3
3.78% 16.67% 9.84% 3
11.15% 19.29% 0.47% 9.67%
10.20% 15.85% 3.34% 9.39% 1

--
Lisa S.


"Marshall Barton" wrote:

Lisa wrote:

Using child and master links was my first choice, however as I said before
both reports are created off the same query so that is not possible that is
why I wanted to use conditional formatting. Can you help?


I guess I don't understand what you are trying to
accomplish. Could you explain why using the same table for
the main and sub reports make it impossible?

OTOH, maybe a subreport is not the right approach? More
information about how you are organizing the data in the
report might help me understand your problem.

--
Marsh
MVP [MS Access]

Ok Maybe this will help you understand why I can not use master/child links
Here is the query I am using, the fields are not locked they can change
everytime it is opened. here is the SQL

SELECT qryReportCard_Crosstab.StoreName AS Field0,
qryReportCard_Crosstab.TotalComplaints AS Field1,
qryReportCard_Crosstab.SalesPrevious AS Field2,
qryReportCard_Crosstab.SalesCurrent AS Field3,
qryReportCard_Crosstab.[%Change] AS Field4, qryReportCard_Crosstab.[1/1/2008]
AS Field5, qryReportCard_Crosstab.[2/1/2008] AS Field6,
qryReportCard_Crosstab.[3/1/2008] AS Field7, Null AS Field8, Null AS Field9,
Null AS Field10, Null AS Field11, Null AS Field12, Null AS Field13, Null AS
Field14
FROM qryReportCard_Crosstab;

--
Lisa S.


"Marshall Barton" wrote:

Lisa wrote:

Using child and master links was my first choice, however as I said before
both reports are created off the same query so that is not possible that is
why I wanted to use conditional formatting. Can you help?


I guess I don't understand what you are trying to
accomplish. Could you explain why using the same table for
the main and sub reports make it impossible?

OTOH, maybe a subreport is not the right approach? More
information about how you are organizing the data in the
report might help me understand your problem.

--
Marsh
MVP [MS Access]

Lisa wrote:

I would like my report to have the store name in the page report header, in
order to do that I had to create a new report, so I used the same query
because it had all of the store names I wanted in it. I want a new report to
beging with every new store name. In the detailed section is where all the
data is I have a store name, % Change for 3 months and a total for the
quarter as well as there total complaints. I want everything to show in the
body except the store names. The only store name I want to show in the body
of the report is the store name listed up at the top.
This is an example of What I want it to look like.


Report Card
Store Name: Sterling, VA Ledo Pizza 112.33%

StoreName Jan-08 Feb-08 Mar-08 %Change TotalComplaints
Sterling, VA Ledo Pizza 112.33% 112.33%
39.00% 53.14% 40.95% 43.90% 1
20.93% 23.05% 22.00% 1
19.49% 30.64% 14.50% 21.16%


Since you are only using a single set of data, there is no
need for that kind of subreport.

I think I would approach this by putting the stuff:
StoreName Jan-08 Feb-08 Mar-08 %Change TotalComplaints
in the Page Header section?

Now, use the report's Sorting and Grouping window (View
menu) to create a group with header on the store name field.

Add the:
Store Name: Sterling, VA Ledo Pizza 112.33%
stuff to the group header section. I think you probably
want to set the group header section's RepeatSection
property to Yes and the ForceNewPage property to Before
Section.

--
Marsh
MVP [MS Access]

I did what you suggested and the details only show the store information
that in the group header, I want all stores information with the store name
whited out.
--
Lisa S.


"Marshall Barton" wrote:

Lisa wrote:

I would like my report to have the store name in the page report header, in
order to do that I had to create a new report, so I used the same query
because it had all of the store names I wanted in it. I want a new report to
beging with every new store name. In the detailed section is where all the
data is I have a store name, % Change for 3 months and a total for the
quarter as well as there total complaints. I want everything to show in the
body except the store names. The only store name I want to show in the body
of the report is the store name listed up at the top.
This is an example of What I want it to look like.


Report Card
Store Name: Sterling, VA Ledo Pizza 112.33%

StoreName Jan-08 Feb-08 Mar-08 %Change TotalComplaints
Sterling, VA Ledo Pizza 112.33% 112.33%
39.00% 53.14% 40.95% 43.90% 1
20.93% 23.05% 22.00% 1
19.49% 30.64% 14.50% 21.16%


Since you are only using a single set of data, there is no
need for that kind of subreport.

I think I would approach this by putting the stuff:
StoreName Jan-08 Feb-08 Mar-08 %Change TotalComplaints
in the Page Header section?

Now, use the report's Sorting and Grouping window (View
menu) to create a group with header on the store name field.

Add the:
Store Name: Sterling, VA Ledo Pizza 112.33%
stuff to the group header section. I think you probably
want to set the group header section's RepeatSection
property to Yes and the ForceNewPage property to Before
Section.

--
Marsh
MVP [MS Access]

Lisa wrote:

I did what you suggested and the details only show the store information
that in the group header, I want all stores information with the store name
whited out.


Remove the controls from the detail section that duplicate
the group header section information. Then add the other
fields (Field5, Field6, etc) to the detail section.

If that doesn't display the needed fields, double check the
query (by itself) to make sure the data is reallly there.

--
Marsh
MVP [MS Access]

Marshall,
I need those fields in the detail section as well as in the header. I would
like For Example
Laurel 89%
Jan Feb Mar Q1-07
5% 15% 7% 8%
Laurel 2% 10% 5% 89%

So putting Field0 and Field4 i the header takes them out of the detail and
they need to be there to.
--
Lisa S.


"Marshall Barton" wrote:

Lisa wrote:

I did what you suggested and the details only show the store information
that in the group header, I want all stores information with the store name
whited out.


Remove the controls from the detail section that duplicate
the group header section information. Then add the other
fields (Field5, Field6, etc) to the detail section.

If that doesn't display the needed fields, double check the
query (by itself) to make sure the data is reallly there.

--
Marsh
MVP [MS Access]