Qn1:On : 9.1 version, Smart Fields
Financial Report Writing
Question>
We have developed few custom financial reports and drill down functionality on those reports is not working in certain cases when there are zero balances at the line item level in those financial reports with Zero Row Suppression option ON.
Qn2:Question 2>
How to drill down can be implemented in below scenario?
Col-1, Col-2, Col-3, Col-4, Col-5
Description, FINRPTYC-1 (Hidden), FINRPTYC-2 (Hidden), FINRPTIC-1, FINRPTIC-2
- Each rows has it'd own data selection based on reporting category code in F0901
- For a certain rows values written in FINRPTIC-1, FINRPTIC-2 are coming from FINRPTYC-1 (Hidden), FINRPTYC-2 (Hidden)
- In this scenario, drill down points to different account as it is supposed to be and total sum value is not in synch.
An1:Issue is caused by Cell Override where actual value is coming from other column which does not have Drill down. So to make it work, do not write F83UI001 in actual column and write it when hidden columns are called.
An2:Answer 2>
Possible way to implement it is write drill down for FINRPTYC-1 (Hidden), FINRPTYC-2 (Hidden) then get row ID from F83UI001. So when row ID is for a certain row, then show drill down information for FINRPTYC-1 (Hidden), FINRPTYC-2 (Hidden) though it is positioned to FINRPTIC-1, FINRPTIC-2 by adjusting column number.
Plus, it is known that column description in Financial Row Report is very much depending on the first column added through report wizard. In case you experience similar issue, make it sure either these columns are not hidden or it does not have cell level data selection (because it can be moved to row level data selection).