Baanboard.com

Go Back   Baanboard.com > Forum > Baan Quick Support: Functional & Technical > Tools Development

User login

Frontpage Sponsor

Main

Google search


Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
33%
Installation Wizard into new VRC
39%
Manual into existing VRC
6%
Manual into new VRC
22%
Total votes: 49

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 10th July 2010, 07:18
funnyguy funnyguy is offline
Junior Member
 
Join Date: Jan 2010
Posts: 8
funnyguy is on a distinguished road
Baan: baan4 - DB: oracle - OS: unix
Exclamation how to print 2 non-continuous detail section in a report
Baan: Baan IVc4
C/S: Both

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
Reply With Quote
  #2  
Old 10th July 2010, 13:46
bdittmar's Avatar
bdittmar bdittmar is offline
Guru
 
Join Date: Apr 2002
Location: Germany, 50.584097,8.544078
Posts: 1,720
bdittmar will become famous soon enough
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 View Post
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
Reply With Quote
  #3  
Old 11th July 2010, 07:50
funnyguy funnyguy is offline
Junior Member
 
Join Date: Jan 2010
Posts: 8
funnyguy is on a distinguished road
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
Reply With Quote
  #4  
Old 11th July 2010, 10:34
bdittmar's Avatar
bdittmar bdittmar is offline
Guru
 
Join Date: Apr 2002
Location: Germany, 50.584097,8.544078
Posts: 1,720
bdittmar will become famous soon enough
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
Reply With Quote
  #5  
Old 12th July 2010, 15:04
mark_h's Avatar
mark_h mark_h is offline
Guru
 
Join Date: Sep 2001
Location: Kentucky, USA
Posts: 7,109
mark_h will become famous soon enough
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.
Reply With Quote
  #6  
Old 15th July 2010, 06:48
funnyguy funnyguy is offline
Junior Member
 
Join Date: Jan 2010
Posts: 8
funnyguy is on a distinguished road
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
Reply With Quote
Sponsored Links
  #7  
Old 15th July 2010, 18:16
Hitesh Shah's Avatar
Hitesh Shah Hitesh Shah is offline
Guru
 
Join Date: Nov 2001
Location: Mumbai,India
Posts: 1,853
Hitesh Shah is on a distinguished road
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.
Reply With Quote
  #8  
Old 16th July 2010, 11:59
funnyguy funnyguy is offline
Junior Member
 
Join Date: Jan 2010
Posts: 8
funnyguy is on a distinguished road
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
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
print 2nd report from 1st report script cmandal Tools Development 6 14th October 2012 23:56
report print condition Elrodyn Tools Development 3 18th March 2009 10:13
solving recursion problems rmarles Tools Development 2 25th January 2005 21:23
cannot resize detail section on report Haggis Tools Development 2 4th March 2003 02:36


All times are GMT +2. The time now is 03:06.


©2001-2018 - Baanboard.com - Baanforums.com