Hi Everyone,
I am trying to pass the current data item value of a level in a report in which I am using page breaks. I've hit a road block and need some assistance. Here is my problem:
In my Master report I have Managers level listed and have set a page break on my [Owner] level, so that when the report is run a user can see data for each of the managers under each of the owners in the level (one page per owner).
From this I'm attempting to create a drill through on the manager level so that when the manager is selected, a detail report opens with data for that manager in the owner that is currently viewed.
In this detail report I have two prompt values (Selected Owner and Selected Manager). I can easily pass along the data item value of the manager however in passing along the value for owner it does not work and instead requests a prompt. Is there a way to pass along a data item value that is used in a page break?
Thanks!