Go Premium for a chance to win a PS4. Enter to Win


Viewing SQL Reportng Services reports through Lotus Notes Views

Posted on 2011-03-23
Medium Priority
Last Modified: 2013-11-17
I am in the process of building some reports to view in Sharepoint but was thinking if there was a way to view these reports (or sharepoint) through a lotus notes database view?

I am basically trying to vew data trough our ERP SQL database but would lke to drive this through notes.

Thanks Richad
Question by:RichardH1976
  • 4
  • 2
LVL 10

Expert Comment

ID: 35213160
I don't know anyway or think it possible to pull SQL data into a notesview directly as views are specific to NotesData.

If designing a display page using a Form, page or Xpages to it would be possible to code an SQL query to pull the data in on the server and merge it with notes data from a view to make a suitable display.

If the data is static you could look at regular import or refresh of data into a Notes Database.


Author Comment

ID: 35219541
Thanks for your answer.  

Is there anyway for a Action button to generate a report from SQL Report services?  
LVL 46

Expert Comment

by:Sjef Bosman
ID: 35235922
What Notes/Domino releases do you have? Would there be a way to display the data using an embedded browser page, where the contents are obtained directly from the SQL server??
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.


Author Comment

ID: 35244692
This would be perfect.  Is there any information on the web on how to do this..

Designer 8 ....Domino Release 8.0  
LVL 46

Accepted Solution

Sjef Bosman earned 2000 total points
ID: 35244873
I think it should be possible to create a Page or a Form, and put some passthru HTML in it that retrieves the SQL server contents.

What's important: do you have a fixed URL to retrieve that info? Can you already get the info from the SQL server using a browser?
LVL 46

Expert Comment

by:Sjef Bosman
ID: 35244883
Or try @URLOpen("http://.....")
LVL 46

Expert Comment

by:Sjef Bosman
ID: 35305298
Solved? Great!

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Lack of Storage capacity is a common problem that exists in every field of life. Here we are taking the case of Lotus Notes Emails, as we all know that we are totally depend on e-communication i.e. Emails. This article is fully dedicated to resolvin…
Sometimes clients can lose connectivity with the Lotus Notes Domino Server, but there's not always an obvious answer as to why it happens.   Read this article to follow one of the first experiences I had with Lotus Notes on a client's machine, my…
Video by: ITPro.TV
In this episode Don builds upon the troubleshooting techniques by demonstrating how to properly monitor a vSphere deployment to detect problems before they occur. He begins the show using tools found within the vSphere suite as ends the show demonst…
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…
Suggested Courses
Course of the Month8 days, 17 hours left to enroll

877 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