how to print 2 non-continuous detail section in a report

[funnyguy]

hi,
my requirement is :
print a detail section 1 in a report and then i want to print some non repetitive data and then again i want to print detail section 2. both the detail sections derive data from single table?



e.g.

Test Report
Item Code Item
======== ======
item1 item1
item2 item2

narration1
narration 2

item qty item price
====== =======
1 100
2 150

narration3
narration4

please suggest howi can achieve this in baan4.

Thaking you in advance,
funnyguy

[bdittmar]

Originally Posted by funnyguy

hi,
my requirement is :
print a detail section 1 in a report and then i want to print some non repetitive data and then again i want to print detail section 2. both the detail sections derive data from single table?



e.g.

Test Report
Item Code Item
======== ======
item1 item1
item2 item2

narration1
narration 2

item qty item price
====== =======
1 100
2 150

narration3
narration4

please suggest howi can achieve this in baan4.

Thaking you in advance,
funnyguy

Hello,
maybe you can built 4 details:
detail.1:
item1 item1
item2 item2

detail.2:
before.layout:
if not isspace(naration1 or naration2) then
lattr.print = true
else
lattr.print = false
endif


narration1
narration2

detail.3:

1 100
2 150


detail.4:
before.layout:
if not isspace(naration3 or naration4) then
lattr.print = true
else
lattr.print = false
endif

narration3
narration4


Regards

[funnyguy]

hi,

Thanks for the suggestion.
I have already tried this but the problem is that the output looks something
like this

item1 item1
1 100
item2 item2
2 150
narration1
narration2

narration 3
narration4

it is printing detail sections in one place isstead of where i want it to be printed?

please suggest how i can overcome this???

funnyguy

[bdittmar]

Hello,
provide more details, please.

Report layout sections.

before.field.1
before.field.2
detail.1
detail.2
detail.3
.........
after.field.2
after.field.1

Sorting and recordset a.s.o.

Regards

[mark_h]

Well the way I have done something like this is to use a variable for the output expression. For example you have 4 detail layouts. Use op=1 for first layout, op=2 for second layout, etc. Then in the session script each time you do a rprt_send() you just have to set the output expression to the layout you want to print. What you can not do in my scenario is send all the data in one record(or one rprt_send() command) to the report.

[funnyguy]

hi,
i have solved the issue by using spool functions.

i have 1 query :
how to print a box in GUI format
when i am using spool function the box is drawn like this and not like the normal box function.

|------------------------------------------|
| |
|------------------------------------------|

are there any functions or ascii codes for this ???

Thanking you,
funnyguy

[Hitesh Shah]

Check session ttstpisotable for the ascii values of all box drawing characters.

[funnyguy]

Hi Hitesh,
Thanks a ton for the suggestion. It worked for me. Now my issue is completely resolved.

once again, thanks a ton,

funnyguy