crystal reports running slow ?

All,

I have been tapped to help with fixing a reporting tool. We have a Sql Server database/crystal reports(10) setup. I havent had the chance to look at the tables in the DB yet, but I was told that aggregate tables were used. In my past experience with crystal reports, we used database views to feed crystal reports (in Oracle). I was thinking that I could somehow use views instead of tables and then try to re-index the base tables and compile satitics (if theres such a thing with Sql Server). I was also going to look into bottlenecking and locking (table locking as opposed to row or page locking for the lookup tables...to reduce overhead on the main tables) but, I'm not sure if it'll make a difference since this is just a demo server with no major traffic hitting it yet.

The question is, does anyone have any experience with crystal reports running slow with Sql Server, what should I look out for??

'WaleCrystal reports sucks.

Now that we have gotten the obligatory disparaging remark out of the way, you should push as much processing as possible onto the server, and use Crystal only for displaying the data. This means having Crystal call either a Procedure, View, or Table.

If your tables are pre-aggregated, then that is about as fast as you are going to get, because all the processing work is done during nightly batch processing (usually). That said, if your so-called pre-aggregated tables are actually being created on the fly each time the report is requested, well, that's about the lease efficient method.

With the (possible) exception of data aggregated for specific reports, it is seldom a good idea to reference tables directly. Reference views or (preferably) procedures instead, so that if the database schema needs to be changed you will just need to update your procedures rather than redesigning all your reports.

Make sure the aggregated tables are indexes on any columns used for filtering, and your dataset will be generated very fast. If the reports are still slow, take a close look at your network and figure out how much data is actually being passed back to Crystal. Maybe additional filters are possible.|||I couldn't agree with you more blindman, unfortunately, I don't make the decisions. I like the idea of having Crystal calling stored procedures, so it'll be a simple call and we'll have the procedure take care of any processing. I'll also looking into indexing etc.....|||a stored procedure for every report...sounds like a maintenance nightmare...and also, defeats the purpose of the tool.

you will want to look at all the WHERE clauses in the reports and index all the columns included.

the best solution would be to look into restructuring the data into a reporting friendly format (i.e. star schema).|||We decided to use DTS to create aggregate tables for us. And we added some indexes. The reports have picked up speed.|||A stored procedure for every dataset, not every report. And the result is reduced maintenance. Business logic that would have to be duplicated in every report only has to be implemented in the procedure, and you can be sure that the results of all reports based upon the same procedure will yield compatible results.

The purpose of the Crystal Reports tool is to present data, and that is what it should be used for. The purpose of the Database Server is to store and manipulate the data, and that is what it should be used for.

And Star Schemas are vastly overrated. They are the poor-man's database design.|||I disagree...

business logic should be handled at the meta-data layer for the reporting tool not at the report level. (i.e. one place)

crystal is not just for presentation...it's meant to facilitate business questions to be answered while shielding the user from the complexities of SQL.

star schemas vastly overrated? well, no...it's the best possible reporting structure....and a little thing called OLAP!|||OLAP and Star Schemas are not synonymous. A Star Schema is just a glorified pivot table. For functionality, it is just one step beyond a flatfile.

You can let your business model drive your schema, or you can let your schema drive your business model.|||For functionality, it is just one step beyond a flatfile.

I suppose...other than the functionality of robust and high performance reporting.

You can let your business model drive your schema, or you can let your schema drive your business model.

haha...Copernicus...I love it!! ;-)|||Ok, I admit it. You got me on "Copernicus". What's the reference? His planetary model?

Crystal Reports E10 and Data warehouse

Hi, there,

Is there anybody here who is working with data warehouse with Crystal Reports as a tool? Would you please share some experience with me?

I used to work with Oracle reports. It seems to me that Crystal needs to bring all the table data back to client before I may link the tables to get query right.

Another question is how to implement the following requirements:
List all the detail account information for all the accounts under firm A.

Here Firm A might have over 100,000 accounts. The fact tables will holds all accounts for all firms data.

In Oracle reports, we can define 2 path query to get the account number for firm A first then get each account detail by using parent child query. How crystal achieve this kind of query ?

Thanks,Design the report using parent and child tables
Group by the report by key column

Crystal Report Prob

I have used the following in my project-
i) V B 6.0 as Front End Tool.
ii) Oracle 8 as RDBMS.
iii) Windows 2000 Advanced Server as Server O.S.
( The machine has dual O.S i.e Windows 98 SE also is there)
iv) Crystal Report 7.0 as Reporting Tool.

Now my problem is While calling a report from VB, I need to REFRESH and SAVE the report in Seagate Crystal Report, otherwise the latest data inserted does not show.

The part of coding used also given below-

RPT1.Selectionformula=Tablename.Fieldname
RPT1.Action=1
Some more points-
i) Another important point is I used DiscardSaveData property before Action property, even then it was not working.
ii) There is no Refresh method shows in the Property and Method List.
iii) Sometimes while saving the Report in Crustal Report I had to use Save As command as the report takes some other name having extension .TMP[Moved thread]

Crystal Report for Access

Hello, I want to ask a silly question.
I doubt if this is possible... :rolleyes:
How can I use the CrystalReportViewer tool using an Access Database in Visual Basic.NET (2003)to be a bit more specific - i need 2 populate a crystal report from a database/dataset without it asking me 2 login 2 the data source. i'm sure there's a simple way 2 do this but i'm a newbie so please forgive me. :) the database is a normal .mdb file without any password.|||:D Hey David!

I've figured some things out - I hate Crystla Reports!!

Project, Add New Item, Select Crystal Report. in that wizard we select the drivers (almost similar to DSN box), from there on, we can select the table etc.
The reason why it asks for the login, is because it seems like it's defaulted to SQL Server or the MSDE.
My PC doesn't have Access on XP, so it gave me some trouble, but hopefully we come right with this!|||i'm still not getting it right... help :( i'm populating datasets but no data is showing on the report. i get the column headings but no data. surely someone here should have a solution...|||eish, how dumb am i? :)

assuming i have a report built off a dataset ->

Public rpt1 As New rptTest 'crystal report

rpt1.SetDataSource(dsTest)
CrystalReportViewer1.ReportSource = rpt1

although u folk probably know this already maybe it'll help another newbie.

thanks 4 ur help Hannes. :) i'll buy u that beer soon dude.

crystal report comparison

hi
I have to compare two crystal report text. Is there any tool which does this?
or Any Code which does this?
It has to be done on rpt only.No conversion of report to any other form.

With regards
RashmiIs is at runtime u want to compare 2 reports?

Crystal 2 ReportingServices

Does anybody know a free tool to convert Crystal Reports to Reporting
Services ?
Thanks ins advance,
Tito.On Jun 5, 1:10 pm, "Marcos Tito" <mrct...@.hotmail.com> wrote:
> Does anybody know a free tool to convert Crystal Reports to Reporting
> Services ?
> Thanks ins advance,
> Tito.
Unfortunately, I have not found any free conversion options. Here are
a few that can do the conversion for a price though:
http://www.microsoft.com/sql/technologies/reporting/partners/crystal-migration.mspx
http://www.rpttordl.com/
Sorry I could not be of greater assistance.
Regards,
Enrique Martinez
Sr. Software Consultant|||Thank you !
"EMartinez" <emartinez.pr1@.gmail.com> escreveu na mensagem
news:1181100921.907554.304710@.p77g2000hsh.googlegroups.com...
> On Jun 5, 1:10 pm, "Marcos Tito" <mrct...@.hotmail.com> wrote:
>> Does anybody know a free tool to convert Crystal Reports to Reporting
>> Services ?
>> Thanks ins advance,
>> Tito.
>
> Unfortunately, I have not found any free conversion options. Here are
> a few that can do the conversion for a price though:
> http://www.microsoft.com/sql/technologies/reporting/partners/crystal-migration.mspx
> http://www.rpttordl.com/
> Sorry I could not be of greater assistance.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>|||On Jun 6, 8:22 am, "Marcos Tito" <mrct...@.hotmail.com> wrote:
> Thank you !
> "EMartinez" <emartinez...@.gmail.com> escreveu na mensagemnews:1181100921.907554.304710@.p77g2000hsh.googlegroups.com...
> > On Jun 5, 1:10 pm, "Marcos Tito" <mrct...@.hotmail.com> wrote:
> >> Does anybody know a free tool to convert Crystal Reports to Reporting
> >> Services ?
> >> Thanks ins advance,
> >> Tito.
> > Unfortunately, I have not found any free conversion options. Here are
> > a few that can do the conversion for a price though:
> >http://www.microsoft.com/sql/technologies/reporting/partners/crystal-...
> >http://www.rpttordl.com/
> > Sorry I could not be of greater assistance.
> > Regards,
> > Enrique Martinez
> > Sr. Software Consultant
You're welcome. Let me know if I can be of further assistance.
Regards,
Enrique Martinez
Sr. Software Consultant