transfer order report

(0) Share

Report

Posted on by Community Member Microsoft Employee

i created one global variable for company information table in transfer order report , through this i get the company name field in dataitem.

In transfer order report layout , i create one textbox and i get that field.

But after i run the report i am not getting the company name, how can i get that field..

*This post is locked for comments

All responses (5)

Answers (4)

manish.yadav 1,835 on at

Like (0)

Report

RE: transfer order report

Dear Gayathri Ji,

If my answer helped to resolve your issue, kindly verify it by clicking 'Yes'. It would be helpful to the other community members seeking to resolve a similar issue.
Verified answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: transfer order report

\

finally i wrote this code and i got the company name in report.

Thanks for your Reply.
Verified answer

manish.yadav 1,835 on at

Like (0)

Report

RE: transfer order report

I have generate a new code. please use the code like...

OnPreReport()

recCompanyInformation.GET;

arrLoctAdd[1] := recCompanyInformation.Name;

arrLoctAdd[2] := recCompanyInformation.Address + '-' +recCompanyInformation."Address 2";

recState.GET(recCompanyInformation.State);

IF recCountry.GET(recCompanyInformation."Country/Region Code") THEN

arrLoctAdd[3] :=', ' + recCompanyInformation.City + '-' + recCompanyInformation."Post Code" + ', ' + recState.Description + ', ' + recCountry.Name;

arrLoctAdd[4] := 'Phone No. : ' + recCompanyInformation."Phone No.";

Note: Here arrLocAdd is the text variables(Go in properties for this variable and set dimensions 4).

Transfer Header - OnAfterGetRecord()

recCompanyInformation.RESET;
recCompanyInformation.FIND('-');
txtComapnyName:=recCompanyInformation.Name;
txtCOAddr1:=recCompanyInformation.Address;
txtCOPhone:='Phone : '+recCompanyInformation."Phone No.";
txtfax:='Fax: '+recCompanyInformation."Fax No.";
txtemail:='E-Mail:'+recCompanyInformation."E-Mail";
recCountryRegion.SETRANGE(Code,recCompanyInformation."Country/Region Code");
IF recCountryRegion.FIND('-') THEN BEGIN
txtCountryOrigin := recCountryRegion.Name;
END;
Verified answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: transfer order report

Thanks for your reply,

but i am getting this error
Verified answer

manish.yadav 1,835 on at

Like (0)

Report

RE: transfer order report

Dear Gayathri Ji,

use the code like in

Transfer Order OnAfterGetRecord() trigger.......

CurrPageNo :=CurrReport.PAGENO+1;

CompanyInformation.RESET;

CompanyInformation.FIND('-');

txtComapnyName:=CompanyInformation.Name;

txtCompAdd := CompanyInformation.Address+' '+CompanyInformation."Address 2"+' '+CompanyInformation.City;

txtPANNo:=CompanyInformation."P.A.N. No.";

Here CompanyInformation is the record variable.

And txtComapnyName, txtCompAdd ,txtPANNo are the text variable.

Please define it in globals variables section.

And add there variables in Transfer Order Dataitem

Expanded Data Type Data Source Name Include Caption

0 Column txtComapnyName CompName No

0 Column txtCompAdd CompAdd No

0 Column txtPANNo PANNo No

After this please use this fields in in RDLC report designer.

Hope it will help you.