Thanks Lonnie, but we won't be buying Provision anytime soon. Empty pockets.
Your situation is much more complicated than mine. Our Certs consist of
Basic information about the part (All exist on the Packing Slip) along with
some additional verbiage. All I really need is a subreport in Crystal. I
haven't done this yet, but it seems pretty straight forward. The big problem
is finding some way to trigger this subreport (while printing the Packing
Slip), that is based off of a field in the Customer Master. We've given our
shipper all kinds of red flags, as to when a cert is needed, but she still
manages to miss some. The best solution is to have it print automatically
with the Packing Slip. Does anybody know if it is possible to set a VB form
in the Customer Master, and pull the information into another VB Form in
either the ShipHead or ShipDtl tables? If I could do this, I would be all
set. I guess I should not have slept through that VB class.... Les
Your situation is much more complicated than mine. Our Certs consist of
Basic information about the part (All exist on the Packing Slip) along with
some additional verbiage. All I really need is a subreport in Crystal. I
haven't done this yet, but it seems pretty straight forward. The big problem
is finding some way to trigger this subreport (while printing the Packing
Slip), that is based off of a field in the Customer Master. We've given our
shipper all kinds of red flags, as to when a cert is needed, but she still
manages to miss some. The best solution is to have it print automatically
with the Packing Slip. Does anybody know if it is possible to set a VB form
in the Customer Master, and pull the information into another VB Form in
either the ShipHead or ShipDtl tables? If I could do this, I would be all
set. I guess I should not have slept through that VB class.... Les
> -----Original Message-----
> From: lonniedrew [SMTP:lonniedrew@...]
> Sent: Thursday, January 17, 2002 6:57 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Certs (was: Progress/dbf)
>
> Les, since this is fresh on my mind I decided to elaborate on our
> solution.
>
> Steve, thanks for the offer. Please forward as soon as possible.
>
> I hope a further discussion will be beneficial to both of yours.
>
> As for my program, I'm proud of it as a Progress-only, push button
> solution, with a "verbose" and detailed print out. I can't believe
> Crystal could have worked any better.
>
> I'm sorry I can't upload the source code. All the techniques used in
> this program exist in the source code section of Yahoo Files, at
> least in examples I've previously uploaded.
>
> I was able to upload screen shots of the program, without using MORE
> Yahoo space, by deleting a few of the items in a zipped file I
> earlier uploaded under misc called "SnapShots.zip - Program snapshots
> illustrating what can be done in Provision development environment".
> If anyone would like to download and follow along they are....
>
> Certify.bmp - Main cert and analysis entry screen
> ViewCert.bmp - View only cert browze screen for reference. Can be
> sorted by certnum, entry date, customer or mold number.
> Cert.bmp - Sample cert.
>
> There's also a Coded Stamp selection dialog which is a data entry
> time saver, user can copy previously entered data and analyses.
>
> A PROGRESS-ONLY SOLUTION
>
> I've found that ProVision and Report Builder working together can
> produce fine results. I would probably have never attempted this
> without AppBuilder. There are over 70 widgets on the interface.
> Dragging and dropping these at will, and having the code
> automatically generated, probably cut development time by days. Data
> is stored in a separate Progress database, running alongside
> Vantage. There are over 80 calculated fields in the cert
> report/form, and over 60 aggregates.
>
> PROGRAM FLOW FROM USER PERSPECTIVE
>
> The user enters the order number, and a trigger displays and records
> the customer PO and shipping information. With the order line
> entered, our part number and the customer part number is displayed.
>
> If analyses of the current heat were entered for a previous cert, the
> user can double-click on the Coded Stamp field, select one, and is
> given an option to copy the analyses to the current cert. Comments
> can be recorded and printed on cert.
>
> The program will allow as many analyses as needed, but currently only
> the first 3 will print. If necessary, per customer request,
> unlimited number can be added.
>
> Batch printing is also supported. As each cert is created, it is
> marked to print. Pushing "Print" gives user choice of current cert
> or all entered that have not yet printed. Once printed it is marked
> NOT to print again, but can be reset is user enters the cert,
> retrieves data, and presses "Save".
>
> FUTURE ENHANCEMENTS
>
> There's still too much paper and manual labor for my taste. I hope
> to have pour department enter the actual analyses in a separate GUI.
> I also hope to store ASTM and customer specs in an addressable format
> for automatic comparison and alerts. There are already interfaces
> nearly completed for these.
>
> IN CONCLUSION
>
> If you don't have ProVision, I hope this project and the example I've
> discussed will convince you to purchase the license. I'll continue
> to post code and will be glad to share any advice to help the
> learning curve. We ourselves are our best source for programming
> info.
>
> Lonnie Drew
>
>
>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
> have already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder and
> Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/links
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>