New to VB Reporting - Need Help Pls

[jaycast]

I'm trying to cross the bridge from Access reporting to VB Reporting because Access doesn't seem able to handle the large complicated reports I need to run. I've thus been tinkering with the functionality of VB reports, but haven't been able to figure out how to do a few things. Here's my current scenario:

***I am creating a report based on a parent and child command hierarchy, deriving from SQL Views***

1) How can I sort by specific fields and groups?

2) If I wanted to have a Min(date)/Max(Date) function in my Report/Page Header, how would I go about facilitating that?

This is just the start to a whirlwind of questions I'll probably be posting about. Please have patience. I'm pretty much self-taught, and VB is a much different animal than Access, IMO.

Thanks

 

[Scoty]

jaycast,
This may not be what you are looking for...here is my take on vbreports.<Also Self Taught> ;-)

Unfortunately VB Reports are not as dynamic access. But there are way of making it work.
I will assume you have an advanced knowledge of access report as you are now willing to do vb ones.

1)Where you able to built a VisData manager test report? You can pull tables with it and make an nonparametered report.

2) Once you do that you can than build queries (in access) and use the queries as members(Commands)of the VisData manager.(it may seem complicated but once you build your first parametered report ..off the query.. the rest will fall into place.

<><><><><><><><><><><><><OR><><><><><><><><><><>><><><><><>

You could use crystal reports. Which comes with some versions of vb (pro, home, enterprise...ect) From what I understand it is a LOT more dynamic thus (word of the day calendar ) you get better reports.

If you decide to go that route I know more people will be willing/able to help you. (as for me I nothing about crystal reports, I had to build 4 reports one time and hope that I never have to do it again

Scoty :



&quot;Learn from others' mistakes. You could not live long enough to make them all yourself.&quot;
-- Hyman George Rickover (1900-86),

 

[northrd]

Yep
I'd have to agree with Scoty. After (literally) 5 years of strugling with vb6 reports generator I finally accepted the opinions of this group and purchased Crystal Reports 9. It was an upgrade from the v4.6 that comes with vb6 pro. Oh My Gosh! It actually replaces the report generator WITHIN THE VB ENVIRONMENT. I have't looked back.

But, if you want to continue using the VB reports generator then do the search on this forumn and you will find a wealth of information. Try words like Data Report, Report, Reports, Report Hell etc.

Cheers
Ciaran

 

[jonybd]

like this :
'===========My vbDataReport================='
unload DataEnvironment
Load DataEnvironment
rptStudentsProfile.startView variable_
load rptStudentsProfile
rptStudentsProfile.show
'==========================================='

Note: rptStudentsProfile.startView variable_

Where startView is defined as following

Select *From StudnetProfile where Id= variable_ or
Gender = variable_ or dateofBirth = variable_ or
Name = variable_ or blahblha = variable_


Note: pictures cant be loaded to datareport. there are lots of limitation , but as we are useing it as DATAREPoRT so its ok.