Listing a record more than once in a view

Posted on 2006-04-22
Last Modified: 2013-12-18
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 ?

Question by:Faraj1969
    LVL 18

    Accepted Solution

    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 ....
    LVL 43

    Assisted Solution

    by:Steve Knight
    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...
    LVL 18

    Expert Comment


    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

    LVL 43

    Expert Comment

    by:Steve Knight
    For some reason I've had a bout 5 "b"s' today.  Must be one of those days.  None of them warranted it :-(

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    This is an old article, please see an updated version of this article, located here:
    Notes Document Link used by IBM Notes is a link file which aids in the sharing of links to documents in email and webpages. The posts describe the importance and steps to create a Lotus Notes NDL file in brief.
    Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
    In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor ( If you're interested in additional methods for monitoring bandwidt…

    754 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

    Need Help in Real-Time?

    Connect with top rated Experts

    24 Experts available now in Live!

    Get 1:1 Help Now