Notes and connecting with Crystal

suemon · Sep 12, 2005

I have created a new view in my notes database and am trying to access it via crystal reports in creating a new connection. The view is not visible in the database expert dialog box. Can anyone tell me why? this is the first time I've had a problem and am probably missing something really elementary.

pmonett · Sep 13, 2005

Is your new view a private view ? There may be an issue with that.

Pascal.

suemon · Sep 13, 2005

No. should have mentioned that. Definitely not private. In fact copied it from an existing standard view and made alterations.

pmonett · Sep 14, 2005

I suppose the existing view is accessible via Crystal ?

Pascal.

pmonett · Sep 14, 2005

Arrgghh !
I mean the one you used to make a copy of, that one is "visible" by Crystal Reports, right ?

Pascal.

suemon · Sep 16, 2005

Yes it is

pmonett · Sep 16, 2005

Okay, so it's not a view type issue, nor a view access issue.
Is the first column sorted ?
And is there a Default View in the database design ?

Pascal.

suemon · Sep 16, 2005

Hey Pascal,

Thanks for sticking with me on this.

Yes the first column is actually a modified date.
@Date(@Modified)
and it is categorized and sorted. But this is true of the default view as well so that can't be the difference.

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Notes and connecting with Crystal

suemon

IS-IT--Management

pmonett

Programmer

suemon

IS-IT--Management

pmonett

Programmer

pmonett

Programmer

suemon

IS-IT--Management

pmonett

Programmer

suemon

IS-IT--Management

Similar threads

Part and Inventory Search

Sponsor