Solved

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

Posted on 2004-04-26
18
214 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
 

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
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Lotus Notes Mail Database issues 2 898
Event in Notes Form after open and visible 10 217
Lotus Domino 9 relay to Office 365 Exchange Online 5 87
IBM Lotus Notes Rules not working 5 109
For users on the Lotus Notes 8 Standard client, this article provides information on checking the Java Heap size and adjusting it to half of your system RAM in attempt to get the Lotus Notes 8.x Standard client to run faster.  I've had to exercise t…
Problem "Can you help me recover my changes?  I double-clicked the attachment, made changes, and then hit Save before closing it.  But when I try to re-open it, my changes are missing!"    Solution This solution opens the Outlook Secure Temp Fold…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.
A company’s greatest vulnerability is their email. CEO fraud, ransomware and spear phishing attacks are the no1 threat to a company’s security. Cybercrime is responsible for the largest loss of money to companies today with losses projected to r…

919 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now