• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 478
  • Last Modified:

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
0
RichardH1976
Asked:
RichardH1976
  • 4
  • 2
1 Solution
 
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
 
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
Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

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

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.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now