I agree that you cannot just cobble this together in a few weeks.. you really need to plan it out a bit and make some careful decisions with guidance from...

If you are using the report wizard, and toss that field into the "Page" box, it should display on every page.

Apparently the Preview tab in BIDS/VS2005 does not always display...

Why not just minimize the header, and put a textbox at the top of the report body with a value like this:

=Fields!reportName.Value

and just return the field reportName in your dataset?

It...

You may also want to consider 7-zip, which has a command line option:

http://www.7-zip.org/

However, if this is critical data, you ought to consider using a commercial product with a...

You might try changing the recovery model property on the database to "simple".. it's probably setup as "full".. and then do a shrink file and choose your log file, or...

I often use the "all" / multivalue dropdown option, and here's how I accomplish it:

I use a stored procedure that takes a varchar(8000) parameter (or varchar(max) in SS2005). The...

If, for some reason, you still need to use the "exec storedproc" syntax in the query window, I would suggest you create a dummy table with similar fields, and query...

I would try setting your project deployment URL property so that you're using your actual machine name rather than "localhost", but I don't know if that'll fix your problem or...

Another option is to setup a "linked server" to an Excel file and use SQL to write to the file. You could setup the Excel file with the title, headers...

Ray, I don't think that's accurate.

If you want to get a return value from a sproc, try this in the query window:

EXEC @ReturnValue = StoredProcedureName

SELECT @ReturnValue

You will need to create...

Good article, but needs a spell check.

One word that comes to mind for me when I read this article is diplomacy.

It's important to think before you talk, and be careful what you say, and to...

Visual Studio Team Edition for Database Professionals includes improved source control functionality. In addition, you can associate assigned work tasks with source changes.

I attended a product launch last week...

How will you use the date range? Will you do something like:

select *

from vMyView v

where v.StartDate = '1/1/1997' and v.EndDate = '1/1/2000'

will you be able to use variables, like this?:

declare @startDate datetime, @endDate datetime

set @startDate = '1/1/1997'

set @endDate = '1/1/2000'

select

OrderDate,

ShipCountry,

ShipCity,

Freight,

...