November 23, 2010 at 9:52 am
I have created my own SQL views under my database (using SQL 2005 Stnd). I would like to create reports using these views. What are the steps I need to follow in order to so? I know I'll need Visual Studio I just don't know how or what to do to create my report using a view (for example dbo.vMyView).
November 23, 2010 at 10:45 am
How will you be creating the reports, SSIS? Crystal? some other web or client application?
Basically when you create the report using most reporting tools, at some point you need to put in your query to retrieve the data from your database.
You would add
Select col1, col2, col3 etc.
FROM dbo.vMyView
WHERE ...
If this really is the first time you're attempting to write a report in SSRs, I'd suggest takign a look at the walkthroughs on microsoft's site as well as one of the SQL Server Reporting Services Step by Step books.
They do a pretty good job of breaking it down so that you can understand what is available and how to do it.
-Luke.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply