BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Want to sponsor BOB? 
Want to sponsor BOB? (Opens a new window)  

General Notice: BOB is going to retire...please see details here.
General Notice: No events within the next 45 days.

List objects used in a series of reports
3 members found this topic helpful
Goto page 1, 2, 3, 4, 5  Next
 
Search this topic... | Search BOB's Downloads... | Search Box
Register or Login to Post    Forum Index -> BOB's Downloads  Previous TopicPrint TopicNext Topic
Author Message
Dwayne Hoffpauir
Forum Groupie
Forum Groupie



Joined: 19 Sep 2002
ASUG Icon
medal_gold.gif*2speaker.gif*5medal_bronze.gif
Posts: 8644
Location: Plano, TX USA


flag
PostPosted: Mon Mar 20, 2006 1:22 pm 
Post subject: List objects used in a series of reports

Author: Dwayne Hoffpauir, EDS

The attached utility will record objects that are used in a series of reports. Usage is as follows:
Author's notes wrote:
- Create a temporary directory.
- Place all documents (.rep files) to be analyzed in that directory.
- Place this document in that same directory.
- Open this document, and refresh.
- Each document in the directory will be opened, and data provider objects recorded.
- There will be a lot of screen flashing as the documents are opened and closed.
- A message will be displayed when the refresh is complete.

Please note that it is not possible to record objects used in sub-queries, or when an object is used as the operand (right hand side of a condition). This is a limitation of the object model.



List Objects Used - XI.rep
 Description:
Version XIr2

Download
 Filename:  List Objects Used - XI.rep
 Filesize:  121.95 KB
 Downloaded:  10708 Time(s)


List Objects Used v5, v6.rep
 Description:
Version 5 / 6 - 95 previous downloads

Download
 Filename:  List Objects Used v5, v6.rep
 Filesize:  86 KB
 Downloaded:  6300 Time(s)


_________________
Dwayne Hoffpauir
Image link
Back to top
BO_Stuffed
Principal Member
Principal Member



Joined: 29 Mar 2008
ASUG Icon
Posts: 495
Location: Los Angeles



PostPosted: Wed May 07, 2008 4:17 am 
Post subject: Re: List objects used in a series of reports

HI,

Can this report be modified to handle the exceptions like if all the reports in the folder doesn't have the required permissions to open?

But undoubtedly, it works well and give the best results.

Great Work!!!

Regards
Back to top
Dwayne Hoffpauir
Forum Groupie
Forum Groupie



Joined: 19 Sep 2002
ASUG Icon
medal_gold.gif*2speaker.gif*5medal_bronze.gif
Posts: 8644
Location: Plano, TX USA


flag
PostPosted: Wed May 07, 2008 10:38 am 
Post subject: Re: List objects used in a series of reports

Possible? Probably yes, but if the files are stored locally, what kind of permission issues are you seeing? Read-only, something else?
_________________
Dwayne Hoffpauir
Image link
Back to top
BO_Stuffed
Principal Member
Principal Member



Joined: 29 Mar 2008
ASUG Icon
Posts: 495
Location: Los Angeles



PostPosted: Thu May 08, 2008 7:06 am 
Post subject: Re: List objects used in a series of reports

Thanks for your reply.

I had created some reports with different user account and they could not be accessed via the account I am using currently, though they can still be accessed using the administrator credentials.

Now the problem with using the administration credential is that the report does not pick up the right universe or it comes up with the screen to choose the universe from and this application ends up in error.

I am very sure you can put a log somewhere on the same folder stating the files which were not processed and still continue with the next.

Kind Regards
Back to top
Dwayne Hoffpauir
Forum Groupie
Forum Groupie



Joined: 19 Sep 2002
ASUG Icon
medal_gold.gif*2speaker.gif*5medal_bronze.gif
Posts: 8644
Location: Plano, TX USA


flag
PostPosted: Fri May 09, 2008 9:09 am 
Post subject: Re: List objects used in a series of reports

BO_Stuffed wrote:
I am very sure you can put a log somewhere on the same folder stating the files which were not processed and still continue with the next.

Indeed, but I will politely decline. The utilities I post here helped me get through some tedious work of my own. I share them in case someone else finds them useful, to serve as samples of the kinds of things that are possible with the SDK, and hopefully are worth at least as much as you paid for them icon_smile.gif .

The kinds of behavior you are seeing are the same things you would see if done manually. Those behaviors were not issues for me, but you are more than welcome to enhance the utility to handle those situations for yourself. No extra charge!!!

_________________
Dwayne Hoffpauir
Image link
Back to top
anair_bo
Principal Member
Principal Member



Joined: 05 Dec 2006

Posts: 255
Location: Philly, PA


flag
PostPosted: Wed May 14, 2008 8:53 am 
Post subject: Re: List objects used in a series of reports

Dwayne,
This works great!!!.

Did you also by any chance did the same for Webi reports as well? sorry for asking... but couldn't help myself icon_smile.gif
Back to top
Dwayne Hoffpauir
Forum Groupie
Forum Groupie



Joined: 19 Sep 2002
ASUG Icon
medal_gold.gif*2speaker.gif*5medal_bronze.gif
Posts: 8644
Location: Plano, TX USA


flag
PostPosted: Wed May 14, 2008 10:12 am 
Post subject: Re: List objects used in a series of reports

anair_bo wrote:
Did you also by any chance did the same for Webi reports as well? sorry for asking... but couldn't help myself icon_smile.gif

I have not, but someone else has ... WID Scanner

_________________
Dwayne Hoffpauir
Image link
Back to top
agowinuk
Forum Member
Forum Member



Joined: 25 Aug 2006

Posts: 14
Location: Woking, UK


flag
PostPosted: Wed Aug 20, 2008 11:01 am 
Post subject: Re: List objects used in a series of reports

Hi Dwayne,

I know this is an old thread now and you probably barely use the report, but I have a question.

I've adapted the code in this report by adding the code to retrieve user-defined variables and also enabling the report to look in sub folders. This all works fine (with a lot of help from a collegue), but it stumbles whenever a document it opens contains Document_Open macros designed to auto refresh. I have somewhere in the region of 2000 documents for the code to go through, so this will take an age to process all the documents designed to refresh on open (it also crashes on a number of them where they are set up to save a copy or email out etc). Basicaly, my question is "can I avoid the Document_Open command on opening?".

I have tried a number of work arounds, including restricting the users ability to refresh reports (in Supervisor), but this disables the data provider, restricting access to the universe.

Any ideas would be greatly appreciated.

Andy

PS working on BO 6.5.1 on Oracle 9
Back to top
Dwayne Hoffpauir
Forum Groupie
Forum Groupie



Joined: 19 Sep 2002
ASUG Icon
medal_gold.gif*2speaker.gif*5medal_bronze.gif
Posts: 8644
Location: Plano, TX USA


flag
PostPosted: Wed Aug 20, 2008 2:27 pm 
Post subject: Re: List objects used in a series of reports

agowinuk wrote:
Basicaly, my question is "can I avoid the Document_Open command on opening?".

I'm not sure that is possible. If you have the "Refresh Document When Opening" set, that is already handled (won't execute) with one of the .Open method parameters. If your own code is doing the refresh, I can't think of a way to avoid that.

_________________
Dwayne Hoffpauir
Image link
Back to top
agowinuk
Forum Member
Forum Member



Joined: 25 Aug 2006

Posts: 14
Location: Woking, UK


flag
PostPosted: Thu Aug 21, 2008 6:05 am 
Post subject: Re: List objects used in a series of reports

Ok. Thanks for the reply.
Back to top
neheyen
Forum Member
Forum Member



Joined: 22 Aug 2006

Posts: 6



PostPosted: Tue Oct 07, 2008 4:20 pm 
Post subject: Re: List objects used in a series of reports

Can someone assist me in getting this to open? I'm assuming it is a Crystal Report file and I should be able to open in CR XI.

When I try, I get an error message that says:
This document has the expected file extension (.RPT), but seems to be corrupted. If this report used to work, try opening it with a different version of Crystal Reports and if that still does not work, please contact your administrator.

I've tried both the XI and v5,v6 files and get the same message from either.

Any pointers to show me how to use this?

Many thanks!
Norman
Back to top
Dwayne Hoffpauir
Forum Groupie
Forum Groupie



Joined: 19 Sep 2002
ASUG Icon
medal_gold.gif*2speaker.gif*5medal_bronze.gif
Posts: 8644
Location: Plano, TX USA


flag
PostPosted: Wed Oct 08, 2008 12:39 pm 
Post subject: Re: List objects used in a series of reports

neheyen wrote:
I'm assuming it is a Crystal Report file and I should be able to open in CR XI.

What would give you that idea? The .rep extension indicates a full client (now called Desktop Intelligence) document. Manually changing it to .rpt is not going to make it a Crystal Reports document, sorry.

_________________
Dwayne Hoffpauir
Image link
Back to top
nonyup
Principal Member
Principal Member



Joined: 07 Jan 2008

Posts: 204



PostPosted: Fri Oct 24, 2008 10:13 am 
Post subject: Re: List objects used in a series of reports

I have a question about this.... I’m working with the download for 6.xx and wondering; We have a universe created that gives us backend information about users, groups, universes, etc. On the report from the download, I’m trying to create/add a dataprovider to go after information with this “backend” universe we have. In the universe we’ve got an object called "Universe Name" that is created from table/field, universe.M_UNI_C_LONGNAME. On the report, I’m linking this object to the Object, “Universe Name” which on the download is DataRow(5) = DProv.Universe.LongName in the code. (I changed this from 'DataRow(5) = DProv.Universe.ShortName & "-" & DProv.UniverseName).
The data that comes back is identical but it’s not working. The VBA code is working properly, listing only the universe(s) used in the report(s). But the object from my new dataprovider is giving me all universe names that we have, and I’m just expecting the universe name(s) that are on the selected reports. I’m wondering….is the VBA code executing before or after the dataprovider is refreshed? Reason why I'm here is that I use this awesome download to list the information about a report but I'm also trying to get more info about the universe...I also want the table and field names of each of the objects on the report...

Hope I explained myself ok!
thanks!!
Back to top
mkumar
Forum Associate
Forum Associate



Joined: 26 Aug 2002

Posts: 771
Location: Manhattan, NY



PostPosted: Fri Nov 14, 2008 10:27 am 
Post subject: Re: List objects used in a series of reports

agowinuk wrote:
Hi Dwayne,

I know this is an old thread now and you probably barely use the report, but I have a question.

I've adapted the code in this report by adding the code to retrieve user-defined variables and also enabling the report to look in sub folders. This all works fine (with a lot of help from a collegue), but it stumbles whenever a document it opens contains Document_Open macros designed to auto refresh. I have somewhere in the region of 2000 documents for the code to go through, so this will take an age to process all the documents designed to refresh on open (it also crashes on a number of them where they are set up to save a copy or email out etc). Basicaly, my question is "can I avoid the Document_Open command on opening?".

I have tried a number of work arounds, including restricting the users ability to refresh reports (in Supervisor), but this disables the data provider, restricting access to the universe.

Any ideas would be greatly appreciated.

Andy

PS working on BO 6.5.1 on Oracle 9


Will it be possible for you to provide the code which can retrieve objexts used in user defined variables?
Thanks,
Kumar
Back to top
Dwayne Hoffpauir
Forum Groupie
Forum Groupie



Joined: 19 Sep 2002
ASUG Icon
medal_gold.gif*2speaker.gif*5medal_bronze.gif
Posts: 8644
Location: Plano, TX USA


flag
PostPosted: Tue Nov 18, 2008 8:42 am 
Post subject: Re: List objects used in a series of reports

mkumar wrote:
Will it be possible for you to provide the code which can retrieve objexts used in user defined variables?
Thanks,
Kumar

Try this ... List report level variables in full client reports

_________________
Dwayne Hoffpauir
Image link
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> BOB's Downloads  Previous TopicPrint TopicNext Topic
Page 1 of 5 All times are GMT - 5 Hours
Goto page 1, 2, 3, 4, 5  Next
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.1055 seconds using 19 queries. (SQL 0.0064 Parse 0.0706 Other 0.0285)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo