Reports

prashanth0027 · 2012-07-19

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 · 2012-07-19

Have you tried something that didn't work?

prashanth0027 · 2012-07-19

no .please provide me the code as soon as possible

sendit2jason · 2012-07-19

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 · 2012-07-19

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 · 2012-07-19

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

mohana_cse06 · 2012-07-19

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 · 2012-07-19

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 · 2012-07-19

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

regards

Prashanth

Savatage · 2012-07-19

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 · 2012-07-22

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.

Howdy, Stranger!

Quick Links

Categories

Reports

Comments