Solved

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

Posted on 2007-03-27
1
364 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

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

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

Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
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
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

912 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now