Correctly Placing Controls in Report

A

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
 
F

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
 
N

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.
 
A

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
Nelson said:
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 said:
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
Click to expand...
Click to expand...
 
Top