I am building a financial report. Months as columns, department/account as rows, summing transactions:
I am able to expand departments and see totals by account, I am also able to click on a single account amount and drill through to another report for transactional detail. Say account 70300 for March totaling 14,244. This work wells. The report successfully passes Department 000, account 70300, 201503 for March 2015, showing me the transactional detail for the account.
My issue is being able to drill through for a department, say the 1,063,038 for department 000 for March. I am able to click on the value and pass it actually passes all the accounts with data for the month to the filter Acct, however it returns no data:
I thought it would have something to do with how the separator is stringing the accounts together in my expression. I have tried “,” and “, “. Looking at other reports I have created with multiple criteria selection from a drop down list it always displays selections separated with a comma then a space but that is not working for me. Here is the expression I am using via Text Box Properites -> Action -> Expression:
=IIF(Inscope("matrix1_G_L_Account_No_"),Fields!G_L_Account_No_.Value,Join(LookupSet(Fields!Global_Dimension_2_Code.Value, Fields!Global_Dimension_2_Code.Value, Fields!G_L_Account_No_.Value, "DataSet1"),","))
Any advice is greatly appreciated!