|How to pass dataSetRow values in a Crosstab Within a Table [message #1082593]
||Thu, 08 August 2013 20:12
| Son Ton
Registered: August 2013
I have a table that list employees in a company. For EACH employee (table row), I have a CROSSTAB that display information about the employee. |
How do I pass dataSetRow["EmployeeID"] into the crosstab cube's dataset query?
I've already tried a couple approaches that did not work out for me:
1/Use Filter in the cube
My cube query is very complicated, that involves a few outer joints, so a simple filter for the cube does not work for me.
2/ Use beforeOpen script to replace params in the query.
Apparently, beforeOpen script only executed once, no matter how many times the query being executed.
3/ I can't find any "Parameter binding" for crosstab
So, again, how can I pass in table row value, in this case dataSetRow["EmployeeID"], to a crosstab?
I'll really any suggestion/solution you have.
Powered by FUDForum
. Page generated in 0.02669 seconds