0

Porting the entire report to a different data source

Jet Reports Historic Posts

January 15, 2015 10:59

None

Follow

Hi,

We recently deployed an additional database, just for reporting.
It's the overnight backup of the Live database, for large reports which were pounding the living daylights out of our Live db.

I have about 40 different reports scheduled, few of them need to stay in Live, but majority need to go to the Backup db.

I've changed the default data source to use Backup.
My concern is with the remaining "Live" reports. Is there a way to make an ENTIRE report to use a specific db, other than pointing each and every formula manually?

I'd be grateful for any ideas, shortcuts or whatewver which will save me time doing this by hand! ;)

Regards,

• Facebook
• Twitter
• LinkedIn

6 comments

• 0
  
  Jet Reports Historic Posts January 15, 2015 13:56

  Is there a way to make an ENTIRE report to use a specific db, other than pointing each and every formula manually?

  In short: no.
  But I would love to be proven wrong this time!
  
  There have been several feature requests to define the datasource for one sheet by using a special NP() function or a reserved cell.
  But no luck so far.
  
  Of course you can put the datasource name in a cell and use that cell as a reference in all your formula's, but that seems obvious :)
  
  rmw
• 0
  
  Jet Reports Historic Posts January 29, 2015 12:44

  Hey,
  Thanks for your reply.
  What I actually did:
  For reports which stayed in Live, I've edited each formula manually, inserting the DB I want the report to be run from.
  For the rest of them, I've just updated the default source.
  
  Although after reading rmw's post, I agree that putting the new db name in a cell and reference this cell in every formula, is way more future proof :-)
  
  Thanks,

• 0
  
  Jet Reports Historic Posts February 05, 2015 07:58

  At least next time you can use find and replace!

• 0
  
  Cat August 22, 2018 07:19

  Hi to all,

  there is still no way to define the datasource for one sheet, isn't it?

  Just to check if I didn't miss anything.

  Thanks.

• 0
  
  Harry Lewis August 22, 2018 15:26

  Hello Cat -

  The way to accomplish this (assuming that what you want to do is have each sheet of your report use a different data source) would be to set the name of the data source in a cell on that sheet and use the "DATASOURCE=" filter and a reference to that cell in your functions.

  Edited by Harry Lewis August 22, 2018 15:27
• 0
  
  Cat August 23, 2018 07:19

  Hi Harry,

  thanks, that's what I do for over 10 years. But nevertheless it would be easier to define it per sheet and not in each formula.