hi! gud day! Here is my problem. Can you help me on how to make a monthly report?? im doing a Payment System of a school here in our place. as our Project. and can you help me on how to hide columns and rows of a datagrid also how to sort records on it?? im using a ADODB...
gms_019 0 Newbie Poster
kinwang2009 7 Posting Whiz in Training
Hi,
What type of Reports you are using? Crystal Report or just simple Datareport which is available in VB.
Thankx
vb5prgrmr 143 Posting Virtuoso
To hide rows and columns in a "bound" data grid, you use the select statement to restrict the number of columns and the where clause of that select statement to restrict the rows returned and finally use the option order by keywords to order the returned data. Otherwise, using your friends (yahoo, google, ask, answers, bing) and searching for vb6 data grid tutorial will find you all the answers you need.
Good Luck
AndreRet 526 Senior Poster
Have a look at the attachment. It covers access database, grid AND reports - Hope this helps.
This is not my own code. I have just changed some as I needed at the time.
gms_019 0 Newbie Poster
Only a simple Datareport in VB.
gms_019 0 Newbie Poster
Thank you... uhm, can you show me some codes? tnx.
gms_019 0 Newbie Poster
Thanks a lot... god bless..
abu taher 34 Practically a Posting Shark
Only a simple Datareport in VB.
do you know how to make data report? if yes then what kind of monthly report you want?
jireh 3 Posting Whiz
Did your problem resolved?
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.