Crystal Reports poor performance

[solemgar]

I´ve got a report to show in VB.NET which i created using the embedded crystal reports designer that comes with visual studio. In that report i´ve got two tables in a dataset linked by a common field. The report has about 1000 rows and it takes too much time too load. And in top of all, cpu usage goes up to 99%... I read in google that in the crystal reports software (the full version) there is an option called "save data with report", that if it´s disabled can speed up the report load, but i can´t find it anywhere in visual studio.

Sorry about my english, and thanks for reading, i really need an answer!

[Hack]

Welcome to the forums.

Since the dawn of VB there has been a version of Crystal Reports that shipped with the Microsoft product. That version has always been the Standard version of Crystal Reports, which, fundamentally, was pretty worthless. The Standard version had/has just enough features to get your appetite whetted, but not enough features for you to really be able to do anything with it.

I call it the "Teaser" version. If you want the full funtionality of Crystal Reports, then you are going to have to go out and purchase the Professional, or better yet, Enterprise edition. Otherwise, you are stuck with what they gave you, and you are already running into some of the limitations.

[solemgar]

Wow, thanks for the warm welcome, it´s my first post and I almost feel at home

In fact i was expecting no reply or something like "STFU you noob, go l33t somewhere else!"

Well, i suppose i´ll have to stick to the "teaser" version of Crystal, but i think still to slow... and i noticed that other users had performance issues when working with Access DataBases and CR... And guess what? I´m stuck with an Access 97 database...
So any help would appreciated cause our clients there are not going to be very happy...

Thanks again for reading.

[techgnome]

My condolences.... seriously....
Access AND CR... owch... That's a 1-2 punch.

BTW: The Save Data With Report option is generaly found in the File menu (very intuitive, huh?) because it can actualy be turned on/off on a per-report setting. But then I've never used the built-in version of CR, we've always had the Enterprise version, so your mileage may vary.

Tg

[Hack]

You are using VB.NET with an Access 97 database?

Isn't that kind of like putting a Volkswagon engine in a Lambergini?

Instead of Crystal, would it be possible for you to use Access Reports since you are using an Access database? I have limited experience with .NET, but calling an Access report from VB6 was/is a walk in the park. I'm guessing that functionality still exists.

[solemgar]

You are using VB.NET with an Access 97 database?

Isn't that kind of like putting a Volkswagon engine in a Lambergini?

Instead of Crystal, would it be possible for you to use Access Reports since you are using an Access database? I have limited experience with .NET, but calling an Access report from VB6 was/is a walk in the park. I'm guessing that functionality still exists.

I completely agree, but ADO.NET seemed a good approach because that database is also used by an ASP app... It´s s bit long to explain but I can assure you that the place where i work didn´t have that idea... It was our gracious goverment... sigh... A worthless piece of sh*** that barely works.. We choose ADO.NET to use the " disconnected" data access and not overload the ASP app nor the DB... But i am starting to think that it wasn´t a very good idea...
But hey... it does work... barely :P And in some scenarios, even performs well

Sorry to bore you with this story, i started to work as a pro on programming a little ago and i feel a little lost yet... Too much to learn yet!

At least, our next project will be using PostGreSql... what a relief...

Thanks for reading again.

PD: Hope my english is still readable.