baan.kmurali
26th March 2009, 13:09
Hi Everybody,
I am developing a preprinted report from copy of one standard report(tdind0459m000).
Herein I am facing some problem in layout alignment…Actually
now report layout is printing like this..
1.before.layout.1
2.before.layout.2
3.deail.1
4.detail.2
1st two headers are befor.field and other two is detail.
I want to print like this as balanced itemwise.
1.before.layout.1 – detail 1
2.before.layout.2 – detail 2
Can anybody help me regaing this issue?
Thanks & Regards,
Murali.
mark_h
26th March 2009, 22:29
Not familiar with your session or data. You might need to provide more details so that others can make a suggestion. The best I can recommend is get you data sorted first in the correct order you want. Then just play with the different type layouts and print expressions to turn them on and off as you print.
toolswizard
30th March 2009, 19:42
Use two print commands in your script with a counter. Set the counter to 1 and then send it to the report. Put a condition on Before_Header_1 and Detail_1 if the counter is 1 print. Increment the counter then send the line to the report again. Put a condition on Before_Header_2 and Detail 2 if the counter is 2 print.
As an alternative you could do this is a report script the same way, but when you increment the counter from 1 to 2, you may have to use the print again fuction.
baan.kmurali
31st March 2009, 13:54
Thank for your reply.i am not aware of that. if it possible that can you send me the sourcecode please.
baan.kmurali
31st March 2009, 14:58
i ll tell you some more details..
i have two before.layout and two detail layout.
here i want to print like following format...
1. before.tdind071.dino.1:
detail.1:
this is first box details...
2.before.tdind071.dino.2
detail.2
this is second one..
But.now these printing like below format..
1. before.tdind071.dino.1:
2.before.tdind071.dino.2
detail.1
detail.2
anybody can help me?
bdittmar
31st March 2009, 16:50
i ll tell you some more details..
i have two before.layout and two detail layout.
here i want to print like following format...
1. before.tdind071.dino.1:
detail.1:
this is first box details...
2.before.tdind071.dino.2
detail.2
this is second one..
But.now these printing like below format..
1. before.tdind071.dino.1:
2.before.tdind071.dino.2
detail.1
detail.2
anybody can help me?
Hello,
report flow :
before.x.1:
before.x.2:
detail.1:
detail.2
after.x.1:
after.x.2:
Details everytime is executed between the last before.field of input field order.
before field is changed, when the value changes and all details are printed according to their print expressions.
In your case the details are printed as long as the DINO changes.
Sorry for my english !
Regards
mark_h
31st March 2009, 18:16
Without knowing the data I would handle it with print expressions also - using k.of.data like in the BOM programs.
before.field.1 K.of.data=1
detail.1 k.of.data=1
before.field.2 k.of.data = 2
detail.2 k.of.data = 2
Then in the session script I would send the record with k.of.data equal to 1, then change the k.of.data to 2 and send the record again. Not sure about the defore fields, but I have used detail records only to do something like this.
baan.kmurali
1st April 2009, 14:08
Thanks For your reply..... Bernd i know the flow of report.
but i m asking that if it is possible to print following format..
before.tdind071.dino.1:
detail.1:
before.tdind071.dino.2
detail.2
Hi mark thanks for your replay
i ll try and get back to you...
Thanks & Regards,
Murali.
baan.kmurali
2nd April 2009, 14:14
HI Mark i tried it which is not coming properly.
eg:
Sales order item Quantity Central excise
693521 xxx 1 236
Purchase order item Quantity Central excise
23695 Xxx(Same item) 500 118000
I want to print Two statement at one report.
Can you tell me How should I proceed ?
Thanks & Regards,
Murali
mark_h
2nd April 2009, 16:10
In order to do what you want you have to get the data in the order you want to print and then you just have to play with the layouts turning them off and on. Look at print purchase orders and print bom reports to see how they use the layouts. That is the technique you need to use. Map out how you want the records or data to look, then map them to layouts - then turn the layouts on and off with the print expression.
baan.kmurali
6th April 2009, 13:42
Thanks for your reply i ll try and get back to U..
shanmukhi
14th April 2009, 09:28
Hi Kmurali,
According to ur requirement, u try this one too..
Keep the details of layout detail.1 in before.tdind071.dino.2 and keep counter to be incremented inorder to print all lines.
and your format should be lik this.
before.tdind071.dino.1:
before.tdind071.dino.2:
before.tdind071.dino.3:
detail.2
try this..i too have the same requirement and i got it .
All the best.
Regards.
baan.kmurali
20th April 2009, 14:03
thank you for your replay shanmukhi... can you explain me how to set increment the counter in before.field layout like detail layout(print all kines).
Thanks & Regards,
Murali.
loveubaan
22nd April 2009, 11:40
Plz refer to the attachment containign the sample script and report layout..
Concentrate on variable.. "detail.line" :cool:
- Sumeet