Viewing SQL Reportng Services reports through Lotus Notes Views

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
RichardH1976Asked:
Who is Participating?
 
Sjef BosmanGroupware ConsultantCommented:
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
 
doninjaCommented:
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
 
RichardH1976Author Commented:
Thanks for your answer.  

Is there anyway for a Action button to generate a report from SQL Report services?  
0
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
Sjef BosmanGroupware ConsultantCommented:
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
 
RichardH1976Author Commented:
This would be perfect.  Is there any information on the web on how to do this..

Designer 8 ....Domino Release 8.0  
0
 
Sjef BosmanGroupware ConsultantCommented:
Or try @URLOpen("http://.....")
0
 
Sjef BosmanGroupware ConsultantCommented:
Solved? Great!
0
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.

All Courses

From novice to tech pro — start learning today.