Solved

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

Posted on 2007-03-27
1
372 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

Question has a verified solution.

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

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
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
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

635 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