Microsoft Dynamics NAV (Archived)

Report Line Printing

(0) Share

Report

Posted on by manish.yadav

1,893

0317.UU.png

Dear All,

I have a one rpt, in this report data are printing according to the line but I want to show it one FG item then it SFG item...U can see the screenshot.

Note: Printout me FG ke baad uska SFG wala item aana chaiye. Abhi jaisi line hai waisi hi print me bhi aa rehi hai. Isko thik karna hai.

Is there any possibility to set it.

Mnaish

*This post is locked for comments

I have the same question (0)

All responses (23)

Answers (4)

Verified answer

Binesh 7,885 on at

Like (1)

Report

Hello Manish,

You have to sort your report data "Sales Order Line Number"

So you will get one after one.

Was this reply helpful? Yes No
manish.yadav 1,893 on at

Like (0)

Report

kya iske liye koi code likhna padega...

in report coding section.

manish

Was this reply helpful? Yes No
Verified answer

Binesh 7,885 on at

Like (0)

Report

no need to write code,

in Report design RDLC, in that set sorting filter,

if you have anu doubt send your RDLC design screenshot.

Was this reply helpful? Yes No
manish.yadav 1,893 on at

Like (0)

Report

Very thanx for you fast reply.

i have added the sale order line no field in rpt then apply the sorting....

ab FG item ke neeche SFG wale item to aa gaye ...lakin sr no field problem kar reha hai.....

I have attached the screenshot.

manish

Was this reply helpful? Yes No
Binesh 7,885 on at

Like (0)

Report

Hello manish,

SN field you are fetching from record, in your record it stored.

If you want to see the serial no sequence order, then do one thing

In Dataitem OnafterGetRecord trigger put a integer variable and increment that variable by 1

something like:

SN := 1;

SN += 1;

and in RDLC assign this variable, so you will get 1, 2 ,3,.....n

Was this reply helpful? Yes No
manish.yadav 1,893 on at

Like (0)

Report

Serial no wala problem short nahi kar paa reha hoon...i have try with

SN := 1;

SN += 1;

isse her column me sirf 2 aa reha hai....

manish

Was this reply helpful? Yes No
Suggested answer

Binesh 7,885 on at

Like (0)

Report

Hello Manish,

You may be written in OnPreDataItem Trigger, Write in OnAfterGetRecord Trigger

See the bellow Screenshot

OnAfterGetRecord Trigger

RDLC Design

Result

Was this reply helpful? Yes No
manish.yadav 1,893 on at

Like (0)

Report

I have do the same as per your guidance....but still not solving the srno problems.

u can see the screenshots.

Regards,

Manish

Was this reply helpful? Yes No
Suggested answer

Binesh 7,885 on at

Like (0)

Report

Manish,

Check carefully,

see your screenshot

write the code where i marked.

Was this reply helpful? Yes No
manish.yadav 1,893 on at

Like (0)

Report

Dear Sir,

Now I have done the same, still the srno problem is not solved.

I have attached the new screenshots. Plz look in it.

manish

Was this reply helpful? Yes No