Search results for query: *

Here at my company, we have to report product data for many different products: ProdA, ProdB, ProdC. Is it possible to have ONE .rep file with a script that will handle each product? ***For example, I want one file to do this*** -Refresh report (Select * From Table Where...

I have a query that displays some data including a sorted email address column. When I use the DocumentVariable class however, my Email Addr column is no longer sorted. The data appears to be almost randomly accessed and entered into my array(below). How can I make my DocumentVariable class...

Is there any way to get the actual values of result objects (not just the name) using VBA? Please advise! Any ideas are GREATLY appreciated! Below: In the BOSDK documentation it describes the Result Class. But it only allows you to get the name of the class and the name of the object...I...

I need to merge 3 columns in BO. It looks something like this: TestDate Data1 Data2 Data3 1/2/01 12 10 7 . . . . . . . . I want merge Data1 Data2 and Data3 into one big column so I can accurately calculate standard deviation and...

I have a fairly basic question. I have 4 columns of data: Measurement1 Measurement2 Measurement3 Measurement4 ============ ============ ============ ============ 7100 7105 7200 7112 7202 7302 7155 7010 How can I calculate the average of all the...

I need to retreive only the latest spec data from my database. It looks like this. Date Upper Spec Limit 1/4/96 5000.00 2/4/97 4932.00 6/7/99 4950.00 How can I set a condition to only display the Spec Limit corresponding to 6/7/99 (the latest date)?

I have a question regarding a Business Objects chart. We are using BusinessObjects Ver: 5.1.2 and are having problems with the graph axis. In the Axis Label Format window the Minimum, Maximum & Major Unit Boxes are all checked for Auto under the Value Axis Scale and the Decimal Box is selected...

Is there any way to use a variable in the naming of each report. For example, I have 4 report tabs in my BO file. When I double click the tab to rename it, is there any way to use a dimension or measure as that name? Thanks.

I have several charts created in BO and the data points are colored black and red. However, when I post the charts to Infoview, the data points are random colors (yellow, light green...hard to see). If I save as HTML the colors appear just as they should but when posting to Infoview they...

I need help on making a query that will report from a date range of (the current date - 12 months) to (the current date). I need the previous 12 months worth of data reported whenever the report is run. Any ideas? Thanks alot!

When I create my reports in BO, I need to see data from 2000 to 2001. However, I need to use a data value in a calculation that is pulled from 1999. Is there any way I can have my report date range be in the year 2000 or 2001 yet still use data from 1999 in the report? For example: I'm...

I'm generating a report off of my universe. I have a basic example shown below. I need to be able to subtract Data2 - Data1 but I cannot because they are not aligned. Is there any way I can get rid of the empty cells in my columns to align the data so I can subtract Data2-Data1 and...