Solved

Edit existing reports with report wizard SQL Server 2005 BI - not create new ones

Posted on 2007-03-27
1
366 Views
Last Modified: 2012-08-14
How do I access the report wizard for an EXISTING project using SQL SERVER 2005 REPORTING SERVICES. I like the wizard but I only seem to create NEW projects or reports with it. I would like to EDIT the projects I have already created with it. I know the answer is probably under my nose, but I just can't seem to find it...
0
Comment
Question by:ttinsley
1 Comment
 
LVL 18

Accepted Solution

by:
chrismc earned 250 total points
ID: 18806124
As far as I am aware, the wizard is only for creating.

You should also try to learn to create without the wizard after a few reports because the wizard is extremely limited. It's because of this limitation that I think it's impossible to use it on existing reports, because the report is highly likely to have something on it that the wizard can't handle.

It's not too difficult without.
Step 1 - create new report
Step 2 - create a dataset (you have a drag & drop tool but that too you will find limiting sooner or later - ideally learn SQL)
Step 3 - Create a layout - just drag a table on, then drag some fields on it. Now you have a report!

You want totals - add a group row, select what field it's grouped on, drag the field you want totalled into the group row, it will total automatically or simply drag fields into the footer row for grand totals.

You want it pretty? Select the header row, change the Background colour.

That's pretty much all the wizard does, there are a few more features I know, but learn to live without it and you'll become a much more accomplished report writer quicker.

Cheers
Chris
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

803 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question