Displaying a checkbox in DataReport

[sdb510]

Hey all,

I am designing a reporting application that pulls data from a SQL 6.5 database and puts it on a VB6 DataReport. One of the features of the report needs to be a list of fields that have not been filled in by the user -- ie, if they haven't filled in the effective date for a transaction, or the name of an underwriter, etc.

I would like to display the fields that are not complete as a series of checkboxes, checking the boxes that still need to be filled in.
Thus, if the field is null, I want it to be checked; if it contains data, it should be unchecked.

When I run the query, I am able to convert the returned value for the fields to a 1 if the field is null, and a 0 if it contains data (using a stored procedure that does several data manipulations).

As far as data is concerned, I think I have everything in place. The problem is that I haven't seen any type of checkbox control for the DataReport. I have noticed that the RptTextBox control has a checkbox format in the DataFormat property page, but this doesn't display a checkbox.
Would it be possible for me to use an Image control to display an image of a checkbox when appropriate?

Does anyone know how I can display this data as the users want, using the DataReport? Would Crystal Reports maybe be a better way to go? I'm not really familiar with CR, so I'm not sure of its capabilities.

Thanks for any help.

Steve

[sig][/sig]

 

[Scoty]

datareport does not support check boxes

You can however display fonts. If you use the "wingding" font the little "o" = an empty check box and the little "x" = an x'd check box. I know this is a son of a gun. It took me awhile to figure it out.

hth

Scoty : "Learn from others' mistakes. You could not live long enough to make them all yourself."
-- Hyman George Rickover (1900-86),