Problems with the export feature

[aplusc]

I'm running Crystal for VB and I'm trying to create a button that will automatically open the Crystal export dialog (without opening the report first). Sounds simple enough, but for some reason it exports ALL the 100,000 records from the table, not those that were selected as part of the query. This does not happen when I open it through the viewer and then export.

I do something like this:

CrystalReport1.SQLQueryString = "SELECT * FROM ... "
CrystalReport1.Export

What am I doing wrong?

 

[rdejesus]

I personally make the query inside the report or use a stored procedure, then export it.

 

[balves]

What version of Crystal?

Perhaps this is relevant to your problem, perhaps not.

http://support.crystaldecisions.com/library/kbase/articles/c2009801.asp