Search results for query: *

Yes, just as interested as I was when I posted my question here three days ago. Are *you* interested in the solution? If you don't have something constructive to add, stop shaking your finger at me. :-) I built a multidimensional array that holds the filter values and the folders the reports...

I figured out how to do it.

Hi all, BO 5.1.3. I have these two reports I run every month. After refreshing them I manually apply various filters and save each filtered version as separate PDF files. I'm already familiar with automating the opening, refreshing and converting reports and can even send them as Novell...

Yes, the db is Oracle and I want the age expressed in years. I don't know how much more specific I can get than "how would I go about creating a UDO to determine age based on DOB?" 1. How does one create a UDO? I don't care if their use is frowned upon. It's what I want to do. 2. How would...

Unfortunately, that isn't an option in this case. So, how would I go about creating a UDO to determine age based on DOB?

I make use of people's DOB in custom variables to determine their age in a LOT of reports. Can I create a User Object to do this so I don't have to recreate the wheel every time I make a new report? How would I go about doing that? Thanks, rud

Thanks for the responses. Since my original question, our tasks around this project have been shifted so this report is no longer my concern. I've been given different fish to fry. Thanks again for your help.

Um ... ok. LOL. Although it says Symantec below your name I'd swear you worked for MS tech support. Your response, while technically correct, doesn't help very much. :-) I'm new to BO and haven't had any training on it. The only book in the office about BO is practically worthless. Could...

Exactly. I would want to extract the most recent record. Thanks for responding so quickly.

I'm trying to create a User Object to simplify a report I'm building. I'm trying to find the age of a client at the earliest referral. I have these three dimensions to work with: Referral Received Date Age at Referral Client Identifier Can anyone help me out with this? Thanks for any help.

Funny. I use the Hourglass often and it never mattered "where" the code was. In fact, what *would* come after the Hourglass command but more code? Anyway, some things to consider: 1. Is all your code being executed? Depending on your logic it could be jumping over huge amounts of code and...

I used to work at a place where many people were (at least) bilingual. All of our Office installations were English but we set up a second language for many users. Open Word and go to Tools>Language>Set Language. I know that's where it is in Office XP ... not sure about 2K. You can also open...

Far out! Thanks a bunch, Geoff! And, you're right, the code looks like this: .ActiveDocument.ActiveReport.ExportAsExcel , sPutPath & sFileName Thanks and regards, Rud

Thanks Geoff. I'd really appreciate it. Why? I work for a gov't entity. We have databases in Oracle, DB2 and Sybase. This agency has the firm belief that BO is the ultimate reporting tool. It took me six weeks to convince them that, in the Sybase case anyway, I could do a lot better with...

An SDK license? Bummer. I've automated other progs without an SDK license. You're sure about this?

Ummm, Steve? You said, "There is no such edition of office as "Developer"." Are you telling me that the retail version of Office I have that says "Developer Edition" on the front of the case is a Micrsoft typo? Uttering absolutes, especially if they're wrong, in a public forum is one of the...

I've looked around and haven't seen what I'm trying to do. I would like to open, refresh and export a report as an Excel spreadsheet from a module in Access. I found a couple of code examples around but, not knowing the BO object model I'm fumbling around quite a bit. Does anybody have any...