Solved

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

Posted on 2004-04-26
18
220 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
Industry Leaders: 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 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

Enroll in June's Course of the Month

June’s Course of the Month is now available! Experts Exchange’s Premium Members, Team Accounts, and Qualified Experts have access to a complimentary course each month as part of their membership—an extra way to sharpen your skills and increase training.

Question has a verified solution.

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

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…
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…
If you're a developer or IT admin, you’re probably tasked with managing multiple websites, servers, applications, and levels of security on a daily basis. While this can be extremely time consuming, it can also be frustrating when systems aren't wor…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

691 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