Serial No. increnment issue in report (i.e Classic / RTC)

manisharma31 · **Posted:** Fri Apr 20, 2012 7:37 pm

I am trying to use the same, but the problem is the sr no. are not displayed correctly.

If there is one gap in the purchase line then the sr no. is not displayed correctly.

1 1001 Manual for Loudspeakers,Manual for Loudspeakers with

1 Stand for Loudspeakers LS-150

2 1002 Spike for LS-100

3 1003 Base speaker unit 15" 100W

I have tried many workarounds, but it does not work.

In india database there is a report id. 16593 which is an example of this issue..

clausl · **Posted:** Sat Apr 21, 2012 10:53 am

Love to help, but I don't have access to the India Database.

So you need to be more specific on what the issue is for us to help you.

/Claus Lundstrøm

manisharma31 · **Posted:** Sat Apr 21, 2012 6:46 pm

The sr no. are not displayed correctly in a purchase order report, below is the example of how the report is displayed.

Sr No. Item Code Item Desc
1 1001 Manual for Loudspeakers,Manual for Loudspeakers with
1 Stand for Loudspeakers LS-150
2 1002 Spike for LS-100
3 1003 Base speaker unit 15" 100W
with extened warranty.

If there we enter description in second line of the purchase order then there is issue of displaying the serial no.

I have tried many workarounds, but it does not work (i.e. Check Item Code for blank in 2nd line,try to hide the 2nd sr no. RTC)

vijay_g · **Posted:** Sat Apr 21, 2012 6:57 pm

You need to increment serial no. when SalesInvoiceLine."No." is not equal to blank.(this is as per report no.16593 on integer1 dataitem where serial no. have been increment).
Hope this help you..

manisharma31 · **Posted:** Mon Apr 23, 2012 7:59 am

Here is an good example of the excise invoice.
In the Posted Sales Invoice you can see that only 2 item are there & for 1st item the desc. is entered in line no. 10000,20000,30000 & 40000.
Where as for 2nd item there is only single desc.

In report the Sr No. is shown as 1,2,3,4,5 where as it should be shown as 1 & 2 only, cause the invoice is having only 2 items.

mohana_cse06 · **Posted:** Mon Apr 23, 2012 8:30 am

Try

Code: Select all

IF SalesInvoiceLine."No." <> '' THEN
  SNo := SNo + 1;

Belias · **Posted:** Mon Apr 23, 2012 9:57 am

mohana_cse06 wrote:

Try

Code: Select all

IF SalesInvoiceLine."No." <> '' THEN
  SNo := SNo + 1;

I don't know that report, but with this code, he will probably get something like

1
1
1
1
2

Isn't it? manish, IF this is not what you want, you can do:
a. use another variable to show the serial no. and clear the variable while looping the rows

Code: Select all

clear(SNoToShow);
IF (SalesInvoiceLine."No." <> '') AND (SalesInvoiceLine.type <> SalesInvoiceLine.type::" ") THEN BEGIN
  //I would add the condition on "type", too...in case they use extended texts.
  SNo := SNo + 1;
  SNoToShow := SNo;
END;

or (this is more funny), use the "hideduplicates" property of the rdlc report, on the textbox of serial no. (this must be done after applying mohana's code, obviously)...otherwise you won't have duplicates to remove :wink:

rhpnt · **Posted:** Mon Apr 23, 2012 12:31 pm

manisharma31 wrote:

I am trying to use the same, but the problem is the sr no. are not displayed correctly.

If there is one gap in the purchase line then the sr no. is not displayed correctly.

1 1001 Manual for Loudspeakers,Manual for Loudspeakers with

1 Stand for Loudspeakers LS-150

2 1002 Spike for LS-100

3 1003 Base speaker unit 15" 100W

I have tried many workarounds, but it does not work.

In india database there is a report id. 16593 which is an example of this issue..

Considering all your passed exams under your signature I'm amazed that this represents such a problem that you are forced to post it on this forum. Next time do please stick to NAV naming rules and write "Line No.".

manisharma31 · **Posted:** Mon Apr 23, 2012 2:17 pm

This forum is not to test anyone of what he has achived, rather than to help others of their problems.

Looks you have not read all the reply posted here.

rhpnt · **Posted:** Mon Apr 23, 2012 3:32 pm

manisharma31 wrote:

This forum is not to test anyone of what he has achived, rather than to help others of their problems.

I agree, untill you don't expect others (even MVP's) to do basic programming tasks for you!

manisharma31 wrote:

Looks you have not read all the reply posted here.

I read enough to know how you managed to pass those exams...

DenSter · **Posted:** Mon Apr 23, 2012 4:29 pm

Let's link these: http://dynamicsuser.net/forums/t/39704.aspx

vijay_g · **Posted:** Mon Apr 23, 2012 4:46 pm

manisharma31 · **Posted:** Mon Apr 23, 2012 6:49 pm

So you can surely help me out of the basic problem rhpnt then.

manisharma31 · **Posted:** Mon Apr 23, 2012 6:54 pm

@Belias

Hideduplicates is also not working, also tried with the visibility property also but no luck.

mohana_cse06 · **Posted:** Tue Apr 24, 2012 7:28 am

You can try something like

Code: Select all

SNoTxt := '';
IF SalesInvoiceLine."No." <> '' THEN BEGIN
  IF SNoTxt <> FORMAT(SNo) THEN BEGIN
    SNo := SNo + 1;
    SNoTxt := FORMAT(SNo);
  END;
END;

Where SNoTxt is a text type variable
Assign SNoTxt in SourceExp

mibuso.com

Serial No. increnment issue in report (i.e Classic / RTC)

Who is online