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
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