Go Premium for a chance to win a PS4. Enter to Win

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
?
189 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

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

This is an old article, please see an updated version of this article, located here: http://www.experts-exchange.com/articles/23619/Notes-8-5x-Windows-7-Notes-info-and-tips.html
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…
Integration Management Part 2
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…
Suggested Courses

886 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