Small question on interactive reports
In other reports I use the OnClickObject event, along with a line like
if Sender.Name = 'Memo1' then ... to make interactive reports.
However if the report is a cross tab report, the names of the memo boxes in the corner (containing the row headings) seem to change when you run the report
eg. At design time a cell might be called 'DBCross1Corner3', but when the report is run the name becomes 'Memo33' or 'Memo48' etc.The new name seems to depend upon how many other coilumns are created by the cross tab.
I want my cross tab to be interactive so that by clicking on a particular corner cell the page is sorted by that column.
How can I detect the user click if I the name of the cell the user clicks on changes every time the report is run?
if Sender.Name = 'Memo1' then ... to make interactive reports.
However if the report is a cross tab report, the names of the memo boxes in the corner (containing the row headings) seem to change when you run the report
eg. At design time a cell might be called 'DBCross1Corner3', but when the report is run the name becomes 'Memo33' or 'Memo48' etc.The new name seems to depend upon how many other coilumns are created by the cross tab.
I want my cross tab to be interactive so that by clicking on a particular corner cell the page is sorted by that column.
How can I detect the user click if I the name of the cell the user clicks on changes every time the report is run?
Comments
What a clever idea - of course that won't change!
Thank you that works.