Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Designing Crystal Reports from .nsf databases

Designing Crystal Reports from .nsf databases

Designing Crystal Reports from .nsf databases

I would like some advice on how to design Crystal reports from data in Notes databases. I am not familiar with Notes or non-relational databases. For example, I understand there may be problems reporting on date fields as these are text fields and linking tables(is there a way around this?) Really need to understand the basics so that I can build reports and then perhaps move onto more technical designer stuff. Can anyone recommend a textbook, maybe online course?

RE: Designing Crystal Reports from .nsf databases

Think of a check book.  Each check contains the same information.  In a relational database you would create a table that contains all the fields on the check (check number, date, amount, pay to, memo) and you would store all the check information together.  Notes is a document based database.  Each check is created as its own document.  Each document contains the fields (check number, date, amount, pay to, memo).  The backend document (NotesDocument Class) is the raw document:

Check Number  1234
Date  12/01/2005
Amount  $500.25
Pay To  Me!!
Form Check

(Form is a Notes field that is present in all documents along with creation date, modified date, author, etc.)

In order to see this document you have to create a form to display it.  This form will contain the same fields as the document and the field values can be seen in the form.

So, in order to get information from a Notes Database, first you have to know which documents you want to review.  You can create a selection of documents that all have the same form name and then for each document in that "collection" search for some specific information.

Now, in response to your question - there are no tables to link, each document is it's own separate entity.  If you have access to the Notes mail environment, look at the INBOX - this is a NotesView, right click on any email in the INBOX, go to properties and then select the second tab in the box that opens.  This is a listing of all the fields contained in the document.

What kind of information are you trying to report on?


RE: Designing Crystal Reports from .nsf databases

I am reporting specifically from databases within Maximizer Enterprise for Notes. Does anyone have any experience of reporting from this?

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close