Report Wont show all field??

nverma · 2012-02-22

Hi,

I am trying to create a report. I laid out the way I want the report to look. In my report, I want Job No, Description, Customer No, Customer Name, and Health card no. to show.

Everything shows up, except Customer Name. Any idea why??? Or How I can get it to work??

Thanks

mohana_cse06 · 2012-02-22

And the dataitem is?

Make sure that its not a flowfield..

nverma · 2012-02-22

Job is a dataitem in the report. Since I have access to all the fields in the Job table now:- Job No, Description, Customer No. Customer Name and health card no.

Everything shows up expect Customer Name.

I am kinda newbie at NAV, thats why I am struggling so much with this simple issue.

nverma · 2012-02-22

Customer Name is a flowfield in the Job table.

How do I change it or fix it so it will work in the work on the report!

mohana_cse06 · 2012-02-22

what kind of field is it? normal field or flowfield..

nverma · 2012-02-22

Customer name is of flowfield type. That is why its not working. But i dont know how to fix it to so it will work.

Savatage · 2012-02-22

JobTable.CALCFIELDS("Customer Name");

FlowFields are virtual fields. The values in these fields are not saved in the table. This means that you must use the CALCFIELDS function to update them.

http://msdn.microsoft.com/en-us/library/dd338975.aspx

mohana_cse06 · 2012-02-22

Use CALCFIELDS("Customer Name"); in Job - OnPreDataItem()

nverma · 2012-02-22

Where am I suppose to put this line of code?? In SourceExpr or in C/AL CODE???

It might seems like a stupid question. But I am sorta lost.

Savatage · 2012-02-22

You said it was a report. go to the dataitem & then F9.

nverma · 2012-02-22

I tried putting it in OnPreDataItem() .

Job.CALCFIELDS("Consumer Name");

It didnt work. I tried running the report, its still coming up as empty.

Savatage · 2012-02-22

then try OnAfterGetRecord

as a newbie the Application Designers Guide can be a big help.
Download it here: (w1w1adg.pdf)
http://www.microsoft.com/download/en/de ... n&id=24432

After saving remember to completely get out of the report & go back to make sure your working with all the recent changes.

Savatage · 2012-02-22

Also the first post you wrote "Customer Name" & the the last one you posted "Consumer Name".

Make sure you get it right!

nverma · 2012-02-22

Thank you so much. FINALLY, got it to work.

I put it in OnAfterGetRecord and it worked like a charm.

Just one last question. Whenever I am fetching some information. Lets say: Job.GET("No.");

Would I put it in OnPreDataItem or OnAfterGetRecord.??

mohana_cse06 · 2012-02-22

nverma wrote:

I tried putting it in OnPreDataItem() .

Job.CALCFIELDS("Consumer Name");

It should be Customer Name or Consumer name?

Savatage · 2012-02-22

OnPreDataitem you don't have a record yet.

I use OnAfterGetRecord and I use an If statement just to control any crahses.

If Job.GET("No.") then begin
..do stuff
..do stuff
End else Begin
..do other stuff
..do other stuff
end;

nverma · 2012-02-22

It is consumer Name. It was a typo before.

What is the difference between OnPreDataItem, OnAfterGetRecord, OnPostDataItem.

This is my basic understanding:

OnPreDataItem - You would put varaibles that you want to declare.

OnAfterGetRecord- You would put, your get statements, filters, and basic code.

OnPostDataItem- I am not sure what goes in here ?????

If i want to do total number of Jobs. Would I put the code in OnAfterGetRecord Trigger or OnPostDataItem trigger?

Savatage · 2012-02-22

Go here to find out all you need to know about TRIGGERS:
http://msdn.microsoft.com/en-us/library/dd301068.aspx

Your case : Report, Section, and Data Item Triggers

nverma · 2012-02-22

Thank you guyz...

that helped alot...I just have one more condition to write and i will be done...

Savatage · 2012-02-22

Edit your first post and change the attribute to "Solved"

Report Wont show all field??

Answers

Categories