Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Possible Choices on View Selection on Print?
Message
From
08/04/1998 22:55:55
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Title:
Possible Choices on View Selection on Print?
Miscellaneous
Thread ID:
00090663
Message ID:
00090663
Views:
61
I want to change the current view on printing report.

Current Views are like:
*(A)
Select .... from .... on .... ;
Where Order_id = ?Thisform.Select_Order_id

OR 
*(B)
Select .... from .... on .... ;
Where Alltrim(Thisform.Select_Order_id) $ Order_id = .T.
Method (A) is standard to print one Order as required.
Method (B) is to group the similar Key into one report due to:

Same clients but set more than one orders in different day but
all pack in the same Carton. Thus, Group for Packing List and
Invoice is essential!
Method (B) will group:
[P1602 ] Dummy Set to group all
[P1602A]
[P1602B]
[P1602C]
So, put [P1602 ] will print all group with [P1602 ].

But now, boss request that it should be grouping different Order_id
into one Invoice and Packing_List report!

i.e. group [P1607 ], [P1611 ], [P1614 ]... into one report with using
the same client info.

So, I suggest to use a [SelPrint] Table to carry all the key on print
and change the original view into match to [SelPrint] Table....
But.... it will hold the table locked and not allow others to change
and edit the table for other printjob!
Method (C):
[SelPrint] Table contains 1 field Order_id with
[P1607 ], [P1611 ], [P1614 ]...
and thus print what has selected.

The problem is the new Method (C) will hold the table and pack it.
but multi-user cause problem on waiting to use this table!!
Are there any alternate solution to group records into one report?!
The weak wait for chance, The strong bid for chance,
The clever notch up chance, but The merciful give you chance.
Reply
Map
View

Click here to load this message in the networking platform