access reports

[vecerda]

hello,

I would like to print out reports in access, but I do not want to print the columns where there is no data. In other words when the data is unavailable I do not want to have that empty line on the report.

thank you,

petr

 

[GingerR]

if what you are saying is that you do not want blank rows, you can make the criteria in your report recordsource

Is Not Null

or

 <> &quot;&quot;

.
if what you mean is that when there is absolutely NO DATA returned and so you do not want the report to open at all, you can put code in the On No Data event of the report and put a msgbox to the user "NO DATA" and cancel the openreport event.

if this isn't helping you, please provide more details including the query/recordsource of your report, field names that you want to check If Null on, etc. and we will help more.

g

 

[vecerda]

hello ginger,

I do not know, if I expressed my problem well. I have appraisal criteria (about 100 collumns) for each record. Almost on all the records I have only 30 - 40 collumns filled out, just because the other 50 - 60 is unavailable. When I print out the report I will get 100 collumns and the report is twice as long as it would be if the computer skipped the collumns where the data is unavailable. It also looks unprofessional to have blank columns in appraisal report. I will try your solution to see if gets me where I need to be.

thank you very much for your quick response,

petr

 

[GingerR]

so you mean 'columns' as in 'fields'?
so each records has 100 'fields' going horizontally across the page?
so do you mean the report is 'twice as wide'?
if you dont want a field in the report, the just take the text box and label off of the report. did you make the report design yourself? or use the wizard? if you omit 50 fields from the report today, what if you then have to display them later?

 

[vecerda]

hello ginger,

you hit the nail exactly on the head. problem is the every record is different, so I never have all 100 fields filled out and each record has completely unique set of fields. so if I could hide the fields that are simply empty that would shorten the reports a lot. plus it would make them professional.

I do not know if this is even technically possible.

thank you so much for your help,

petr

 

[GingerR]

it wouldnt really make sense cause the column headings won't line up. know what i mean?

is all your data checkboxes, or text boxes? memo fields?

 

[vecerda]

hello ginger,

I was use a product called data comp before and that software actually automatically did it. now I would like to upgrade to access because DataComp does not have a lot of features access has. If I wanted to print a report and field was empty, the DataComp software would simply omit the field and skip it. It was printing each record (sale) on separate page, so every field would represent one line on the report. that is what I am interested in. every record is on separate page with fields vertically.

so alignment of the fields does not cause any problems. maybe I will have to fax you two examples with explanations. I know it is my fault that I cannot express it properly.

thanks,

petr

 

[GingerR]

so the fields are printing vertically, even tho they are 'fields'?

just tell me briefly the structure of your table(s). that will help. is it something like

UserID Number
Appraisal1 Yes/No
Appraisal2 Text
Appraisal3 Text
.
.
.
Appraisal100 Yes/No

so that when you look at the table in datasheet view, it looks like an Excel spreadsheet with the "appraisals' running horizontally from left to right?

 

[vecerda]

yes exactly, you are incredible, this is very close to what it really is!

 

[GingerR]

did that other package--did it label each row's appraisals separately? otherwise they wouldnt line up if you just had the labels be one time at the top:

ID App1 App2 App3 App4
1 Yes XX2 74
2 yy3 78x 3a


know what i mean? if it skipped ones that were not filled in, then did it look like

ID App1 App2 App4
1 Yes XX2 74

ID App2 App3 App4
2 YY3 78x 3a

?? do you know what i'm asking? if i'm wrong please type in how you want the report to look. thanks and thanks for your patience too.