Hi,
I`ve created table with some flowfields which has CalcFormula like:
Count("MyTable" WHERE (Field1=FILTER(No),Field2=FILTER(No),Field3=FILTER(Yes))).
I`ve set up LookUpFormId and DrillDownFormID with properly values.
When i`ve checked flowfields value in table its ok.
Then i`ve created Card type form to show this value with property AutoCalcField = YES.
What i see on form is values 0, but when i click to drill down flowfield i can see properly number of records.
I`ve creeated form using standard form wizard in NAV 5.0 sp1 client.
regards,
depro
0
Answers
Hi depro,
The filters you have given in the calcformula might not gives any countable data in the table you have specified. So, it would have shown 0. Change the method to "sum" instead of using "count". Sorry if i misunderstood. =;
Thankesh
***Learn to lead***
see if what i understood is right, you want the count of the field's value in your table.
shona
That which you seek inside is that which you find outside
Yes I wont to count record i table.
@ thankesh
My filters work good becouse I can drill down 0 value from my form and I see accurate numbers of records.
And when i run my table flowfield shows correct values.
It looks like something is wrong with my form.
First i`ve createt form from Wizard, but when i`ve checke properties and it`s looks ok. Then i`ve made this form in object designer but it still doesn`t work.
It is first time when i have problems with flowfield values on form.
So I really don`t know why it work (doesn`t work) in taht way.
regards,
depro
Yes, There is 1 record in my table which contain flowfiels.
It is my setup table and it was designed like Table 311 Sales & Receivables Setup.
The most confusing thig is that this flowfields has correct values int table.
I still working on this issue, i add some custom code on form in OnAfterGetRecord and OnOpenForm like
But my form still don`t show my flowfielda values.
regards,
depro
I`ve checked SourceExpression few times.
For exmple:
On form:
SourceExpression: "No. of New Resource"
Table:
Enabled Field No. Field Name Caption Data Type
Yes 70 No. of New Resource <No. of New Resource> Integer
Properies field 'No. of New Resource"
FieldClass: FlowField
CalcFormula: Count("Resource Import" WHERE (Used=FILTER(No),Rejected=FILTER(No),New=FILTER(Yes)))
So kapamarou thanks for your advice but i guess the point is somewhere else.
I`ve made this form few times with different propoerties but it still doesn`t work ](*,)
Could you please post some parameters of your system, e.g. SQL or native, Client Verson (Build No.), ... anything else that could be worth mentioning.
Pargesoft
Here is definition of my obejcts:
Copy this code to txt file and import it.
Regards,
Sorry for asking again, but did you insert a new record in table Import Setup? Just to make sure that when you open a form it is not on an [untitled - Import Setup] "New" record.
If there is no record the flowfields seem to work through the table but not through the form...
Pargesoft
The problem was my record in table.
I didn`t put anythig in Primary Key field, just in other field in table.
So now my form work`s fine.
But i can`t understand why my FlowField calculation is not performed?
I thought that if only i`ve put some data in table record (exluding Primary Key) I`ve go record.
Is it necessary to put some value in primary key to make record?
Regards,
Of course. Although it just contain 1 record, such as Sales & Receivables Setup. The primary key will maintain the records so that it will be unique for each record.
Andwian