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);
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
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);
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 ?
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
Answers
Refer below page for all Report Properties explained -
https://msdn.microsoft.com/en-us/library/dd354985.aspx
Thanks & Regards,
Saurav Dhyani
Do you Know this About NAV?
Connect - Twitter | Facebook | Google + | YouTube
Follow - Blog | Facebook Page | Google + Page
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.
Blog - rockwithnav.wordpress.com/
Twitter - https://twitter.com/RockwithNav
Facebook - https://facebook.com/rockwithnav/
What 's the source of this data ?
And how this data is set ?
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.
Blog - rockwithnav.wordpress.com/
Twitter - https://twitter.com/RockwithNav
Facebook - https://facebook.com/rockwithnav/
for every one having the same diffuclties see the video below :
Click here