Modify universe in many reports

[system]

Excuse for my english…
I’ve a lot of reports with a universe define in all the queries. I would like to change the universe for all the queries, but not to select query by query in every report and select the new universe. Is there an option to change the universe for all the queries and all the reports ?
Thanks !!

---

wallace74 (BOB member since 2005-09-23)

[system]

I don’t think there is any other simple method other than going to the data manager thru view data and changing the universe from the definition tab.

---

Mahi (BOB member since 2004-07-22)

[system]

Check out this topic in BOB’s Downloads:

Change Source Universe for Multiple Documents

Original Author: Jean-Francois Cayron Author Notes: Change Universe Sub ChangeUniverse() Dim UnvCount As Integer Dim UnvNameList() As String Dim ix As Integer Dim DefaultPath As String DefaultPath = "C:\infosol\" Application.Interactive = False Set CurDoc = Application.ActiveDocument Set UnvList = Application.Universes UnvCount = UnvList.Count ReDim UnvNameList(UnvCount) For ix = 1 To UnvCount UnvNameList(ix) = UnvList.Item(ix).LongName frmChoose.cboxFrom.AddItem (UnvNameList(ix)) …

---

Dave Rathbun (BOB member since 2002-06-06)

[system]

Great !!!

It’s a bit slowly because all reports have many queries, but it’s the thing I’m looking for…

Thank’s a lot !!!

---

wallace74 (BOB member since 2005-09-23)

[system]

@wallace74

It’s a bit slowly because all reports have many queries, but it’s the thing I’m looking for…

It may be slow, but it’s faster than doing everything the hard way.

---

Dave Rathbun (BOB member since 2002-06-06)

[system]

You’re right !

Thank you !!

---

wallace74 (BOB member since 2005-09-23)