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

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
ememAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
madheeswarConnect With a Mentor Commented:
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
 
madheeswarCommented:
This can be done through an embedded view inserted in a form
0
 
madheeswarCommented:
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
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
madheeswarCommented:
I did not tested it. But, the logic will be the same.

Just fine tune and use the code.

Best of luck.
0
 
ememAuthor Commented:
thanks for the tips .....get back to you
0
 
ememAuthor Commented:
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
 
ememAuthor Commented:
great I'll do this =) thanks
0
 
ememAuthor Commented:
I e-mailed it already you're a great help you know that

0
 
ememAuthor Commented:
where you able to get the database?
0
 
madheeswarCommented:
I send to u long time
Did u received it or not?
0
 
ememAuthor Commented:
check on it
0
 
ememAuthor Commented:
got the mail but no attachment .....I just got your message that i have to close the question
0
 
madheeswarCommented:
i have sent 2 messages.
first is attached and the second without attach
0
 
ememAuthor Commented:
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
 
madheeswarCommented:
i am sending again. see it.
0
 
ememAuthor Commented:
checking on both e-mail accounts now
0
 
ememAuthor Commented:
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
 
ememAuthor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.