Hide Field on Subreport

  • Thread starter Thread starter Pam
  • Start date Start date
P

Pam

I need to create a couple of reports that are basically the same, but I need
to hide some info for one and show that same info for the other and I can't
seem to figure out how to hide text on a subreport. Here are the details.

Subreport contains column for salespersons and column for hire date.
For the first report, I need only salesperson names. For the second report,
I need the names and hire dates. I didn't really want to create two
separate subreports for these two reports if I didn't have to, but I can't
find a way to hide the hire date.

Does anyone have an answer?
Thanks in advance for your help.
Pam
 
Assuming you are using a form to call the reports and a query to feed the
subreports, use a calculated field for date like this --
HireOnDate: IIF([Forms]![ReportCall]![SubReport1] = -1, Null, [Hire_Date])
 
Karl,

Thanks for the reply. I'm not using a form to call the reports nor a query
to feed the subreports. I just need a simple report to list all
salespersons from database table. Subreports are based on list from table.
I was hoping for some sort of code
[subreportname].report.[hiredate].visible=false but when I try any
combination of such I get "invalid reference" error messages.

Do you have any other suggestions?
Thanks again,
Pam





KARL DEWEY said:
Assuming you are using a form to call the reports and a query to feed the
subreports, use a calculated field for date like this --
HireOnDate: IIF([Forms]![ReportCall]![SubReport1] = -1, Null,
[Hire_Date])

--
KARL DEWEY
Build a little - Test a little


Pam said:
I need to create a couple of reports that are basically the same, but I
need
to hide some info for one and show that same info for the other and I
can't
seem to figure out how to hide text on a subreport. Here are the
details.

Subreport contains column for salespersons and column for hire date.
For the first report, I need only salesperson names. For the second
report,
I need the names and hire dates. I didn't really want to create two
separate subreports for these two reports if I didn't have to, but I
can't
find a way to hide the hire date.

Does anyone have an answer?
Thanks in advance for your help.
Pam
Click to expand...
Click to expand...
 
I'm not using a form to call the reports
How do you distinguish between the two different reports?

--
KARL DEWEY
Build a little - Test a little


Pam said:
Karl,

Thanks for the reply. I'm not using a form to call the reports nor a query
to feed the subreports. I just need a simple report to list all
salespersons from database table. Subreports are based on list from table.
I was hoping for some sort of code
[subreportname].report.[hiredate].visible=false but when I try any
combination of such I get "invalid reference" error messages.

Do you have any other suggestions?
Thanks again,
Pam





KARL DEWEY said:
Assuming you are using a form to call the reports and a query to feed the
subreports, use a calculated field for date like this --
HireOnDate: IIF([Forms]![ReportCall]![SubReport1] = -1, Null,
[Hire_Date])

--
KARL DEWEY
Build a little - Test a little


Pam said:
I need to create a couple of reports that are basically the same, but I
need
to hide some info for one and show that same info for the other and I
can't
seem to figure out how to hide text on a subreport. Here are the
details.

Subreport contains column for salespersons and column for hire date.
For the first report, I need only salesperson names. For the second
report,
I need the names and hire dates. I didn't really want to create two
separate subreports for these two reports if I didn't have to, but I
can't
find a way to hide the hire date.

Does anyone have an answer?
Thanks in advance for your help.
Pam
Click to expand...
Click to expand...
Click to expand...
 
I just go to the list of reports at main screen and print from there. I
think I'll go to Excel and create a spreadsheet. Thanks for your time.
Pam

KARL DEWEY said:
How do you distinguish between the two different reports?

--
KARL DEWEY
Build a little - Test a little


Pam said:
Karl,

Thanks for the reply. I'm not using a form to call the reports nor a
query
to feed the subreports. I just need a simple report to list all
salespersons from database table. Subreports are based on list from
table.
I was hoping for some sort of code
[subreportname].report.[hiredate].visible=false but when I try any
combination of such I get "invalid reference" error messages.

Do you have any other suggestions?
Thanks again,
Pam





KARL DEWEY said:
Assuming you are using a form to call the reports and a query to feed
the
subreports, use a calculated field for date like this --
HireOnDate: IIF([Forms]![ReportCall]![SubReport1] = -1, Null,
[Hire_Date])

--
KARL DEWEY
Build a little - Test a little


:

I need to create a couple of reports that are basically the same, but
I
need
to hide some info for one and show that same info for the other and I
can't
seem to figure out how to hide text on a subreport. Here are the
details.

Subreport contains column for salespersons and column for hire date.
For the first report, I need only salesperson names. For the second
report,
I need the names and hire dates. I didn't really want to create two
separate subreports for these two reports if I didn't have to, but I
can't
find a way to hide the hire date.

Does anyone have an answer?
Thanks in advance for your help.
Pam
Click to expand...
Click to expand...
Click to expand...
 
Back
Top