| | |
Crystal REport 9.0
Please support our Visual Basic 4 / 5 / 6 advertiser: Programming Forums - DaniWeb Sister Site
![]() |
•
•
Join Date: Sep 2005
Posts: 2
Reputation:
Solved Threads: 0
I'm having this issue on how to sort reports based on part numbers i have part numbers that i return have either a part number as in 1000 or if there have been multiple part number could be 1001-2 mean that there were 2 revised copies of the part number.
What i want to return is either the part nubmer itself 1000 or the highest number of that part number say 1001-2 and filter out the 1001 or 1001-1
Example data:
part numbers - 1000,1001,1001-1,1001-2
What i want to return is the 1000 and the 1001-2 and filter out the 1001 and 1001-1
Any ideas?
What i want to return is either the part nubmer itself 1000 or the highest number of that part number say 1001-2 and filter out the 1001 or 1001-1
Example data:
part numbers - 1000,1001,1001-1,1001-2
What i want to return is the 1000 and the 1001-2 and filter out the 1001 and 1001-1
Any ideas?
Create a new colum for the revisions part numbers. I would also add a last modified date colum as well. Then the sql query will allow use to differentiate the two types of numbers.
Or you could append a -0 to all of the part numbers with no revisions.
Either way you go you need each colum to have the same type of information.
|PartNumber | PartRevision | RevisionDate
-----------------------------------------
|1000 |2 |09/19/2005
-----------------------------------------
|1001 |1 |08/14/2005
Or you could append a -0 to all of the part numbers with no revisions.
Either way you go you need each colum to have the same type of information.
|PartNumber | PartRevision | RevisionDate
-----------------------------------------
|1000 |2 |09/19/2005
-----------------------------------------
|1001 |1 |08/14/2005
.: We may acquire liberty, but it is never recovered if it is lost :.
irc://irc.rizon.net/#itf
irc://irc.rizon.net/#itf
![]() |
Similar Threads
- How add Crystal Report Version 11 in VB6 (Visual Basic 4 / 5 / 6)
- Crystal report in vb.net, printing problems (VB.NET)
- Problem with Crystal Report in ASP.NET (ASP.NET)
- How can I call Crystal Report from VB 6.0 ? (Visual Basic 4 / 5 / 6)
- Help me with Crystal Report (ASP.NET)
- Error while declaring Crystal Report Object (ASP.NET)
- Problems on making Crystal Report (VB.NET)
Other Threads in the Visual Basic 4 / 5 / 6 Forum
- Previous Thread: Text Width
- Next Thread: Text Box Newbie help
| Thread Tools | Search this Thread |
* 6 429 2007 access activex add age append application basic beginner birth bmp calculator cd cells.find click client code college column component connection connectionproblemusingvb6usingoledb copy creat ctrl+f data database datareport date delete dissertations dissertationthesis dissertationtopic edit error excel excelmacro file filename form hardware header iamthwee image inboxinvb internetfiledownload keypress label listbox listview liveperson login looping machine microsoft movingranges number objectinsert open oracle password prime program prompt range-objects readfile reading record refresh remotesqlserverdatabase report retrieve save search sendbyte sites sort sql sql2008 sqlserver subroutine table tags textbox time urldownloadtofile vb vb6 vb6.0 vba visual visualbasic visualbasic6 web window windows





