Correctly Placing Controls in Report

[Andy]

Hi;

Based a rpt on a qry. The qry contains two fields. [Catagory] and [Price].

There are 38 Catagories.

What I am unable to do as yet; is to correctly place the controls on the
report.

Created txtControls in Report (as an example):
lblShirts: =iif([Catagory]="Shirts",[Price],"")
lblShoes: =iif([Catagory]="Shoes",[Price],"")
lblTies: =iif([Catagory]="Ties",[Price],"")

The results are displayed:

lblShirts: 25.00

lblShoes: 50.00



lblTies: 15.00

Need it to display the results in exact locations, (anywhere the result is
needed):
lblShirts: 25.00 lblShoes: 50.00 lblTies: 15.00

What seems to be happening is the control is generating blanks although Hide
Dupicates=Yes

Have considered subrpts, but that would be combursome. 38 subreports are
too many.

Somebody must have the answer to this as it seems a common obstacle.

Andy

 

[Fons Ponsioen]

I think you need to set the can shrink to yes for the
report band. May need more detail if this does not help.
Fons

 

[Andy]

Fons;

Did forget to mention that "CanShrink=Yes" is already set.

Perhaps if it's phrased this way:

How do you display the control's result in an "Absolute" position on the
report.

This must be here. This one must be here.
and this third one here.

Have the result of an IIF expression displaying in the required places on
the report.

Andy

I think you need to set the can shrink to yes for the
report band. May need more detail if this does not help.
Fons

-----Original Message-----
Hi;

Based a rpt on a qry. The qry contains two fields. [Catagory] and [Price].

There are 38 Catagories.

What I am unable to do as yet; is to correctly place the controls on the
report.

Created txtControls in Report (as an example):
lblShirts: =iif([Catagory]="Shirts",[Price],"")
lblShoes: =iif([Catagory]="Shoes",[Price],"")
lblTies: =iif([Catagory]="Ties",[Price],"")

The results are displayed:

lblShirts: 25.00

lblShoes: 50.00



lblTies: 15.00

Need it to display the results in exact locations, (anywhere the result is
needed):
lblShirts: 25.00 lblShoes: 50.00 lblTies: 15.00

What seems to be happening is the control is generating blanks although Hide
Dupicates=Yes

Have considered subrpts, but that would be combursome. 38 subreports are
too many.

Somebody must have the answer to this as it seems a common obstacle.

Andy


.

 

[Nelson]

Set the Move Layout property for the detail section to false then place the
controls where you want them with code referencing the top and left
properties.

 

[Andy]

Nelson;

THANK YOU AGAIN FOR YOUR ANSWER.

After trying "MoveLayout", and reading Microsoft's 208979 How to Print a
Group Footer at a Specific Location, ended up going a different route. With
38 individual SubCatagories quickly learned that there were more pitfalls
then solutions.

Gave an educated guess.

For my purposes:
Shirts::
Max(IIf([qryProdBoughtTbl.ProdBuySubCatagoryName]="Shirts",[qryProdBoughtTbl
..ProdBuyExtndPrice]))
in the query worked perfectly.

Thank you ALL for your help.

Andy

Set the Move Layout property for the detail section to false then place the
controls where you want them with code referencing the top and left
properties.

Hi;

Based a rpt on a qry. The qry contains two fields. [Catagory] and [Price].

There are 38 Catagories.

What I am unable to do as yet; is to correctly place the controls on the
report.

Created txtControls in Report (as an example):
lblShirts: =iif([Catagory]="Shirts",[Price],"")
lblShoes: =iif([Catagory]="Shoes",[Price],"")
lblTies: =iif([Catagory]="Ties",[Price],"")

The results are displayed:

lblShirts: 25.00

lblShoes: 50.00



lblTies: 15.00

Need it to display the results in exact locations, (anywhere the result is
needed):
lblShirts: 25.00 lblShoes: 50.00 lblTies: 15.00

What seems to be happening is the control is generating blanks although Hide
Dupicates=Yes

Have considered subrpts, but that would be combursome. 38 subreports are
too many.

Somebody must have the answer to this as it seems a common obstacle.

Andy