Many formulas - slow report

[Former Member]

Hello,

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.

Regards.

[abhilash_kumar · Accepted solution]

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.

-Abhilash