0

Muliple Database report

Jet Reports Historic Posts

February 09, 2009 16:17

None

Follow

Hi,

Can anybody help me!?! I am trying to create a report that is using tables from 2 seperate databases. One is a standard Nav and the other is a universal connected SQL. At the moment as soon as I change the Datasource and hit report it is telling me the table does not exist and throwing out the report.

Any tips on where to get started appreciated.

Thanks in advance

:)

• Facebook
• Twitter
• LinkedIn

5 comments

• 0
  
  Jet Reports Historic Posts February 09, 2009 18:51

  I haven't had any experience with the SQL connector, however if your NAV database has a SQL backend, you could create a view in your SQL database that points to the Nav table. If its on a different server, you would need to set them up as a linked server. You would then use your universal connected DB to access the Nav table through the view.
  
  I have a feeling though somebody else may have a cleaner answer for you, as I can see several limitations/issues with such a method.
  
  Good luck

• 0
  
  Jet Reports Historic Posts February 09, 2009 19:32

  In Jet Reports you may set up multiple data sources. One of them may be set up as the default one. All this is done in Jet Reports Options.
  
  In your report you can tell in the NL and GL function which data source it should use. If you take some time to read the Jet Reports Help PDF file you will find info on this topic on page 43/44, 110, 136 and 189..191. I'm sure this will help you create your reports.

• 0
  
  Jet Reports Historic Posts February 11, 2009 15:15

  I had a feeling there would be an easier way…I'd forgotten completely about being able to specify different datasources (lucky I guess in having only one source - so far).
  
  cheers

• 0
  
  Jet Reports Historic Posts March 06, 2009 07:45

  The only downside is, when specifing your datasources in your formula, it's a lot harde to switch them than when you use a default datasource.
  On the pages Hans pointed out, however, there is some info about setting them as an option if i'm not mistaking.

• 0
  
  Jet Reports Historic Posts March 25, 2009 12:20

  All,
  
  Thanks for your help, I have now created the report as desired. I have been able to use the "data source" and "company options in the JFX designer.
  
  Thanks again
  
  Dean