Showing results for 
Search instead for 
Did you mean: 

Many formulas - slow report

Former Member
0 Kudos


I'm quite new to CR.

I just need to ask you experts is it a good practice to put many formulas on a report. I' ve started creating report depending on existing db materialized view. Data returned by that view needs very much filtering and formatting. I decided to write formulas in Crystal Reports but it looks like there need to be one formula for each field.

Is it a common practice to do this that way or maybe I should try to redisign my query.

I'm very curious what is your method.


Accepted Solutions (1)

Accepted Solutions (1)

Active Contributor
0 Kudos

Hi Piotr.

Of course, it is always better to handle 'most' of the calculations outside CR.

If you have a formula for every field, you should try to include the logic in the SQL to speed up the report.


Answers (0)