• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 378
  • Last Modified:

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...
1 Solution
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.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now