Drill down option missing for RV license users

I have 2 report viewers who in excel don't have the option to drill down when right clicking on a cell. The report manager user however can drill down on the same report. I was told report viewers can drill down. Is there an excel setting that I need to check? The report viewers do have the task pane and the bi tools tab. 

Parents
  • Report Viewers allow drill down for reports built by the report designer.  If there is no task pane nor BI tools tab then you may not be looking at a Designer report hence the question of if it is a financial or non-financial report.  

  • in reply to Sandra Smith

    there is a task pane and BI tools tab for these users that can't drill down

  • in reply to dhalpin

    Ah, I see that, within your initial comment, you said the task pane and bi tools are visible, sorry about that, I missed it. 

    The drill down should work for the financial designer reports.  Just a reminder, only the Sage Intelligence formulas will work with SI drill down sheets.  Make sure the user is not trying to drill down on an Excel formula.  If the Sage Intelligence formulas are not allowing drill down using the Viewer then there is a problem and I suggest you work with a Sage Support Analyst. https://www.sage.com/en-us/support/   I do not know of an Excel setting for this. 

Reply
  • in reply to dhalpin

    Ah, I see that, within your initial comment, you said the task pane and bi tools are visible, sorry about that, I missed it. 

    The drill down should work for the financial designer reports.  Just a reminder, only the Sage Intelligence formulas will work with SI drill down sheets.  Make sure the user is not trying to drill down on an Excel formula.  If the Sage Intelligence formulas are not allowing drill down using the Viewer then there is a problem and I suggest you work with a Sage Support Analyst. https://www.sage.com/en-us/support/   I do not know of an Excel setting for this. 

Children