Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Interfacing database engines

  Asked By: Christina    Date: Nov 26    Category: Sharepoint    Views: 1280

I bought Accessbooks for Quickbooks
last week (we use quickbooks to run our little company). It's a little
add-on utility that sends all my QB's data real
time to our SQL 2000 Server engine. I use 2004 pro (5-user) and I want to
roughly 120 memorized reports to SQL and then post each of them on
Sharepoint 2.0 webpages so that they are live on our sharepoint site. Has
anyone ever done
anything like this before and can anyone assist me in getting it going? Has
anyone else interfaced other business process software and filtered out
reports to show on user specific pages?



3 Answers Found

Answer #1    Answered By: Gobinda Navalagi     Answered On: Nov 26

While I haven't done exactly what you are looking for I've been using
the Northwind sample database  that comes with MS SQL 2000 Server and
FrontPage 2003 data  Views to build high sophisticated
filtered/sorted/grouped views of the data within a view minutes.

You might want to look at MSDN to find some more info on FrontPage
2003 Data Views. There is at least one article but I don't remember
the link offhand

Answer #2    Answered By: Rose Silva     Answered On: Nov 26

I got the fp 2003 book from microsoft, I instinctively tried messing around
with data  views, but all i got on the actual pages were hyperlinks to the
data, not the actual data itself.... I'll read some more about over the next
few days.

Answer #3    Answered By: Maegan Ellison     Answered On: Nov 26

Here's a screen snapshot how the results looked for me:


Didn't find what you were looking for? Find more on Interfacing database engines Or get search suggestion and latest updates.