Hi -
I have a report with a column of Predecessors and Successors. These columns column ID numbers (separated by commas if multiple) that track "tasks" relating to the current row.
So for example, the "Predecessor" column could look something like this:
ETS-PC-2-324,ETS-PC-2-13,
These link to the "PS_UID" in our database. So if I look up PS_UID = 'ETS-PC-2-324', it would return one row.
What I'm trying to do is have each ID be a drill through to a detail report. Basically passing the Predecessor or Successor to the PSU_ID. I realize if the column contained only ONE ID this would easily work as I could just pass the data item. However, since there could be multiple values like ETS-PC-2-324,ETS-PC-2-13, I'm unsure how to handle this scenario.
Any ideas? Thank you in advance.
1. Create a data item that only contains the substring that you want to pass.
2. Setup the Drill Through Definition on the column that you want and Edit the parameters to pass to the target report.
3. Choose Pass Data Item Value for the PS_UID parameter in the target report.
4. Select the data item you created in Step #1.