Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jmaghen
Starting Member
1 Post |
 Posted - 2009-05-03 : 22:01:05
|
 So I've been playing around for over 10 days and reading different tutorials about MS access, mySQL, and MS SQL server to no avail. I've asked everywhere and nobody have been able to answer and from my research it seems the SQL users are the most advance so I am hoping I may finally get the answer I need here.I work for an investment company and we use sharepoint. Trying to add a webpart to sharepoint that has access to the database I have made in excel of investor companies and the range in which they will be interested in investing in another company, like a prequalification or minimum or maximum in the case of some fields. For example, I want to have a query with many drop down bars or boxes with the fields of my database and when I want to make a query search I can pick >$4 million, california and new york... or all, for example and then it will give me all the companies in my database that will invest more than $4 million and in a CA or NY company. Although, I will have more fields so I can narrow results down. I think I have come to the conclusion that Sharepoint can't do this, but I want to make sure and if it can't does anyone know what type of software I would need. Is it access or SLQ and if so what exactly is the term of what I am looking to do? I was hoping I create the program through SQL and use Sharepoint as the shell if possible.Thank you so much in advance for any response  |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-05-07 : 02:09:19
|
Without seeing your data, it's nearly impossible for us to help.
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
jzurbo77
Starting Member
21 Posts |
Posted - 2009-05-12 : 12:13:29
|
| Did you consider using MS SQL Reporting Services (SSRS)? It will take you just few minutes to put together a report like you have described... And, if you want, you can use SharePoint as a shell to get to your reports or use SSRS's own web-based user interface to run reports.HTH |
|
|
|
|
|
|
|
|
Database with query, last place to turn to