Depending on your needs, you could store a 16 character hexadecimal string value, which your application could encode and decode as needed...

About the fastest way is to use the following:

Floor(DateDiff(dd, DOB, GetDate())/365.25)

Dividing by 365.25 allows for leap years, and taking the 'Floor' gives you the integer part of the value.

There is...

You could provide an interface to allow the user to enter the column values and then pass them to the report as parameters.

It would be more difficult to have the...

To do this in HTML is tricky, and HTML is the report manager's default output - an HTML 'page' can be of any length.

You may be able to force page breaks...

You can also put all the possible 'Letter' values in their own table - columns would be PrimaryKey, LetterValue, and SortOrder.

This lets you impose an arbitrary sort order from anywhere...

Alternatively, you could run the upsizing routine, and create the scripts from the SQL Server database itself using Enterprise Manager.

Then you could drop or keep the database itself, depending on...

I am having the same problem - what was the answer?

I suspect a problematic embedded carriage return...

If it is of interest, I have some old (but good, I think) Access VBA code designed for combined error handling and lock processing - if it detects a locking...

I have a pedantic point - XML is not a language, per se.

It is a standard for specifying how to put data into a text file.

XML is not any kind...

I have frequent need to use BETWEEN type logic for date ranges, where the start date or the end date (or both) may be null.

If just the start date is...

Go to Report|Report Properties.  Put code similar to this into the Code tab (for each field you plan on using in the header, add a...

Data containers like lists have a NoRows property, where you can enter a message to be displayed when there is no data returned.

This should give you something to test against.

Other possibilities to look at would be COALESCE in T-SQL, or IIF in VB.Net, using it to test for an empty condition.

Note that the Report Designer does not expose very...

You could create a view or stored procedure that concatenates your data fields into a single result column (of the length you need), and then render a report as a...

To handle displaying the null value, you would need to write a function in the report code to handle it, and then use the function to provide the value for...