0

Database view missing in table builder

Jet Reports Historic Posts

January 16, 2015 08:10

None

Follow

Hi all,

I have a created a small database view to use in Jet, but unfortunately it is only displayed in the Wizard, the other tools do not show it. I already updated the table definitions via the dataview creator, but to no effect. What might be the reason for this? Is it not possible to use database views at all?

Thanks and kind regards,
Maja

• Facebook
• Twitter
• LinkedIn

3 comments

• 0
  
  Jet Reports Historic Posts January 16, 2015 15:19

  Hello -
  
  While SQL Viewers are not able to be used with a Dynamics NAV data source, they would be expected to be available to any UNIVERSAL or Dynamics GP data source connector type.
  
  Are you experiencing the issue with one of the valid data source types?
  
  -HP

• 0
  
  Jet Reports Historic Posts January 19, 2015 07:26

  Hi,
  
  we are on Dynamics NAV, so I guess, I will not be able to use the view via table builder?
  
  Kind regards,
  Maja

• 0
  
  Jet Reports Historic Posts January 20, 2015 17:45

  Hello Maja -
  
  If you are able to have the view populate a custom NAV table, you would then be able to see that custom table with the Table Builder.
  
  -HP