change reports

  • Thread starter Thread starter Michael Hanlon
  • Start date Start date
M

Michael Hanlon

I have a report called IS Course and would like to be able to change the
report as per the user request from 2 cbobox's. I would like after the user
make his choice open the report with only one of the 15 IS course showing.
is there a way to hide all unused controls on the report.
 
Could you ask again with something more specific. You can make controls
visible or invisible based on user input. Are you trying limit the display
of specific records are fields/controls?
 
I have a report called iscourse
This report has course listed across like TSA TSS Cisco so i would like to
show the report for all person that have completed a cisco course and hide
the TSA TSS and all the other controls.
if this is not enough info let me know. thanks

IS COURSE

Name TSA completed Date TSS completed Date
Cisco completed Date

Michael Hanlon Yes 01/01/01 Yes 01/01/01
Yes 01/01/01
 
It looks like your issue is your table structure. If you are storing tests
and dates as fields then you need to consider changing this to be
normalized. A properly normalized table will make your reporting easy.
 
Back
Top