mibuso.com

Hi

I'm trying to add inventory field for Inventory availability report (705)

I get it working on classic side but on RDLC it wont calculate the field.

I have calcfields on the section side though, do I have to do add something on the rdlc side too so it calculates there?

In which trigger you have your "calcfields"?

Its in the section where I have the textbox with sourceexpression inventory


Item, Body (6) - OnPreSection()

In this way can't work because RTC doensn't execute code written under Sections.
You've to move your code under the correct DataItem trigger.

Hmm I moved the calcfield under the dataitem but still it does not count the values on rdlc

Item - OnPreDataItem()
IF ISSERVICETIER THEN
GetCurrentKey := Item.CURRENTKEY;

Item.CALCFIELDS(Item.Inventory); // <------------

OnPreDataItem the record is not available yet. Of course it doesn't work. You should put it in OnAfterGetRecord.

Have you already tried the same code in Item - OnAfterGetRecord()?

Aa, that sorted it. now it works

Cheers guys

I have a 2009 R2 W1 database (without any other country specific objects). I have just added the Inventory field in the Bosy section of Item dataitem, and changed the RDLC layout. The report (705) is printing the proper Inventory balance figures both in classic and RTC reports. Can you do this on a new database and check?

Chn