Code methods (Reports)

timobech · 2016-03-28

Hello,
i'm new in nav developement .
Can any one of you guys, explain to me the principe of methods specified in proprieties of report .

Thanks

RockWithNAV · 2016-03-28

Hey timobech,

Report Proprties -> Code

This section of RDLC Reports are the custom Codes written to handle some spcific conditions in the Reports. This section is completely open to write any custom logics that you are willing to create to create and use in your Reports. The only thing you need to take care any piece of code written in this area should be used with Code prefix like Code.YourFunctionName.

If you will notice this standard code written there

Public Function BlankZero(ByVal Value As Decimal)
if Value = 0 then
Return ""
end if
Return Value
End Function

You can use this function to make blank your Zero value instead of showing 0.
The Code you need to write is Code.BlankZero(Fields!X.Value);

Hope you understood.

RockWithNAV · 2016-03-28

If you open Report 206 -> Report Property -> Code, You will find GetData and Setdata in Combination, These two codes are used to update the value of Header Dynamically when you move to Next Orders in the Report.

Now how it Works -

To use this you need to take a taxtbox in the Body of the Report. In the visibility expression you need to write something like the below snapshot (This one is the screenshot of 206 Report)

Now once you define this you need to write the values in Header Textbox something like this

Code.Getdata(1,1)
Code.Getdata(2,1)
Code.Getdata(3,1)
Code.Getdata(4,1)

These changing 1 2 3 4 represent which value mentioned in SetData you want to show here.

postsaurav · 2016-03-28

Hi,
Refer below page for all Report Properties explained -
https://msdn.microsoft.com/en-us/library/dd354985.aspx

RockWithNAV · 2016-03-28

Hey timobech,

Report Proprties -> Code

This section of RDLC Reports are the custom Codes written to handle some spcific conditions in the Reports. This section is completely open to write any custom logics that you are willing to create to create and use in your Reports. The only thing you need to take care any piece of code written in this area should be used with Code prefix like Code.YourFunctionName.

If you will notice this standard code written there

Public Function BlankZero(ByVal Value As Decimal)
if Value = 0 then
Return ""
end if
Return Value
End Function

You can use this function to make blank your Zero value instead of showing 0.
The Code you need to write is Code.BlankZero(Fields!X.Value);

Hope you understood.

timobech · 2016-03-28

thanks RockWithNav, but what i can't understand is : when i open expression of some textBox i see Code.getData(parameter) , so the question is :
What 's the source of this data ?
And how this data is set ?

RockWithNAV · 2016-03-28

If you open Report 206 -> Report Property -> Code, You will find GetData and Setdata in Combination, These two codes are used to update the value of Header Dynamically when you move to Next Orders in the Report.

Now how it Works -

To use this you need to take a taxtbox in the Body of the Report. In the visibility expression you need to write something like the below snapshot (This one is the screenshot of 206 Report)

Now once you define this you need to write the values in Header Textbox something like this

Code.Getdata(1,1)
Code.Getdata(2,1)
Code.Getdata(3,1)
Code.Getdata(4,1)

These changing 1 2 3 4 represent which value mentioned in SetData you want to show here.

timobech · 2016-03-29

Thank you, RockWithNav i get it

for every one having the same diffuclties see the video below :
Click here

Code methods (Reports)

Best Answers

Answers

Categories