MichaelK
Guest
|
 Posted:
Wed Jan 19, 2005 5:11 am Post subject:
SharePoint Services -- Visual Studio 2003 -- SQL Report Serv |
|
|
We want to create a simple report based on a SharePoint list using the Report
Writer installed in Visual Studio by the SQL 2000 Report Server Installation
software.
Background:
We have installed Windows 2003 Server, SQL 2000, SQL Report Server, Windows
SharePoint Services and Visual Studio 2003 on a single server --- for
development and testing purposes. We configured the default SharePoint site
(http://localhost) to host some basic employee information. We have populated
the default Contacts and Events list’s with data. We added a new field in the
Events list – this is a ‘Lookup’ field (called Full Name) from the Contacts
list.
The report should use data from both lists --- the report should group
information based on the Company field found in the Contacts list, and then
sorted by the Full Name (the common reference) field. The report should
display fields from both lists.
We have the samples installed – Financial, CRM, OLAP and the samples from
the Report Server default install. We reviewed the sample reports and data
connections, but haven’t found any examples (that take us all the way) for
getting SharePoint lists data into a report created using Visual Studio.
The process for data connectivity to SharePoint in visual studio is
cumbersome. Can’t this be easier? Similar to that found in MS Access, or
Excel.
We understand how to create a Report Project and found information to leade
us towards data connectivity… We’ve established data connectivity in the
Visual Studio Report Project by adding a Windows.SharePoint REFERENCE.
Now that we have the reference in the report project, where do we go from
here? How do I tell Visual Studio the exact list that I want to use? Where do
I further refine the query for this list in Visual Studio? Getting to this
data is confusing… please help!!
We have created a lot of SharePoint lists and are our users want more
sophisticated reporting. They want to see information pulled together form
the multiple lists…. SQL Report server seems like a perfect fit, and after
service pack 2 is released, printing and SharePoint integration using Report
server will make it a nice user experience.
Is SQL Report Server a good fit for reporting on data found in SharePoint
lists?
I need to ramp up quickly and would like a head start… Does it make sense to
pay a consultant to develop several of these reports, using the tools above,
then have the consultant team me the tricks? How long should it take to
develop 4 reports based on SharePoint lists?
If this is something that you can help with, please contact me at
michael@effectivelink.com |
|
FAQ
Memberlist
Register
Profile
Log in to check your private messages
Log in