Solved

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

Posted on 2007-12-04
5
185 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
[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
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 500 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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Problem "Can you help me recover my changes?  I double-clicked the attachment, made changes, and then hit Save before closing it.  But when I try to re-open it, my changes are missing!"    Solution This solution opens the Outlook Secure Temp Fold…
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…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…
This video shows how to use Hyena, from SystemTools Software, to update 100 user accounts from an external text file. View in 1080p for best video quality.

738 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