0

distribution of jet reports to non-design users

Jet Reports Historic Posts

February 04, 2013 18:56

None

Follow

I am relatively new to the jet reports. We are using jet essentials 2012 with NAV. I have created several monthly operating statement reports that work fine on my computer (I have design access). When I send them out to the budget holders (who don't have design access) they can open the reports and drill down on the data (which is what I want), however; when they try to refresh the data (and change the options in the option window popup) the report returns errors in all the fields. They get the #VALUE! - Any ideas? Thanks

• Facebook
• Twitter
• LinkedIn

4 comments

• 0
  
  Jet Reports Historic Posts February 05, 2013 00:26

  Hi,
  
  Generally when Jet functions return #VALUE, you should go to Jet -> Debug to see what is wrong. In your case I'm guessing maybe you didn't put Auto+Hide+Values or Auto+Hide+Lock in cell A1 of the report before sending it to your viewers which is required for Jet viewers to be able to refresh it. Is this the problem?
  
  Regards,
  Hughes

• 0
  
  Jet Reports Historic Posts February 05, 2013 14:05

  Thanks yes - I do - I have Auto+Hide+Lock+Dashboard in cell A1
  
  Also the user receives the attached error message when they try to refresh the report. Again it works, drill down and all until the user tries to refresh the data.
  
  Thanks for any input.

  • jeterror (2).JPG
• 0
  
  Jet Reports Historic Posts February 05, 2013 15:42

  Anytime you get an unexpected exception like this, you should report it to Jet Reports support. It may be something that has already been fixed so you may be able to just download a newer version of Jet that fixed it. If not, then it should go through support so that it can be reported to the development team and fixed. Thanks!
  
  Regards,
  Hughes

• 0
  
  Jet Reports Historic Posts February 05, 2013 15:43

  Ok thanks I'll do that!