0

Datasouce error

Jet Reports Historic Posts

February 19, 2015 14:22

None

Follow

Hello

Any one please help me with this file I am getting Datasource field invalid

using Nav 2013R2
jet reports : 2015

best regards

Ravi

• Jet Rep - Dashboards.xlsx

• Facebook
• Twitter
• LinkedIn

5 comments

• 0
  
  Jet Reports Historic Posts February 19, 2015 17:45

  I would recommend writing into Jet Support. They will need more information regarding your data source settings.

• 0
  
  Jet Reports Historic Posts February 19, 2015 23:08

  Hi
  
  thanks for the reply
  
  my data source is : 2013R2SQL
  
  my data source is no issue i am working many other reports fine , its only this report prepared by some one else in the community here , which i am trying run and getting that error. I am not sure the formulas they set here are working for any one else and not working for me or any issues in this formulas. Especially the datasource title they used in formula and named ranges looks odd , if you see nl function also its looks something strange.
  
  Please see if the functions they stated especially the datasourse is correct or not and if its working for any of you?
  
  best regards
  
  Ravi from Hong Kong

• 0
  
  Jet Reports Historic Posts February 19, 2015 23:33

  When are you getting the error, meaning what are you doing when you get this error? What is the exact error? Can you get screenshots? Right now, I'm just not sure when you are getting this error or what part is giving you the error message.

• 0
  
  Jet Reports Historic Posts March 23, 2015 19:54

  Hello Ravi,
  I am not sure if you are still encountering this error message with this report. However, I wanted to share some of my findings with you regarding this report.
  When I attempt to run this report, I encountered the below error message which I suspect might be the same error message you encountered:
  Invalid Field 'Datasource='.
  
  I got this error on Cells G8, H8, N8, O8, F10, F11, G10, G11, H11, L11, L10, M10, M13, L12, N10, O10
  So I checked the function under the JFX Wizard, didn't see the field indicated. Changed the "What" to "Rows", now I see the field "Datasource=". Since this is a NL(Count) function, the field name should not be there in the first place and because it is there, it should have been ignored. I suspected that the issue stemmed from the original report designer who may have copied this function from one cell to another (speculation, of course) and this caused errors with the functions in certain cells.
  
  From the JFx Wizard window, *REMOVE* this field. Change the NL(Rows) back to NL(Count). Click OK. You will of course, have to repeat this for multiple cells that have that query with the 'datasource=' in it.
  
  I hope this was helpful. Please let us know if you are still encountering issues and it might be best to create a Support ticket.
  If you are not registered on our Support site, please see the below instructions:
  
  To register on our Support site, please navigate to https://support.jetreports.com
  Click on the link "FIRST TIME USERS Click to Register Now!"
  Fill out your personal information, license/company information
  Click "Register" when finished
  You'll then be taken to a "Validation Pending" page where you'll be informed that "you should receive an Email with further instructions shortly.
  Please follow the link in the Email to validate your account. You will not be able to log in until your account is verified."
  
  Best regards,

• 0
  
  Jet Reports Historic Posts March 23, 2015 21:48

  Hello
  
  Thanks for the reply , yes there were several errors in the formulas which I could fix and get the report run already
  
  Thanks once again for the response
  
  Warm regards
  
  Ravi