code.get data in RS report

julkifli33

Hi All
i want to know we can know code.get data in RS report
for example report 116 (Statement)
code.getdata(9,1) --> represent customer no. caption
code.getdata(10,1) --> represent customer no. field

how to know this one is (9,1).... this one is (10,1)
thanks in advance

manikandan

julkifli33 wrote:

Hi All
i want to know we can know code.get data in RS report
for example report 116 (Statement)
code.getdata(9,1) --> represent customer no. caption
code.getdata(10,1) --> represent customer no. field
how to know this one is (9,1).... this one is (10,1)
thanks in advance

Hi ,
RDLC layout ,in Body section one hidden table is there.from this you can identify code.getdata(x,y).
kindly view the attachment.from this you can understand. :thumbsup:

Regards,
Muthusubramanian.M

Ian_Piddington10199

The code.getdata(9,1) means to get the 9th bit of data from a text box. If you look at the top of the page header you should see 4 boxes (this is on report 116). The first one has the following as its expression =code.SetData(ReportItems!CustAddr.Value,1).

This means to take the value of the Textbox labeled CustAddr and and reference it with your Code.GetData(#,1)

The CustAddr Text box is in the body of the report. At the top of the body you can see a very small table this has all the various referenced textboxes in it. The expression for the CustAddr one looks like this.
=Fields!CustAddr_1_.Value + Chr(177) + Fields!CustAddr_2_.Value + Chr(177) + Fields!CustAddr_3_.Value + Chr(177) + Fields!CustAddr_4_.Value + Chr(177) + Fields!CustAddr_5_.Value + Chr(177) + Fields!CustAddr_6_.Value + Chr(177) + Fields!CustAddr_7_.Value + Chr(177) + Fields!CustAddr_8_.Value + Chr(177) + Fields!Customer__No__Caption.Value + Chr(177) + Fields!Customer__No__.Value

The Chr(177) is a seperator so
getdata(1,1) would be the CustAddr_1_ field getdata(2,1) would be CustAddr_2_ etc.

Hope that helps clarify it a bit.

regards

Ian