Subreport Link using formula

[question911]

Crytstal Report 9

I have a group section in my main report. I added a subreport in the header section and linked the two reports using a formula. Both reports have this same formula. Everything works fine, however, the reports take 20 minutes to run. Is there anything I can do to speed up the process without creating a stored procedure on the database or creating a SQL expression?

Here is the formula I am using:

Numbervar minextract := minute({acdgroupstats.d_time});
Stringvar amdmins;

if minextract <= 15 then amdmins := time(hour({acdgroupstats.d_time}),00,00) & "^" & time(hour({acdgroupstats.d_time}),29,00) else
if minextract >= 30 then amdmins := time(hour({acdgroupstats.d_time}),30,00) & "^" & time(hour({acdgroupstats.d_time}),59,00);

amdmins;

 

[synapsevampire]

Subreports are slow...

You'll need a Crystal SQL Expression or a View or an SP on the database.

Why wouldn't you want to use a SQL expression?

-k

 

[question911]

I have no idead about the functions in Informix.