User login
|
|
Frontpage Sponsor
|
|
Poll
|
How big is your Baan-DB (just Data AND Indexes) 0 - 200 GB 15% 200 - 500 GB 28% 500 - 800 GB 4% 800 - 1200 GB 9% 1200 - 1500 GB 9% 1500 - 2000 GB 13% > 2000 GB 22% Total votes: 46 |
Baanboard at LinkedIn
|

|
|
|
 |

10th July 2010, 08:18
|
Junior Member
|
|
Join Date: Jan 2010
Posts: 8
|
|
Baan: baan4 -
DB: oracle -
OS: unix
|
how to print 2 non-continuous detail section in a report
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
|

10th July 2010, 14:46
|
 |
Guru
|
|
Join Date: Apr 2002
Location: Germany, 50.584097,8.544078
Posts: 1,753
|
|
Baan: 2.2/3.1/4c4/LN6.1 FP6/FP9/HiDox -
DB: tbase, ms-sql7, oracle10gV1, 11g -
OS: HP-UX, W2K3, SLES
|
Just a thought !
Quote:
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
__________________
//Bernd
|

11th July 2010, 08:50
|
Junior Member
|
|
Join Date: Jan 2010
Posts: 8
|
|
Baan: baan4 -
DB: oracle -
OS: unix
|
how to print 2 details sections non-continuously
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
|

11th July 2010, 11:34
|
 |
Guru
|
|
Join Date: Apr 2002
Location: Germany, 50.584097,8.544078
Posts: 1,753
|
|
Baan: 2.2/3.1/4c4/LN6.1 FP6/FP9/HiDox -
DB: tbase, ms-sql7, oracle10gV1, 11g -
OS: HP-UX, W2K3, SLES
|
Need more details
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
__________________
//Bernd
|

12th July 2010, 16:04
|
 |
Guru
|
|
Join Date: Sep 2001
Location: Kentucky, USA
Posts: 7,194
|
|
Baan: Baan 4C4 A&D1 -
DB: Oracle -
OS: Sun Solaris
|
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.
__________________
Mark
GO Cards!
My latest mantra - make sure you have latest stpapi patches and the latest session object. If on LN then please explore the option of using DAL2 functionality.
Shared Solutions for Baan systems provided free by Baan Board.
Play the Google game and help Baanboard get better rankings. Do your part. Click here to find how.
|

15th July 2010, 07:48
|
Junior Member
|
|
Join Date: Jan 2010
Posts: 8
|
|
Baan: baan4 -
DB: oracle -
OS: unix
|
how to print 2 detail sections non continuously
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
|

15th July 2010, 19:16
|
 |
Guru
|
|
Join Date: Nov 2001
Location: Mumbai,India
Posts: 1,853
|
|
Baan: triton,Baan IVc4 , ERP Ln -
DB: Oracle/Bisam/SQL 2000/SQL 2005 -
OS: Sun Solaris/Windows 2003
|
ttstpisotable
Check session ttstpisotable for the ascii values of all box drawing characters.
|

16th July 2010, 12:59
|
Junior Member
|
|
Join Date: Jan 2010
Posts: 8
|
|
Baan: baan4 -
DB: oracle -
OS: unix
|
how to print 2 non continuous detail sections
Hi Hitesh,
Thanks a ton for the suggestion. It worked for me. Now my issue is completely resolved.
once again, thanks a ton,
funnyguy
|
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
|
|
Thread Tools |
|
Display Modes |
Linear Mode
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
|