Improve company productivity with a Business Account.Sign Up

x
?
Solved

Viewing SQL Reportng Services reports through Lotus Notes Views

Posted on 2011-03-23
7
Medium Priority
?
480 Views
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
0
Comment
Question by:RichardH1976
  • 4
  • 2
7 Comments
 
LVL 10

Expert Comment

by:doninja
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.



0
 

Author Comment

by:RichardH1976
ID: 35219541
Thanks for your answer.  

Is there anyway for a Action button to generate a report from SQL Report services?  
0
 
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??
0
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

 

Author Comment

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

Designer 8 ....Domino Release 8.0  
0
 
LVL 46

Accepted Solution

by:
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?
0
 
LVL 46

Expert Comment

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

Expert Comment

by:Sjef Bosman
ID: 35305298
Solved? Great!
0

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

For Desktop Techs: How to retain a user's Notes configuration data when swapping out the end user's computer. (Assuming that you are not upgrading to a completely different version of Notes client) All you need to do is: 1) install Notes o…
You’ve got a lotus Domino web server, and you have been told that “leverage browser caching” is a must do. This means that we have to tell the browser everywhere in the web to use cache. In other words, we set (and send) an expiration date in the HT…
If you are looking for an automated solution for backup single or multiple Office 365 user mailboxes to Outlook data file, then you can use Kernel Office 365 Backup & Restore tool. Go through the video to check out the steps to backup single or mult…
When you have multiple client accounts to manage, it often feels like there aren’t enough hours in the day. With too many applications to juggle, you can’t focus on your clients, much less your growing to-do list. But that doesn’t have to be the cas…

595 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