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

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...
ttinsleyAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

chrismcCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
DB Reporting Tools

From novice to tech pro — start learning today.