Code.GetData(x,y) in RDLC report

julkifli33

hai all... anyone know how to use this function?
i want to modify Statement report (report 116), but i want to change the sequence of customer info
is use report items as usual but sometimes not showing every page
any one have same issue?
or is there any link how to use code.getdata?

Jatin_Patel

Try this Link:

http://www.dynamicsnavconsultant.com/20 ... -required/

julkifli33

Jatin Patel wrote:

Try this Link:

http://www.dynamicsnavconsultant.com/20 ... -required/

hi Jatin, thanks for the link

sometimes code.getdata(1)
but sometimes code.getdata(1,1)
how do we know this 1? or this 1,1 to which record?

Jatin_Patel

julkifli33 wrote:

sometimes code.getdata(1)
but sometimes code.getdata(1,1)
how do we know this 1? or this 1,1 to which record?

If u have only one array for getdata then use code.getdata(1)
and for multiple have to use code.getdata(1,1)

thegunzo

See properties for your report (in Visual Studio) and look in the Code tab.

colingbradley

There seems to be a lack of knowledge of how to use the Code.GetData(x,y), I am making some assumptions I would like someone to help me with.

In report 206, Body, TableRow1 there are 4 hidden textboxes :
CustAddr
CompanyAddr
CompanyInfo
SalesHdrInfo

I understand that these are needed to be used in the Header for example, no problem so far.

Where you have =Code.GetData(1,1) or =Code.GetData(1,4) and so on, I think the x = first field in the expression but where does the y come from?

Click on Report.rdlc, Report/Report Properties/Code
This shows the way the report handles the sequence contained in the SalesHrdInfo/Expression and the others

Select SalesHdrInfo
Click on the Properties SalesHdrInfo Textbox (right-top) and get a drop down of all the fields
Select SalesPersonText1 and you see the Value : =Code.GetData(19,4)
That will show you on the report where that field has been used.

Add another field at the bottom of the Expression such as:
Fields!PageCaption.Value + Chr(177) + (add the following to the last line) + Chr(177) +
Fields!PricesInclVAT_YesNo.Value
Drop the field into the header section from the Result list, then add =Code.GetData(22,4) as the Value

If the above is not correct, please someone do the right thing and clear up the explanation guide.

postsaurav

Hi,

Try reading this article .

http://saurav-nav.blogspot.in/2011/07/rtc-report-development-3.html

@colingbradley -
IN Code.GetData(x,y) - X is the data postion in that particular group (red textbox in body) and Y is the group No.
While creating reports you can skip Y if you don't want it.

If you still have any doubts let me know.