Viewing 15 posts - 16 through 30 (of 35 total)
Depending on your needs, you could store a 16 character hexadecimal string value, which your application could encode and decode as needed...
February 21, 2006 at 6:41 am
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.
February 21, 2006 at 6:33 am
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...
January 25, 2006 at 6:07 am
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...
January 6, 2006 at 5:38 am
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...
December 15, 2005 at 5:30 am
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...
September 7, 2005 at 6:44 am
I am having the same problem - what was the answer?
I suspect a problematic embedded carriage return...
August 3, 2005 at 8:37 am
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...
August 2, 2005 at 10:37 am
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...
May 23, 2005 at 10:01 am
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...
April 29, 2005 at 8:11 am
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...
April 26, 2005 at 7:09 am
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.
March 23, 2005 at 5:55 am
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...
March 16, 2005 at 5:53 am
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...
March 11, 2005 at 5:54 am
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...
March 10, 2005 at 5:55 am