Baanboard.com

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

User login

Frontpage Sponsor

Main

Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
38%
Installation Wizard into new VRC
41%
Manual into existing VRC
3%
Manual into new VRC
19%
Total votes: 37

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 10th November 2017, 14:08
pralash pralash is offline
Member
 
Join Date: Feb 2017
Posts: 94
pralash is on a distinguished road
Baan: 9.0 - DB: SQL Server - OS: Windows 2012R2
Report customization
Baan: Other/Unknown
C/S: None/Unknown

Hi,

I'm new for LN Programming... I have created a basic report as shown in the attachment (output-report.png)... But I want to need some customization in the existing report.... That is how to add the additional check box option while we execute the report as shown in the attachments(2-exist.png)...

I also need to create some own checkbox similar to (2-exist.png) as shown in the attachment(1-customize.png)...

Finally I need to print the report according to the selection of checkbox by the end user... In order to perform this report operation, can I try this task as a single report or by create 3 individual report....

Can you please assist me that how to perform this task...
Thanks in advance,
Regards,
Pralash
Attached Images
File Type: png 1-Customize.PNG (20.3 KB, 11 views)
File Type: png 2-exist.PNG (24.1 KB, 12 views)
File Type: png output-report.PNG (9.1 KB, 11 views)
Reply With Quote
  #2  
Old 10th November 2017, 14:45
bhushanchanda's Avatar
bhushanchanda bhushanchanda is offline
Guru
 
Join Date: Sep 2012
Location: India
Posts: 2,305
bhushanchanda has a spectacular aura aboutbhushanchanda has a spectacular aura aboutbhushanchanda has a spectacular aura about
Baan: LN FP 1-9, 10.4, a little bit of Baan IV - DB: SQL Server 2008, Oracle - OS: Windows Server 2008 R2, Unix
Hi,

Pralash, you can do it in a single report. Create 3 different layouts for your report and add print conditions to them. The print condition can be the values of checkboxes. So, depending on the print condition of checkboxes, if print condition is true, that particular layout will be printed.
__________________
Regards,

Bhushan

Unless you try to do something beyond what you have already mastered, you will never grow!
Reply With Quote
  #3  
Old 10th November 2017, 15:03
pralash pralash is offline
Member
 
Join Date: Feb 2017
Posts: 94
pralash is on a distinguished road
Baan: 9.0 - DB: SQL Server - OS: Windows 2012R2
Hi,

I have no detailed knowledge about the reporting process in LN. So can you please explain in detail about how to add the checkbox in the session and also how to check the print condition of the check boxes...

Can you please give me sample script for perform this report customization process.
Thanks so much...
Regards,
Pralash
Reply With Quote
  #4  
Old 10th November 2017, 15:14
bhushanchanda's Avatar
bhushanchanda bhushanchanda is offline
Guru
 
Join Date: Sep 2012
Location: India
Posts: 2,305
bhushanchanda has a spectacular aura aboutbhushanchanda has a spectacular aura aboutbhushanchanda has a spectacular aura about
Baan: LN FP 1-9, 10.4, a little bit of Baan IV - DB: SQL Server 2008, Oracle - OS: Windows Server 2008 R2, Unix
Pralash,

That is a fast forward process of learning.

My Advice - Start by creating a session with a simple check box

How to do that?

1. Open the session form in DFE, and add a form field with some name like prnt.f with domain as tcyesno.
2. Declare this form field in your session as

extern domain tcyesno prnt.f

3. Compile the form and script.
4. Start the session, you will see the check box on the form.

This will be the first step towards developing your report.

I feel, it's always to start with the basics rather than starting to code complex things.

To use this form field in your report, you need to add it in your report input fields and then you can use it. But again, that is next part. So, start with the basics.
__________________
Regards,

Bhushan

Unless you try to do something beyond what you have already mastered, you will never grow!
Reply With Quote
  #5  
Old 10th November 2017, 15:23
pralash pralash is offline
Member
 
Join Date: Feb 2017
Posts: 94
pralash is on a distinguished road
Baan: 9.0 - DB: SQL Server - OS: Windows 2012R2
Thanks so much for your help Bhushan....
I'll try the steps as you told....
Regards,
Pralash
Reply With Quote
  #6  
Old 13th November 2017, 07:52
pralash pralash is offline
Member
 
Join Date: Feb 2017
Posts: 94
pralash is on a distinguished road
Baan: 9.0 - DB: SQL Server - OS: Windows 2012R2
Hello bhushanchanda,
I've created a checkbox in the report and also add the form field "tot.log.user" in the report input field... So i'm getting the result as in the attachment... Now I need to check the value of the check box in the report script and enable the corresponding layout....

Could you tell me please the script how to check the value of check box and enable the layout...

Regards,
Pralash
Attached Images
File Type: png output-checkbox.PNG (7.0 KB, 5 views)
Reply With Quote
Sponsored Links
  #7  
Old 13th November 2017, 10:12
bhushanchanda's Avatar
bhushanchanda bhushanchanda is offline
Guru
 
Join Date: Sep 2012
Location: India
Posts: 2,305
bhushanchanda has a spectacular aura aboutbhushanchanda has a spectacular aura aboutbhushanchanda has a spectacular aura about
Baan: LN FP 1-9, 10.4, a little bit of Baan IV - DB: SQL Server 2008, Oracle - OS: Windows Server 2008 R2, Unix
Good.

Now, in your report, double click on the layout you want to print based on the condition, in the Output Expression, you can give condition as tot.log.user = tcyesno.yes or tot.log.user = tcyesno.no

See the attached image for reference.
Attached Images
File Type: png Capture.PNG (3.7 KB, 4 views)
__________________
Regards,

Bhushan

Unless you try to do something beyond what you have already mastered, you will never grow!
Reply With Quote
  #8  
Old 13th November 2017, 11:13
pralash pralash is offline
Member
 
Join Date: Feb 2017
Posts: 94
pralash is on a distinguished road
Baan: 9.0 - DB: SQL Server - OS: Windows 2012R2
Hello bhushanchanda,

Thanks so much for your information....
I'll try the layout process as you told....
Regards,
Pralash
Reply With Quote
  #9  
Old 13th November 2017, 15:00
pralash pralash is offline
Member
 
Join Date: Feb 2017
Posts: 94
pralash is on a distinguished road
Baan: 9.0 - DB: SQL Server - OS: Windows 2012R2
Hello bhushanchanda,

I have created one more detail layout (detail.2)... I set the output expression for detail layout 2 as you already told tot.log.user=tcyesno.yes. ( as shown layout-2.png)

I got the result of detail.1 as shown in the attachment(res1.png) without clicking the checkbox. While I click the checkbox (res1.png), I got the result as shown in the attachment (res4.png)...

Hence while I execute the report by choosing the check box, the detail.1 and detail.2 are executed one by one.... But I want to execute only the detail.2 when I choose the checkbox... So how can I overcome the detail.1 output while detail.2 is printed..?

Can you please assist me how to overcome this issue? and tell me some sample script for handling "detail" section....
Regards,
Pralash
Attached Images
File Type: png layout-2.PNG (19.7 KB, 2 views)
File Type: png res1.PNG (15.9 KB, 3 views)
File Type: png res2.PNG (9.8 KB, 3 views)
File Type: png res3.PNG (10.2 KB, 3 views)
File Type: png res4.PNG (16.3 KB, 2 views)
Reply With Quote
  #10  
Old 13th November 2017, 15:53
bdittmar's Avatar
bdittmar bdittmar is offline
Guru
 
Join Date: Apr 2002
Location: Germany, 50.584097,8.544078
Posts: 1,646
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
use lattr.print

Hello,
Code:
on d.1 :

if Checkbox = tcyesno.yes then
lattr.print = false
else
lattr.print = true
endif

on d.2 :

if Checkbox = tcyesno.yes then
lattr.print = true
else
lattr.print = false
endif
or use a printexpression on Detail.1
Printexpression 1 means - print ever

on d.2 you use :
tot.log.user = tcyesno.yes
so use tot.log.user = tcyesno.no on D.1 !


Regards
__________________
//Bernd
Reply With Quote
  #11  
Old 13th November 2017, 16:01
bhushanchanda's Avatar
bhushanchanda bhushanchanda is offline
Guru
 
Join Date: Sep 2012
Location: India
Posts: 2,305
bhushanchanda has a spectacular aura aboutbhushanchanda has a spectacular aura aboutbhushanchanda has a spectacular aura about
Baan: LN FP 1-9, 10.4, a little bit of Baan IV - DB: SQL Server 2008, Oracle - OS: Windows Server 2008 R2, Unix
Pralash,

As I can see, you have given the Output expression to only Detail 2 layout. So, for Detail 1 layout, you can set expression as tot.log.user = tcyesno.no and it should work fine.
__________________
Regards,

Bhushan

Unless you try to do something beyond what you have already mastered, you will never grow!
Reply With Quote
  #12  
Old 14th November 2017, 08:40
pralash pralash is offline
Member
 
Join Date: Feb 2017
Posts: 94
pralash is on a distinguished road
Baan: 9.0 - DB: SQL Server - OS: Windows 2012R2
Thanks for your information...
It's working fine now....
Regards,
Pralash
Reply With Quote
  #13  
Old 14th November 2017, 08:41
pralash pralash is offline
Member
 
Join Date: Feb 2017
Posts: 94
pralash is on a distinguished road
Baan: 9.0 - DB: SQL Server - OS: Windows 2012R2
Thanks for your information....
I'll try as you told...
Regards,
Pralash
Reply With Quote
  #14  
Old 14th November 2017, 10:00
pralash pralash is offline
Member
 
Join Date: Feb 2017
Posts: 94
pralash is on a distinguished road
Baan: 9.0 - DB: SQL Server - OS: Windows 2012R2
Hello bhushanchanda,

I have created a session which list out all users who are logged in the BaaN in a particular time period as shown in the attachment(count.png)...

As I I already discussed with you, When I click the "Total Logged User" check box(k2.png), it will provides the report details as follows.(for example)

Login Date Total Number of User logged in
11/9/2017 6
11/10/2017 8
11/11/2017 10

Can you please tell me how to write script for the above task?

Regards,
Pralash
Attached Images
File Type: png count.PNG (10.9 KB, 4 views)
File Type: png k2.PNG (9.0 KB, 3 views)
Reply With Quote
  #15  
Old 14th November 2017, 21:09
mark_h's Avatar
mark_h mark_h is offline
Guru
 
Join Date: Sep 2001
Location: Kentucky, USA
Posts: 6,923
mark_h will become famous soon enough
Baan: Baan 4C4 A&D1 - DB: Oracle - OS: Sun Solaris
In 4c4 you can just add another layout to accomplish this. What I would do is add a footer layout and put the field in that layout. Then click in the aggregate function and make it total. I would only print that layout when the print total flag was checked. So I would change output expression on it to check if the print total flag was yes(or checked). I would assume ln would be the same - but I have been wrong before on that.
__________________
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
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
Invoices printing issue-display last record with 2 lines tracylee Tools Development 7 20th October 2017 11:51
Report Customization ailisee Tools Development 5 7th November 2011 13:11
Why LN6 do not allow customization report for tdsls4401m000 & tdpur4401m000? brad997 Tools Development 10 9th June 2005 14:32
solving recursion problems rmarles Tools Development 2 25th January 2005 22:23


All times are GMT +2. The time now is 21:11.


©2001-2017 - Baanboard.com - Baanforums.com