Show Bid Request
vbRdcCrw Labels
Bid Request Id: 22292
|
|
|
|
Posted by: |
davemeng (1 ratings)
(Software buyer rating 10 )
|
|
Non-action Ratio: |
Very Good - 0.00%
|
Buyer Security Verifications: |
Good
|
|
Approved on: |
Jul 20, 2002
1:37:12 PM EDT
|
|
Bidding Closes: |
Jul 24, 2002
2:01:14 PM EDT
|
|
Viewed (by coders): |
201 times
|
|
Deadline: |
8/1/2002
TIME EXPIRED
|
|
|
|
|
Description:
i'm using VB6, with the Crystal 8.5 RDC, off a btreive db, the goal is to have the Crystal viewer print shipping labels based on one label per part per quantity being shipped.
i.e. the db has the Sales order #, part #, description, Y/N flag to ship, PartQty to ship, etc.
if this user specifies a specific Sales order #, then it will bring in all lines (parts that are flagged to be released) SO# 1800, P-100, Tin cans, flag = Y, Pqty = 5, (2nd line) SO# 1800, P-7744, String, flag = Y, Pqty = 3.
this example i will want to print 8 ship label, based on the two records. 5 of the 1st part, and 3 of the 2nd part.
this will always be a dynamic value. for the end user is only going to enter in the SO #, and nothing else. we will rely solely on the data in the database to populate either a recordset of other means, that creates one label per part per part quantity.
i don't have a problem opening the db, either directly or using a SQL statement to get the record selection. My problem lies in the ability to LOOP the individual record based on the Pqty to ship. i've tried to do this even with an ADO Recordset.
the number of records that pulls in will always be based on a given Sales Order and how many lines are being released. i have no problem getting these records.
i specifically want to use the RDC such that the code and rpt remain embedded in the app. i have the flexibility to format the crViewer as well.
i figure there must be an easy way for this to occur. am willing to discuss what options i've tried.
i know it needs a looping routine, but i can't seem to place it in the right spot or build correctly.
Deliverables:
Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
Complete copyrights to all work purchased.
Platform:
win95/98/2000/xp. as standalone.
Must be 100% finished and received by buyer on:
Aug 1, 2002 EDT
Deadline legal notes: All times are expressed in the time zone of the site EDT (UT - 5). If the buyer omitted a time, then the deadline is 11:59:59 PM EDT on the indicated date.
Special Conditions / Other:
i only want bids from coders that use and are familiar with vb6.0 and crystal reports 8.5 developer edition, using the RDC in a VB application
Remember that contacting the other party outside of the site (by email, phone, etc.) on all business projects < $500 (before the buyer's money is escrowed) is a violation of both the software buyer and seller agreements.
We monitor all site activity for such violations and can instantly expel transgressers on the spot, so we thank you in advance for your cooperation.
If you notice a violation please help out the site and report it. Thanks for your help.
|
|
|
Bidding/Comments:
|
All monetary amounts on the site are in United States dollars.
Rent a Coder is a closed auction, so coders can only see their own bids and comments. Buyers can view every posting made on their bid requests. |
See all rejected bids (and all comments)
| Name |
Bid Amount
|
Date |
Coder Rating |
|
|
|
This bid was accepted by the buyer!
|
$50 (USD)
|
Jul 21, 2002
7:04:51 AM EDT
|
9.96
(Excellent)
|
|
|
Dave,
Here's a working example of what you've described, for my example I've used an Access97 MDB as the Data Source, but the code can be applied to any DataSource type.
My bid is for the code to this example, which is complete and fully commented.
Regards,
- Aaron. |
|
|
Attached File
|
|
|
|
|
|