Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

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

Posted on 2004-04-26
18
Medium Priority
?
228 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

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 600 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

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

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

I thought it will be a good idea to make a post as it will help in case someone else faces these issues. I trust this gives an idea how each entry in Notes.ini can mean a lot for the Domino Server to be functioning properly. This article discusses t…
Sometimes clients can lose connectivity with the Lotus Notes Domino Server, but there's not always an obvious answer as to why it happens.   Read this article to follow one of the first experiences I had with Lotus Notes on a client's machine, my…
Want to learn how to record your desktop screen without having to use an outside camera. Click on this video and learn how to use the cool google extension called "Screencastify"! Step 1: Open a new google tab Step 2: Go to the left hand upper corn…
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…

610 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