Solved

Domino 6.5 & Crystal Reports 11 Integration

Posted on 2006-06-22
12
668 Views
Last Modified: 2013-12-18
Hello EE'ers,

Looking at integrating Lotus Domino 6.5 with Crystal Reports 11.  Not web based - just using Lotus Notes client...

Thought all my prayers were answered when I found a doc on Business Objects website...
Downloaded the Crystal Reports "Notes Report Designer Component Integration Example" from
http://support.businessobjects.com/samples/lotus_lst.asp

But I think it is not current for Crystal 11 :(    Awaiting a response from Business Objects on this.  ( It is referencing runtimes in the doc that do not exist anywhere on my test pc after the install ).

Has anyone got any samples or tutorials on achieving Lotus Notes Client 5 and above  Integration with Crystal 11 preferably ( or something based on something newer that Crystal 8?)

Broad
0
Comment
Question by:BroadAustralia
  • 4
  • 4
  • 2
  • +1
12 Comments
 
LVL 1

Author Comment

by:BroadAustralia
ID: 16965591
OK the files required for the integration do not ship with Crystal..  Downloaded them from
http://www.globalip.com/error/error.asp

(from page)
The link below downloads the Crystal Report Viewer dll. Please place in your Windows System32 folder. You will need to register the dll. To register the dll, look for the regsvr32.exe file in your Windows System32 folder. Drag the icon for the crviewer.dll on top of the icon for regsvr32.exe. This will run the registration process. You should receive a message that the registration succeeded.

Download Crystal Viewer dll ("crviewer.dll") (0.7 megabytes)

Download Crystal Reports craxdrt.dll ("craxdrt.dll") (5.2 megabytes)

Now I'm up and running!  

Broad.
0
 
LVL 63

Expert Comment

by:SysExpert
ID: 16968217
Good to know that the technology exists.

Thanks for the info !

0
 
LVL 46

Expert Comment

by:Sjef Bosman
ID: 16969514
Also looking forward to the match Soccaroos - Lions?  ;)
0
 
LVL 1

Author Comment

by:BroadAustralia
ID: 16980495
Yes Sjef !! Tonight is the big game for us V Italy!   I thought the lions had Portugal this morning esp. when they were down to ten men... bad luck..   : (

SysExpert I have some code around that more fully integrates with Crystal.. ie. a subform that has different parameters based on the report + all "parameters" for running the report ie. sales person, outcome etc. are populated into drop down boxes on subform allowing you to a. choose date range.. b. select saleperson, c. choose outcome or leave blank for all....

I am soon to disect this code and try to get it up and running with crystal 11 ( was based on crystal 9 ).  If you find it handy should I post?

Broad.
0
 
LVL 63

Expert Comment

by:SysExpert
ID: 17002253
Definitely. As soon as you have the bugs out of it.

I collect bits and pieces, that eventually alway come in handy.

Thanks !
0
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 
LVL 46

Expert Comment

by:Sjef Bosman
ID: 17002534
It's sad... Australia gone too, not enough tricks up their pouches.

Anyway, our local team (France) managed to win, which is good for the morale. And for the egoes :-))
0
 
LVL 1

Author Comment

by:BroadAustralia
ID: 17040346
Hi SysExpert,
Have changed direction, Crystal has come along way since the intergration side of things was developed.  ( 3 version number u would hope so ;)

Crystal 11 is the way to go for us -- scheduled reports accessible via your browser - retrieves parameters from Notes on the fly for reporting.  Exactly what we needed.

Sjef!  Yes it was sad to see Australia out like that..  Good luck tomorrow V Portugal - the Aussies always back the underdog - we are on opposite sides of the fence ! GO PORTUGAL !  ; )

Broad.
0
 
LVL 46

Expert Comment

by:Sjef Bosman
ID: 17040610
Grrrrrr! Allez les Bleus!
0
 
LVL 46

Expert Comment

by:Sjef Bosman
ID: 17074927
Whoah, Zidane, wtf did you do?? :'(

No problem with PAQ/refund
0
 
LVL 1

Author Comment

by:BroadAustralia
ID: 17077715
I know!!  I couldn't believe it! why? why NOW?  Hmm. Sad end to great career.  I guess it will come out in the press what happened ( have u tried google news alerts??  good stuff ! )

What a shame, on a highpoint it was great the referee allowed to game to flow though..

Broad.
0
 
LVL 5

Accepted Solution

by:
Netminder earned 0 total points
ID: 17118181
Closed, 500 points refunded.
Netminder
Site Admin
0

Featured Post

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

For users on the Lotus Notes 8 Standard client, this article provides information on checking the Java Heap size and adjusting it to half of your system RAM in attempt to get the Lotus Notes 8.x Standard client to run faster.  I've had to exercise t…
This is an old article, please see an updated version of this article, located here: http://www.experts-exchange.com/articles/23619/Notes-8-5x-Windows-7-Notes-info-and-tips.html
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…

708 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

9 Experts available now in Live!

Get 1:1 Help Now