Search results for query: *

I'm working on a BO universe at the moment and getting a SQLSTATE=42622 error, it is telling me that the names of a couple of my tables are too long (maximum 18 characters). It tells me this when i am checking the integrity status. I've tried re-naming the tables in question, but I'm still...

I'm running a query on a db2 database and i'm having problems using the max date as a condition. Basically the field is called diry_ts and it relates to several events within a particular case. I want the report to show me cases where the last diry_ts date is over a month ago, but the report...

The most bizarre thing has happened to me, I've got a condition that uses a between query prompt at report level. The date is formated at universe level as dd/mm/yyyy, the start date prompt i have added works fine i enter a date using dd/mm/yyyy format and averything is ok, however the end date...

I've just come accross a universe design issue which i haven't attempted before, so was wondering if anybody had a solution. Basically i have a table called Person, the primary key of this table is PersonID, and it contains all details relating to an individual. Within the table is a column...

I'm currently working on a new universe and am having problems with an object. The object is a character and it parses OK, but when i use it in a report i get the following error message: [IBM][CLI Driver][DB2] SQL0502N The cursor specified in an OPEN statement is already open...

I've been given this code to get a Business Objects report to go through all available variables in a particular field, filter the report by that variable and save the output to a file whose name is based on the variable. It works fine but i also need to incorporate a stage to e-mail the report...

I'm doing a bit of work on a universe at the moment based on a db2 database, however whenever i try pick more tables to insert i get the above error message with details as follows - [IBM][CLI Driver][DB2] SQL0969N There is no message text corresponding to SQL error "-725" in the...

I'm currently in the process of building a new universe based on a db2 database and have found several loops. I've gotten around this by creating aliases of the looped tables, which seems to work ok. However, a colleague has told me that i should try incorporating contaext in a loop situation...

I'm reporting on a db2 database and am having a problem with max dates. At universe level i've created an object (based on a date field in the database) as a measure and asked it to show me the max of the field - however, i'm getting returns which are not the max date of the field (in fact they...

I'm running a report based on a db2 database and i need to perform a calculation based on the first day of the month of one of the fields that i'm using. Then i need to find the number of months between this formatted date and the 1st day of the current month. I've used this new variable to...

I produce a daly spreadsheet in Excel with three colums, a code, a name and an amount. The daly worksheets are inserted in a weekly woorbook. A vlookup formula is then entered into the fourth column of the worksheet to look up the previous days value, this is then autofilled to the end of the...

I've been using Business Objects for about a year now and have found it to be very useful, however I've just been rumuging through a software liscence storage database and it appears that we also have Infoview. Now I've located the BO instalation disk but have a few questions, was wondering if...

I've got two spreadsheets - The first is copied from an Access table and it contains a filed called ID along with a bunch of other data. The secound is from another source and I'm informaed that it was made using only Excel. I'm trying to get some data from the secound sheet into the virst...

I have two queries, the first contains all of my population of data, the secound contains all the data which i don't want to include in my final report. All of the secound table is contained with the first and both tables have a common field TblID. I basically want to do a minus query where i...

This is a general query, but one that i've been wondering about for ages. Basically i want BO to use each item in a table (possibly generated by another report) as a prompt to a query. So say for example my query has a prompt, and i want each item in column1 of table1 to be used as a prompt...

I need to get a report to run overnight and printout on a printer which i wouldn't normally use. Does anybody know how i can set the active printer from VBA?

I'm currently running a report based on a single universe which has a set of conditions a, b and c... This works fine. However i want to add another set of information based on the same table, with a common linked field to my previous report but with condition d. condition d will only only...

I've just made a Universe which is hooked up to an Access Database. Everything works fine, apart from one date field. The problem is that i don't seem to be able to use it as a condition (I get a return of no data to fetch, when there is definitely data to fetch), I've checked it's properties...

I'm running a BO query over an NT platform using a DB2 database and i'm having a few problems using a date as a criteria. For the criteria that i'm using i need only the month and year part of the datestamp of a particular field. I've tried formatting the day part out of the equation, but this...

I'm currently pulling my hair out trying to figure this one out so any help will be appreciated. Basically I'm running a report that includes a date of death field, I want to run the report on a monthly basis and each month it should only include items that have a <date of death> month of 9...