Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

Troubleshooting
Research
Professional Opinions
Ask a Question
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

troubleshooting Question

Passing Record Selection VB6 to Crystal 2008

Avatar of peters4286
peters4286 asked on
Crystal ReportsVisual Basic Classic
5 Comments1 Solution359 ViewsLast Modified:
Im working with an app developed in VB6 that produces over 160 different crystal reports.

The app is coded to create a recordset in the app first, pass the results to a holding database, then the crystal report is run from that database.

This seems a very slow an sluggish way to produce reports.

The data is quite extensive, with users able to select from a list of 100's of different codes, and many options they want to report on.

I'm leaning towards passing the record selection formula to the report, however this string would be massive for some reports where a user has selected for example 100 odd codes, along with 250 other codes and 15 different options.

So given all this, Im wondering what others may suggest ?