RDLC Report SetData GetData Issue

Amolkbhad23 · 2012-08-09

Hi expert,
I am New in RDLC Report in Navision 2009 R2,
I am facing issue in RDLC Report. In RDLC report there is One text box its value is =Code.SetData(ReportItems!SalesHdrInfo.Value,4) , And In Body another text box its Value is
Like below
Fields!Sales_Invoice_Header___Bill_to_Customer_No__Caption.Value + Chr(177) +
Fields!Sales_Invoice_Header___Bill_to_Customer_No__.Value + Chr(177) +
Fields!VATNoText.Value + Chr(177) +
Fields!Sales_Invoice_Header___VAT_Registration_No__.Value + Chr(177) +
Fields!ReferenceText.Value + Chr(177) +
Fields!Sales_Invoice_Header___Your_Reference_.Value + Chr(177) +
Fields!Invoice_No_Caption.Value + Chr(177) +
Fields!Sales_Invoice_Header___No__.Value + Chr(177) +
Fields!OrderNoText.Value + Chr(177) +
Fields!Sales_Invoice_Header___Order_No__.Value + Chr(177) +
Fields!Sales_Invoice_Header___Posting_Date_Caption.Value + Chr(177) +
Fields!Sales_Invoice_Header___Posting_Date_.Value + Chr(177) +
Fields!Sales_Invoice_Header___Due_Date_Caption.Value + Chr(177) +
Fields!Sales_Invoice_Header___Due_Date_.Value + Chr(177) +
Fields!Sales_Invoice_Header___Prices_Including_VAT_Caption.Value + Chr(177) +
Cstr(Fields!PricesInclVAT_YesNo.Value) + Chr(177) +
First(Fields!FORMAT__Sales_Invoice_Header___Document_Date__0_4_.Value) + Chr(177) +
First(Fields!STRSUBSTNO_DocumentCaption_CopyText_.Value) + Chr(177) +
Fields!SalesPersonText.Value + Chr(177) +
Fields!SalesPurchPerson_Name.Value + Chr(177) +
Fields!PageCaption.Value

Now in text box value =Code.GetData(20,4) is written, Till now I understand that this is user for multiple array
And ‘ 4 ‘ stand for Set Data of Report Items SalesHdrInfo Value so my question for what ‘ 20 ‘ stand for
And if I want to add Fields!Sales_Invoice_Header___Salesperson_Code_.Value then how can I add. I need your help.
:-k

mohana_cse06 · 2012-08-10

Welcome to Mibuso
20 is the field no. in the list..
as I can see Fields!SalesPurchPerson_Name.Value is the 20th field in list..
if you want to add sales person field..
simply add at end as 22nd field
and write.

=Code.GetData(22,4)

Amolkbhad23 · 2012-08-10

thanks for reply.
New New textbox value i write
=Code.GetData(22,4)

and i also add value of textbox which is in Body.
Fields!SalesPurchPerson_Name.Value + Chr(177) +
Fields!PageCaption.Value + Chr(177) +
Fields!Sales_Invoice_Header__Salesperson_Code.value

(In Red mark)

but still i am getting error

Microsoft Dynamics NAV Classic

Error while validating RDL content:
The Value expression for the textbox ‘SalesHdrInfo’ refers to the field ‘Sales_Invoice_Header__Salesperson_Code’. Report item expressions can only refer to fields within the current data set scope or, if inside an aggregate, the specified data set scope.

OK

](*,) i need help. [-o<

mohana_cse06 · 2012-08-10

Did you add the field in classic sections?
Can you see Sales Person Code in Dataset?

Amolkbhad23 · 2012-08-10

Thanks for your Reply.

No. i am not add this filed in classic and
while manual writing in Fields!Sales_Invoice_Header__Salesperson_Code_
it is not there.

](*,)

mohana_cse06 · 2012-08-10

You need to add it in classic sections first..then set DataSetFieldName to Sales_Invoice_Header__Salesperson_Code_ or it will create automatically when you open layout.

then enter the value in rdlc..

Amolkbhad23 · 2012-08-10

Thanks for reply.
=D> its working thanks once again.
is it possible without adding field in classic report, i can use in RDLC data set ?
if yes, how and if no, then why..?

mohana_cse06 · 2012-08-10

Welcome

Yes, it is possible from NAV2013
No, till NAV2009R2 we have to create the data model in classic sections only..

RDLC Report SetData GetData Issue

Comments

Categories