Reports

prashanth0027

Hi experts

Invoice number in report contains alpha numeric upto 15 ch length(MAN-12-13-00001) , but when converting to excel i want to print only numeric values(00001).i want code to print in excel (00001)

Regards.
PRASHANTH

kapamarou

Have you tried something that didn't work?

prashanth0027

no .please provide me the code as soon as possible

sendit2jason

Define 'converting to excel'. If you are referring to saving as HTML then opening with Excel, then it's not a NAV issue.

mohana_cse06

prashanth0027 wrote:

no .please provide me the code as soon as possible

Sure sir.. Let's make a deal for this...how much $ do you pay for this task?

prashanth0027

report ,exporting to excel format need code for printing only last 4 digits.if it is like MRN-12-13-0001

mohana_cse06

mohana_cse06 wrote:

prashanth0027 wrote:

no .please provide me the code as soon as possible

Sure sir.. Let's make a deal for this...how much $ do you pay for this task?

:whistle:

Marije_Brummel

The "rules" we have on this forum is that we do not provide a free helpdesk.

(I don't know if this is an official rule).

This is a community website were we help each other expecting that the people we help have tried what they can to solve the issue themselves.

Hence the question, what have you tried and where does your code stop working.

I understand that not everyone speaks or types perfect english but please realise that everyone is a volunteer.

prashanth0027

i'm learner i'm unable to pay . give me suggestion where to write code at least


regards

Prashanth

Savatage

prashanth0027 wrote:

i'm learner i'm unable to pay . give me suggestion where to write code at least
regards
Prashanth

how about onaftergetrecord of the dataitem.
if the length & style of your # is always the same you could use copystr
http://msdn.microsoft.com/en-us/library/dd338944.aspx

good luck!

Download & print w1w1adg.pdf
http://www.microsoft.com/en-us/download ... x?id=24432

Read the section about Reports

bala

I hope this code is work, write this code OnAfterGerRecord()

Str1 := FORMAT('MAN-12-13-0001');
FOR I := STRLEN(Str1) DOWNTO 0 DO BEGIN
Pos := STRPOS(Str1,'-');
IF Pos <> 0 THEN
Count1 := Pos;
Str1 := COPYSTR(Str1,Pos+1,STRLEN(Str1));
I := Pos;
END;
Str1 := 'CHO-12-13-0001';
ActualStr := COPYSTR('MAN-12-13-0001',(STRLEN(Str1) -Count),STRLEN(Str1));
MESSAGE('%1',INSSTR(ActualStr,'''',1)); .........This for Excel.