!! Make CR stop fetching data while designing the report!!

[davidwendelken]

When I pick a table or view in the database expert or report creation wizard, CR seems to insist upon querying ALL the data in that table or view before it lets me proceed. I have some really big tables.

I can't put in the selection criteria until after I twiddle my thumbs and curse for 5 to 20 minutes waiting for all the data to be queried.

I haven't been able to find a setting that tells it "don't get the darn data until I tell you to!"

How can I make it stop doing this?

David Wendelken

http://www.casetech.net

 

[Turkbear]

Hi,
I have never seen that behavior - Adding a table with many columns can take some time while the MetaData is being read, but never have I experienced the times you indicate.
( I have joined tables with several million rows to each other with only several seconds wait time )

What Datasource are you using and what connection method?





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[davidwendelken]

I'm using oracle as the datasource, and the CR drivers for it.

CR v10

oracle 9.2

David Wendelken

http://www.casetech.net

 

[Turkbear]

Hi,
Try it with a Native SqlNet connection instead.
(Create New Connection..Oracle Server)







To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[synapsevampire]

Some databases just take a long time to return information, that may be your culprit as well.

Saying that you're using the CR drivers doesn't define what you're using, Crystal has native connectivity, and ODBC for Oracle, the latter being pretty slow.

Also, if you're in preview mode, and you change the record selection formula, it will requery, so make sure that you're in the designer mode.

-k

 

[lbass]

Yes, the key thing is to be in design mode when making these changes. I work with a database that's is huge and slow to return records, and I make a habit of working in design mode and saving often, choosing always not to refresh the data. If I accidentally start a preview I can shut CR down using control-alt-delete instead of waiting. That's also why I try to always remember to save any changes before previewing. If it occurs to me that I've forgotten something I can close out without losing changes.

-LB

 

[synapsevampire]

If it's real slow, then place 1=0 in the record selection formula until you need a refresh.

-k