Grouping in Crystal reports via VB

[eamonskelly]

I am having problems creating a report in VB using an SQL query, which is created in VB from data in SQL server. Can anyone show me some code that might help? My problems are in particular with grouping. I am using Crystal Reports version 8 and VB6
Thanks

 

[kenhamady]

First, which integration method are you using? If you are really 'creating' the report in VB, I will assume that you are using the RDC. If you are unsure, see the FAQ on what info to include with your question. Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB

http://www.kenhamady.com/

 

[eamonskelly]

I have partially solved my problem by passing the query back to SQL server, and creating a table for use, which makes it easier to perform grouping. I am accessing SQL Server 2000 via OLE DB, but when I run the report in VB, I get a SQL Server Not Available message. I have been able to access the report using ODBC, but this is not satisfactory.
Thanks for your help

 

[kenhamady]

Don't think I can offer much more here.
Good Luck. Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB

http://www.kenhamady.com/