Solved

Viewing SQL Reportng Services reports through Lotus Notes Views

Posted on 2011-03-23
7
463 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
Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

 

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

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…
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…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

772 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