Hi
Hopefully somebody can point me in the right direction.
I have been asked to look into connecting SQL Server to a Notes database and then generating reports from SQL Server.
Can anybody point me in the right direction for further resources?
Thank you
J
Subject: So Many ways to do this
There are so many ways to do this, most of which are very easy…
The question to start with is: do you want to bring the data to Lotus Notes then create your report or create your report with the data in SQL?
You can buy Crystal Reports
or you can hand write the code to get the data yourself (I recommend Java if this is your choice)
or
You can get Lotus LEI to pull in the data from SQL to Lotus Notes then use IntelliPrint to create the report
or
You can write the code to get the data on demand from SQL then generate your report from there
So many ways to do this, you need to pick the one that best meets your needs
Should you need additional help, feel free to contact me (mmarcavage@andersontechs.com)
Subject: Thank you…
Thank you for your reply.
At the moment the data is sitting in a Notes database, but we have a business requirement to create some pretty reports. I can code to get basic “flat” reports, but something a bit more whizzy is expected. It was mentioned that using SQL Server as a back-end would give that bit more flexibilty.
J
Subject: No
SQL will not offer you more flexibilityit will just add extra load on your report creation.
If the data is already in Lotus Notes as stated
then look at IntelliPrint.
It will not only allow you to create pretty reports but it will also empower the users to be able to do the same