 |  |  |  |  |  |  |  |
about data report
 |
•
•
Join Date: Sep 2006
Posts: 65
Reputation: 
Solved Threads: 4
Junior Poster in Training
hello to every one! have a nice day! pls help me how to arrange data alphabetically in the data report which came from the data environment designer.. i want to keep records in ascending form such as last name. i am creating a students record and i want that their names be arranged in alphabetical order. is there way to do that! thanks all for you response!
•
•
Join Date: Sep 2006
Posts: 54
Reputation:
Solved Threads: 1
Junior Poster in Training
•
•
•
•
Originally Posted by arvin2006 
hello to every one! have a nice day! pls help me how to arrange data alphabetically in the data report which came from the data environment designer.. i want to keep records in ascending form such as last name. i am creating a students record and i want that their names be arranged in alphabetical order. is there way to do that! thanks all for you response!
Dim conn As ADODB.Connection
Dim rptCn As Connection
Dim rptRs As Recordset
Public Sub RptConnect()
Set rptCn = New Connection
rptCn.CursorLocation = adUseClient
rptCn.Open conn
End Sub
Private Sub cmdPrint_Click()
Call RptConnect
Set rptRs = New Recordset
rptRs.Open ("Select * From tbluserlog Oder By LastName"), conn
Set rptUserlogAll.DataSource = rptRs
rptUserlogAll.Show 1
End sub
if there anything wrong just tell me..
•
•
Join Date: Sep 2006
Posts: 65
Reputation:
Solved Threads: 4
Junior Poster in Training
Gud day! thank you v ery much.. i really appreciate your response. God bless!
Last edited by arvin2006; Oct 16th, 2006 at 5:17 am.
•
•
Join Date: Sep 2006
Posts: 65
Reputation:
Solved Threads: 4
Junior Poster in Training
gud day! thank you very much..
•
•
Join Date: Sep 2006
Posts: 65
Reputation:
Solved Threads: 4
Junior Poster in Training
thanks for the response. but it did not work, or i think i have done incorrect process.. the idea is this, i have added data environment and data report, then i drag the fields from data environment to the data report named PRINTGS. what should i do to make fields in data report be ascended? after pressing the command button named PRINT, data report togther with the fields should be in alphabetical form which came from the data environemnt. the database name is RECORDS.MDB and table name is GRADINGSHEET, while the data report is PRINTGS. what should be the right process.
•
•
Join Date: Sep 2006
Posts: 65
Reputation:
Solved Threads: 4
Junior Poster in Training
how could i manipulate the fields in the data report? if i dragged the fields from the data environment, all the contents will be displayed. i want that only the data from the query (SEARCH) will be displayed. how could i do the process. thanks!
•
•
•
•
Originally Posted by arvin2006
hello to every one! have a nice day! pls help me how to arrange data alphabetically in the data report which came from the data environment designer.. i want to keep records in ascending form such as last name. i am creating a students record and i want that their names be arranged in alphabetical order. is there way to do that! thanks all for you response!
Visual Basic 4 / 5 / 6 Syntax (Toggle Plain Text)
try using that code publisher is the table name and state is the field
•
•
Join Date: Nov 2006
Posts: 848
Reputation:
Solved Threads: 120
Practically a Posting Shark
Hi Arvin,
Whatever CommanD Object u have used to design the Report, Change it to:
"Select * From MyTable Order By FirstName"
ORDER BY WHATEVER FIELD NAME U WANT
Regards
Veena
Whatever CommanD Object u have used to design the Report, Change it to:
"Select * From MyTable Order By FirstName"
ORDER BY WHATEVER FIELD NAME U WANT
Regards
Veena
Last edited by QVeen72; Aug 7th, 2007 at 5:31 am.
|
Similar Threads
- Data Report in vb 6.0 (Visual Basic 4 / 5 / 6)
- help me pls~~ data report data section does not match data source (Visual Basic 4 / 5 / 6)
- Printing Data Report Directly in vb.net (VB.NET)
- Data report... (Visual Basic 4 / 5 / 6)
Other Threads in the Visual Basic 4 / 5 / 6 Forum
- Previous Thread: MSHFlex Grid Control
- Next Thread: recordset::sort property
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Related Forum Features
Latest Visual Basic 4 / 5 / 6 Posts
- Today's Posts
- Unanswered Threads
* 6 2007 access activex add age basic beginner birth bmp calculator cd cells.find click client code college connection connectionproblemusingvb6usingoledb creat ctrl+f data database datareport date delete dissertations dissertationthesis dissertationtopic edit excel excelmacro file filename form header iamthwee image inboxinvb internetfiledownload listbox listview liveperson login looping microsoft movingranges number objectinsert open oracle password prime program prompt range-objects readfile reading remotesqlserverdatabase report save search sendbyte sites sql sql2008 sqlserver subroutine tags time urldownloadtofile vb vb6 vb6.0 vba visual visualbasic visualbasic6 web windows