April 20, 2012 at 9:41 am
Can anyone help me please with this. I don't have a lot of experience with reporting services and I'm trying to find out with what I have what is the best way to create reports in Reporting Services.
- One of the things I'm doing is I have an Excel spreadsheet and I don't know if I can create a report in Visual Studio 2010 that imports this spreadsheet. Is that even possible? How do I do it?
- How do I even start Reporting Services in VS2010 or is it starting through another program? What do I click on to create one? New Project? and then what after that?
- I did some reading about Team Foundation server maybe being the best way to do what I'm trying to do but I have no idea how to set it up. When I'm in VS2010 it asks for a a url or server or something like that and I have no idea what to put in there. Do I need to create a Team Foundation Server and where can I do that at?
I just need help getting started with the basics of Reporting Services and what is the best method for doing what I'm trying to do.
April 20, 2012 at 12:17 pm
- One of the things I'm doing is I have an Excel spreadsheet and I don't know if I can create a report in Visual Studio 2010 that imports this spreadsheet. Is that even possible? How do I do it?
You should be able to set up an excel sheet as a data source, but not really import in the classic sense.
- How do I even start Reporting Services in VS2010 or is it starting through another program? What do I click on to create one? New Project? and then what after that?
Yes, New Project, Report Server Project. If you don't have one available you probably need to install SQL Server components (BIDS) on your machine. BIDS is a VS plug in for the MS SQL BI Stack. Visual Studio does not automatically come with BIDS.
April 20, 2012 at 12:28 pm
OK cool. Another question about the SQL Server Components. I don't know if I already have it because when I go to New Project under Database there SQL Server and then SQL Server 2005 Database Project, SQL Server 2005 Server Project and SQL Server 2005 Wizard. Would that be the BIDS component you are talking about and if so which one do I choose?
April 20, 2012 at 2:55 pm
BIDS adds several "templates" under the projects menu, here are the main ones:
Analysis Services Project
Report Server Project
Integration Services Project.
There are 3 or 4 others. You should see these under the New >> Projects dailog, the project type is Business Intelligence Projects. You probably need to get BIDS installed.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply