Re: BusinessObjects automation

Oh, no doubt about it. I've seen some pretty whacked ideas in this froup. And,
in fact, what I'm trying to do is whacked. Unfortunately I have to work within
the contraints placed upon me.

We have three different db platforms: Oracle, Sybase and DB2. "The Powers That
Be" have decreed that BO is THE reporting tool of all time. The design of the
Sybase db was whacked from the start and it took me six weeks to convince my
supervisors that I could do a lot better with Access and the drivers. They
allowed me that but no connection to the other two. So, I have to use BO as a
query tool on the Oracle database and import that data into Access to produce
this report.

I'm just about to test the code I've put together. I was already pretty close
but I got some info to clean up my syntax from a BO forum on the Tek-Tips site.

Fingers crossed,
RD


On Tue, 14 Jun 2005 11:36:45 -0400, "David C. Holley"
<DavidCHolley@xxxxxxxxxxxx> wrote:

>Sometimes though the app is wacked out. I would presume though that
>you're trying to refresh a BO report that that part of it isn't wacked
>out. I would surmise that the person who suggested that the app needed
>some redesign wasn't too familar with BO. WBTW, I am somewhat from my
>days back at Disney. (To the point that I was quite happy to see the VBA
>add-in now obviously available)
>
>RD wrote:
>> Yeah, the OP was Fabbe (Refresh a BusinessObjects report - 5/18/2005). I
>> grabbed the snippet of code (s)he had posted and found a bit more on the web.
>> I've referrenced the BO object library and found a lot of stuff through the
>> Object Browser but am unfamiliar with the syntax. I find the BO tech support
>> site near worthless but found a user forum that looks promising.
>>
>> Kinda funny, one response I got on the forum is very similar to some of the
>> posts I see here. Someone is always trying to redesign your app instead of
>> helping out with the code you need. :-)
>>
>> Regards,
>> RD
>>
>> On Mon, 13 Jun 2005 19:24:24 -0400, "David C. Holley"
>> <DavidCHolley@xxxxxxxxxxxx> wrote:
>>
>>
>>>There was a post here a while back pertaining to that, however I don't
>>>recall the poster or subject line. I would snoop around the internet for
>>>a Business Objects User's forum and/or their website for tech support
>>>directly from them.
>>>
>>>RD wrote:
>>>
>>>>Has anyone here used Access to automate BO? I'd like to open, refresh and
>>>>export a BO report through an Access module. I haven't been able to get much
>>>>info about the BO object model or code samples.
>>>>
>>>>So, how about it? Anybody have any experience with this?
>>>>
>>>>TIA,
>>>>RD
>>>>
>>
>>

.

Relevant Pages

  • Re: BusinessObjects automation
    ... I would presume though that you're trying to refresh a BO report that that part of it isn't wacked out. ... I would surmise that the person who suggested that the app needed some redesign wasn't too familar with BO. ... I find the BO tech support site near worthless but found a user forum that looks promising. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Advice on improving report processing speed
    ... We don't know which tips you have "found good ones from the existing posts ... I have often resorted to creating local temporary tables for a report. ... is usually done with code that creates a temporary MDB with required tables. ... > I have found good ones from the existing posts on this forum. ...
    (microsoft.public.access.reports)
  • Re: VLookup function to right!
    ... numbers because the number of rows will change from report to report and it ... seen other ways in this forum by using INDEX and MATCH, ... understand the posts or how these 2 functions work together so I haven't been ...
    (microsoft.public.excel.worksheet.functions)
  • Re: where will I notice negative side effects of bloat?
    ... recordsource for an Access report object. ... procedures which you believe cause the observed bloat? ... it sets up a querydef at the ... So, when one looks at the database window in the 8MB app, one sees the ...
    (comp.databases.ms-access)
  • Re: Infantile postings
    ... I reported this to forum in the evening, ... That advertiser must never sleep. ... I din't think that my report about it to Goggles. ... the profile of tuning of your accordion. ...
    (rec.music.makers.squeezebox)