How to Use the SQL Query String in VB6 With Crystal Reports XI

When you create computer programs in the Visual Basic 6 (VB6) programming language, you can export data from an SQL database directly into Crystal Reports, a software program used for creating data summaries, charts and reports. This is done through a built-in extension in VB6 that is installed whenever Crystal Reports is installed on the computer. All you need to know is what type of SQL query you want to use and VB6 will execute that query and automatically deliver the results to Crystal Reports.

Instructions

1. Open the VB6 editor and open your application.

2. Assign the SQL query to a string variable with the code "new var sql_query=STRING["your_sql_query_here"]", where "your_sql_query_here" is the SQL query that you want to execute.

3. Execute the SQL query and transfer it to Crystal Reports XI with the "sql_query->crystalxi(data.transform())" command.

References

• "Visual Basic 6 Developer's Handbook"; Evangelos Petroutsos and Kevin Hough; 1998

Resources

• Read this Article in Spanish