Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Using a view, based on a field's value, concatenating data from 2 separate documents

Posted on 2007-12-04
5
Medium Priority
?
191 Views
Last Modified: 2013-12-18
I current am in charge of maintaining an old Lotus Notes database.  My clients are looking to pull data into crystal reports (which the report is already finished).  However, when I use a view as the setup for crystal, I can't seem to get the information I'm looking for.  Example, this database tracks testing information for various product types.  With on product type, it has the possibility of 2 types of tests.  TestType is Regular or is Modified.  Now a Regular test with a ID# of 07125 has a Capacity of 115 or 230/208.  With the Modified with a ID# of 07125 it has a capacity of 115, or 230/230 or 208/208.  Now, what I would like to do is
1) combine the data from the Regular and Modified so capacities would be 115/115 for that ID# 07125
2) combine the data from the Modified so capacities would be 230/208 for that ID# 07125
Having the end result being single rows in the view instead of separated out (Regular 1st line, then Modified 2nd line for ID#07125 then Regular 3rd line, then Modified 4th line for ID#07126, and so on).  I'm fairly new to this environment, and would really appreciate any help on this topic.  Thank you!
0
Comment
Question by:mastro78
5 Comments
 
LVL 63

Expert Comment

by:SysExpert
ID: 20408817
It sounds like you need to modify the form selection, and possibly some of the columns.

PLease post that info here, for a standard and modified view, so that we can try to resolve this.


I hope this helps !


0
 
LVL 31

Expert Comment

by:qwaletee
ID: 20408986
Maybe I'm tired, but I have no clear idea what you are trying to do. Sounds like you have some very specific defintions of product and tetsing codes, and anyone not at your company/industry would not "get" this.
0
 

Author Comment

by:mastro78
ID: 20419954
How can I combine documents in a view based on TestType, if that would be easier?  Like @IF(TestType="Regular"; whatever I would put next.  Not sure it would be that easy, might involve LotusScript.  
0
 
LVL 2

Accepted Solution

by:
geedavid earned 1500 total points
ID: 20485411
My 'first glance' at this suggests that what you are looking for is a single document that contains the combined information. This document would appear in a view such that each row is one document and each column contains the pertinent data.

If this is true you could create an agent that loops through a collection of documents ("Regular"), based on a value such as a document  #07125 and create a new document. Once the new document is created you would loop through a second collection ("Modified") and when the value of a document finds a match you concatenate (append) the value of the second to the first.

I have typically used Lotuscript for chores such as this. There are 'right' ways and 'not so right' ways of doing this, especially with regard to collections, etc.

I have not used the formula language but I would be happy to suggest an approach if what I have already contributed is helpful.  

Good luck!
0
 

Author Comment

by:mastro78
ID: 20543370
Actually, that sounds like the perfect way to do this thank you for the help.  I've got it from here.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

Lack of Storage capacity is a common problem that exists in every field of life. Here we are taking the case of Lotus Notes Emails, as we all know that we are totally depend on e-communication i.e. Emails. This article is fully dedicated to resolvin…
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…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
When cloud platforms entered the scene, users and companies jumped on board to take advantage of the many benefits, like the ability to work and connect with company information from various locations. What many didn't foresee was the increased risk…
Suggested Courses

580 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