Recalc doesn't work in Reports

[sandya]

Hello,

I tried to use Recalc method in Reports but it doesn't work. i used VBA Dsum in my Report_Load but it takes so much time to update. Due to this reason i tried Recalc method but it is not supporting. Please give suggestions to speed up ???

I used this code in Report_Load:

TotalCreAmt.ControlSource = "=Nz(DSum(""[Amount1]"", ""[CRM_QryFinal]"", ""[Transaction]<>'Sales'""), 0)"
TotalRecAmt.ControlSource = "=Nz(DSum(""[Amount2]"", ""[CRM_QryFinal]"", ""[Transaction]<>'Sales Return'""), 0)"
Me.Recalc

:banghead::banghead:

 

[KenHigg]

Seems a report is a static type thing, why the need to recalc anything?

 

[gemma-the-husky]

try the same in the print method of the section.

I expect at load time the [transaction] may not be defined.