Impossible/Im'possible Can anyone help urgently..

[infinity]

1. Can we write (not drag and drop) labels to a form / report in code. If Yes than how.?

2. Can we hide labels and respective textfields in a dataenvironment report or crystal reports.? We require to do this in order to generate dynamic reports with only the contents what the user fills in the form..

. dXtR

[amitabh]

What do you exactly mean by writing labels to a form? If you mean generating new instances of label control at run time, it can be done.

[infinity]

i have to print a report getting data from a database(access). i have all the fields names as labels on the report design. The fields in the database may have data or may be empty. the empty fields should be eliminated from the report along with its respective label name.

Kindly help me, ur help will be apprecietated and credited.


* u can specify different ways if more than one way to get this solved

[infinity]

Please help .... Anybody in this Planet Earth or Aliens ..
This is a reall requirement.

Imagine you have reports with 4 pages 300 fields.

Each field having corresponding labels.

But then the report can show only say 2o fields which the user fills. then ain't it a waste of paper and printing ink to pring the other labels without any results.


Think about it..

If you cant understand? ask to explain in more details

[amitabh]

All you need to do is to check for vbNull while fetching data on each field. If the returned datatype is vbNull, simply hide the control. But this way, the controls would remain at their positon and you will have to reposition the controls through coding so that it takes minmum required pages.
A better way is to use control arrays. This way you will create and position only those controls whose underlying fields have some data in their records.