Is this a multi select parameter?

The database structure may be different in 2000 so you may have to poke around a bit. On the report server you have a database that contains pretty much...

In Report Manager, make a Linked Report.

On the report go to the Properties tab and click "Create a Linked Report"

This way only one report to deploy and maintain.

Ray K (1/24/2011)

Daniel Bowlin (1/24/2011)

That's kind like the sound my car made when I tried to start it this morning followed by a...

The Report Manager has roles to which you can assign users. Your permission for running the report and the reports access to the db should be separate. If...

Do you have the Oracle server Linked at all to the SQL server? If so you should be able to write the query using T-SQL and a 4 part...

That's kind like the sound my car made when I tried to start it this morning followed by a click click click. ...

shoulder

I have never thought of using count and count distinct in a having clause the way you do. Brilliant. Thanks.

I'll have a ham & cheese omelette and a shortstack of pancakes with butter and real maple syrup. MMMMmmmmm!

The administrators of Area 51 have decided that since everyone knows about them that they are going to hold an open house on April 1st in an effort to...

Ice.

This is really a formatting question. Go to Text Box Properties >> number tab, and uncheck the use 1000 separator.

Long weekend.:-)

caffeine