NaN is displayed by JavaScript if you have a divide-by-zero error, it means "Not a Number".

For the name, try using something like this in a single text box:

=Field.firstname.value & " " & Field.Lastname.Value

Have you tried using Mozilla Firefox instead of IE? You can download (free) at

http://www.mozilla.org/products/firefox/

Besides being smaller, faster, and possibly safer you can get extensions such as FoxyTunes 1.0 from...

Found this through a Google search.

http://www.microsoft.com/technet/prodtechnol/winxppro/deploy/relnsp2.mspx

Security in Internet Explorer 6

To help improve security, Media Bar has been removed from Internet Explorer 6. For this preliminary release of SP2, however,...

Don't forget to include columns for beginning and ending dates, so when your customer moves you won't lose your historical info. MTCW

Using a linked server and openquery yields a very slow connection, due to the number of layers of OLEDB/ODBC between you and your data.

In trying to model a customer's system, I...

I agree, the Hitchhiker's Guide already helped me solve one major problem.

One more new book just out from MS Press:

Microsoft SQL Server(TM) 2000 Reporting Services Step by Step

ISBN 0-7356-2106-3

Don't use a page header at all.

Instead, insert additional table header row(s) and merge the cells as needed for your text and image. Set the 'repeat on each page' =...

You could try this: Create a Function in Access that works the same as the ISNULL() FUNCTION in SQL, for example:

Function IsNull(test_expr,default_value)

   IsNull = Nz(test_expr, default_value)

End Function

This would override the built-in...

Here is a portion of C# code that I use to create a PDF in the user's temp directory. The string rsReport is the name of the report I'm about...

On the Report Properties fly-out menu, click the icon for Property Pages. Click the layout tab & set your # of columns and column spacing for the labels. Then create...

AFAIK here's what's available so far. The URL's below list the ISBN number and cover photo. It's best to browse them first at a bookstore, they're all a little different...

The evaluation version will blow up after 120 days.

Here is how to get the full version:

http://www.microsoft.com/sql/reporting/howtobuy/default.asp#existing

Basically you can order the media for $5 US or contact your reseller.

You can use URL access to render the report directly to Excel, something like this:

xhttp://MyServer/reportserver?/MyReport&rs:Command=Render&rs:format=EXCEL

(remove the leading 'x')

This assumes that your server is MyServer and the report is MyReport.

You can control permissions on individual objects if you're willing to implement workgroup security, which is a lot of work just to protect one query.

You could, however, re-write the sql...