Solved

Viewing SQL Reportng Services reports through Lotus Notes Views

Posted on 2011-03-23
7
459 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
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 

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 500 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
How to add a username for multiple users in Lotus 6 104
Migration: Lotus Notes to Exchange 2013 10 325
Add a cc field to email code 3 103
Bulk lotus notes account creation 3 74
I thought it will be a good idea to make a post as it will help in case someone else faces these issues. I trust this gives an idea how each entry in Notes.ini can mean a lot for the Domino Server to be functioning properly. This article discusses t…
For beginners of Lotus Notes user this is important to know about the types of files and their location supported by IBM Notes. Mostly users are unaware about how many file types are created and what their usages are. This Article is fully dedicated…
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …

895 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

15 Experts available now in Live!

Get 1:1 Help Now