Display first 10 lines of a report in a frame of one of my vb6 forms

[dchicora]

Is there a way I can display the 1st 10 lines of a report in a frame on one of my forms in vb6?

I am using the data report designer in vb6. The report is working how I want, but I want to be able to display the 1st 10 lines of it in a frame. Reason being....is to show the Top Ten Standings on my form.

Actually, it doesn't even have to be in a frame. It could just be on the form somewhere.

Any help would be greatly appreciated. Thanks!

[VBFnewcomer]

why trouble yourself with a report...

but I want to be able to display the 1st 10 lines

simply send a query to fetch top 10 records (using sorting or other techniques) and display it in a grid. In the same form you can have a button titled "Print Full List", which will open the report... I am assuming you are using CR.
Hope this is useful...

[VBFnewcomer]

My humble request is Pls always state the 4/5 minimum following things when U post
1. The OS you are working on,
2. The Version of VB you use,
3. The Database being used,
4. The Reporting Tool Used
5. If error is in a code preferably the whole sub/function.
Not to forget a short clear subject.
This I believe would enable members to easily assess your problem and respond at the earliest.
Infact to avoid repetitivelystating the above 4 one can always add them in their signatures...Sorry if I had hurt anybody

[dchicora]

I'm using Xp. I already stated in my initial post that I am using vb6 and I also stated that I am using the Data Report Designer for the report which is a vb6 report, not Access or CR. I'm using Access as my database.

[dchicora]

Sorry, I'm new at this and don't know what you mean by displaying it in a grid.

[dchicora]

Ok, I see where I can Add grids from Components in vb6. Should I use a data grid or a flex grid? I'll just have to figure out what to do once I find out which one I should use.

[VBFnewcomer]

Dont feel sorry. Feel free to express urself. I am as new as u are but frequent reading of the posts of others enlightens me.
I was telling u about the MSFlexgrid. You will find it in Projects->Components-> Microsoft FlexGrid control (SP6).

which is a vb6 report

I havent seen/used it..let me see...

[VBFnewcomer]

can you tell me where the report Designer in VB6 is situated..i.e Under which menu

[VBFnewcomer]

I got it. It is a report designer thru which u design a report and print it. There may be three steps involved.
1.first design a form to make a selection,
2. then load another form which has the MSFlexgrid to display the top 10 records [Make a search in Classic VB6 Forum as to how to connect to DB and retrive records keyword: ADO tutuorial] then follow the steps described in #2