Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Test visible state of a control

Status
Not open for further replies.

xlbo

MIS
Mar 26, 2002
15,080
GB
Hi,
as per subject title, I am trying to find out if you can test the visible state of a control in the report. I have a matrix control which is set up with 3 groups. Groups 2 is dependant on group 1 and group 3 on group 2 with initial visibility property set by a report parameter. The issue is that the user can then further drill into the details. I am trying to control the formatting of subsection totals dependant on what data is showing. I have looked at the RowNumber() function to try and test that but it seems to create a record for evcery row in the table whether they are visible or not.....

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top