CR with VB....SQL bringing no data to report.

[Mavors]

Hello fellow programmers,

I am working on a project with rather complicated SQLs. I have been creating them in access and utilizing them in a DataEnvironment in VB to be used with my crystal reports. My problem is that I have a couple SQLs that while work fine in Access have problems in VB when using crystal reports. I already have over 30 reports made this way working great and believe that maybe something within the SQL is creating problems with the crystal report.

Please post a reply if you might have some ideas on what may be causing this.

Thanx,

Mavors

 

[MalcolmW]

You will probably have to be more specific to get a useful response.