>Well, yes I am allowing user to select group of data to be selected.
>Thanks
As Wayne and Curtis say, use cursors or views to carry the print information!!
In normal way, there should be some additional fields in base tables!
e.g. Orders.IsSample .NeedDropTest ....
Then, the user can select the preference on that Orders....
The order is small amount with Drop Test needed.. etc.
Back to print report problem, thx many ppl here and give an advice on follow:
Problem:
if different optional line are printed, there will be a miss line on layout!
XXXXXXXX
YYYYYYYY
CCCCCCCC
VVVVVVVV
which is poor layout!
Finally, I create some report variable carry those label fix text!
e.g. T1, T2, F3, T4...
Then, add a large field to handle all:
IIF(Orders.IsSample, T1+chr(13), "") + IIF(Orders.NeedDropTest, T2+chr(13), "") + ....
Then, the layout will be fit:
XXXXXXXX
YYYYYYYY
CCCCCCCC
VVVVVVVV
^-^; I hope this can help you la! Good Luck!
The weak wait for chance, The strong bid for chance,
The clever notch up chance, but The merciful give you chance.