Solved

Creating a report using the view for the data in lotus notes

Posted on 2004-04-26
18
216 Views
Last Modified: 2013-12-18
how do I create a report in lotus with this kind of scenario.  I have a view with these fields

Billing ->Name of View

Account Name       Debit Account No.   Check No.      Amount     Bank Name     service fee
egm                       11111                       1111        5,00000         ABC                 7.00
egm                       11111                       2222        8,00000         XYZ                 7.00
egm                       11111                       3333       15,00000        123                  7.00  

what i want to do here when I highlight one record with the same debit acct no they will all appear in the form I created (Billing statment form) which would appear lke this

BILLING STTMT

Account name : egm
Account No.    : 11111

check no            amount        bank name        service fee      total fee  
 11111               5,0000             ABC                 7.00              7.00
 22222               8,0000             XYZ                 7.00               7.00
 33333              15,0000             123                 7.00               7.00
     
                                                           total number of checks : 3
                                                       total amount to be debited: 21.00


 thanks hope somebody can help me out
0
Comment
Question by:emem
  • 11
  • 7
18 Comments
 
LVL 19

Expert Comment

by:madheeswar
ID: 10917040
This can be done through an embedded view inserted in a form
0
 
LVL 19

Expert Comment

by:madheeswar
ID: 10917078
create one form.

from menu: create->Em,bedded element->view and select the view.

The first column in the view should be categorized with the account name.

Create one field and use @DbColumn to get all the first column values and enable auto refresh of the form and enable the field properties(refresh) name this field as key_k

And in the embedded view selectoin(single Category event), place this field name.(i.e., key_k)

And create two fields:
1) tchq_x, should be computed and text and have default formula:
FIELD key_k:=key_k;
@If(key_k="";"";@Elements(@DbLookup("":"Nocache";"";"(urview)";key_k;columnNo)))

2) tdebit_k, should be computed and text and default formula:
FIELD key_k:=key_k;
@If(@Elements(@DbLookup("":"Nocache";"";"(urview)";key_k;columnNohavingTOTALFee))=0;@Return(0);"");
avgage := @Sum(@TextToNumber(@DbLookup("":"Nocache";"";"(urview)";key_k;columnNohavingTOTALFee)));
@If(@IsError(avage);0;avgage)

Hope it helps.

0
 
LVL 19

Expert Comment

by:madheeswar
ID: 10917084
I did not tested it. But, the logic will be the same.

Just fine tune and use the code.

Best of luck.
0
Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

 

Author Comment

by:emem
ID: 10924026
thanks for the tips .....get back to you
0
 

Author Comment

by:emem
ID: 10935687
i tested this but it seems that it gives me a different output.  I only shows the first account name but if I select another account name from the view and click on generate billing statement action button it still shows the first account name. Is it better that I select according to Debit Account No.?

VIEW NAME: Billing
Account Name     Deposit Account   Debit Account No.   Check No.      Amount     Bank  fee
egm                       11111                       1111        5,00000         ABC                 7.00
                             11113                       1111        8,00000         XYZ                  7.00
                             11114                       1111       15,00000        123                  7.00  
ABC Company         22222                       2222       10,00000        ANZ                10.00
                             33333                       5555        12,0000         456                10.00
john doe                 55555                      85858       20,0000         bbb                  7.
           
OUTPUT IN BILLING STMT FORM SHLD BE LIKE THIS

FORM NAME: BILLING STTMT

Account name         : egm
Debit Account No.    : 11111

Deposit Acct No.   check no            amount        bank name        service fee      total fee  
  11111                  11111               5,0000             ABC                 7.00              7.00
  11113                  22222               8,0000             XYZ                 7.00               7.00
  11114                  33333              15,0000             123                 7.00               7.00
     
                                                           total number of checks : 3
                                                       total amount to be debited: 21.00
0
 
LVL 19

Accepted Solution

by:
madheeswar earned 150 total points
ID: 10935726
I have forgotten about debit account no:

create another field for debit no:
It will give unique Debit account no's:

Default formula is:

FIELD key_k:=key_k;
@If(key_k="";"";@Unique(@DbLookup("":"Nocache";"";"(urview)";key_k;columnNo)))

I did not got

i tested this but it seems that it gives me a different output

My solution is easy to implement and understandable.

Can u please send the database to madheeswar at vmoksha dot com

If the design in ND6, then change the nsf to ns4 and send it.

Mention all the forms and views to be used

0
 

Author Comment

by:emem
ID: 10935757
great I'll do this =) thanks
0
 

Author Comment

by:emem
ID: 10935996
I e-mailed it already you're a great help you know that

0
 

Author Comment

by:emem
ID: 10936641
where you able to get the database?
0
 
LVL 19

Expert Comment

by:madheeswar
ID: 10936670
I send to u long time
Did u received it or not?
0
 

Author Comment

by:emem
ID: 10937130
check on it
0
 

Author Comment

by:emem
ID: 10937153
got the mail but no attachment .....I just got your message that i have to close the question
0
 
LVL 19

Expert Comment

by:madheeswar
ID: 10937190
i have sent 2 messages.
first is attached and the second without attach
0
 

Author Comment

by:emem
ID: 10937216
i was able to receive the last one ...i hope you can send it again emoderes@hotmail.com and emoderes@yahoo.com......It will be greatly appreciated ......please you have been so helpful
0
 
LVL 19

Expert Comment

by:madheeswar
ID: 10937230
i am sending again. see it.
0
 

Author Comment

by:emem
ID: 10937245
checking on both e-mail accounts now
0
 

Author Comment

by:emem
ID: 10937289
i got it in my yahoo. account ......I can'r believe it but you are from heaven....can I get back to you as soon as I have check on it?? thanks thanks thanks GOd Bless
0
 

Author Comment

by:emem
ID: 10937290
i got it in my yahoo. account ......I can'r believe it but you are from heaven....can I get back to you as soon as I have check on it?? thanks thanks thanks GOd Bless
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Missing Rules 1 301
Lotus Notes mail can not display in send item after send out 9 341
Domino 8 run a specific agent on all nsf in a folder 9 57
DNS error assumed 8 60
IBM Notes offer Encryption feature using which the user can secure its NSF emails or entire database easily. In this section we will discuss about the process to Encrypt Incoming and Outgoing Mails in depth.
Article by: Rob
Notes 8.5 Archiving Steps and Tips This article covers setting up a Notes archive, and helps understand some of the menu choices making setting up and maintaining a Notes archive file easier.
In a recent question (https://www.experts-exchange.com/questions/28997919/Pagination-in-Adobe-Acrobat.html) here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …

832 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question