Listing a record more than once in a view

Hey all,

I'm trying to list some records more than once in Crystal reports, so I created 2 views in Lotus Notes database, each view lists some records. Now I'm creating another view that compines the first 2 views. Is it possible for the SELECT statement to select from a VIEW instead of a FORM ?

Faraj1969System AdministratorAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Not quite following.. why couldn't you write the select statement in the third view to do what you want?    If viewA is: Select form="A", and viewB is: Select form="B", then viewC is Select ((Form="A")|(Form="B")) & !@isAvailable($Conflicts) & deleteme="".  It's all how you nest the commands.

Otherwise, the answer is no with regard to "SELECT view="ABC"."  You could, however, use an agent to step throught and  select documents (getalldocumentsbykey) and put them into a folder that you can read with Crystal.

The other thought that since views translate as tables, you can just as easily write a SQL query in Crystal that does what you want using inner or outerjoins and a good where statements...

SELECT a1, a2, a3, b1,b2,b3 from a  INNER JOIN b on a.a1 = b.b1 where ....

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Steve KnightIT ConsultancyCommented:
And if you want the same Notes documents to appear more than once in the Notes view (and therefore the Crystal report based on the view presumably) then just make a suitable column in the view multi-value and categorise by it or mark it as "display mutliple values as seperate" and you will get more than one line showing.  Post your select statements for each original view if you want them looked at...

I'm sorry, did dragon-it or I leave something out of our answers?  Please let us know what we might have missed for the grade to be a B

Steve KnightIT ConsultancyCommented:
For some reason I've had a bout 5 "b"s' today.  Must be one of those days.  None of them warranted it :-(
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Lotus IBM

From novice to tech pro — start learning today.

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.