Search results for query: *

Thanks to everyone who has helped out. I have been able to get a 2 SQL solution, and merging the results, and to prove it I have attached the SQL for the MIN of Start value, in case anyone else has this problem. select TABLE.PART, TABLE.START, substr(TABLE.PERIOD,1,7), TABLE.PERIOD from...

I currently have a report which has data laid out as shown below part monthend period start end fred 2004-01 2004-01-1 100 150 fred 2004-01 2004-01-2 150 350 fred 2004-01 2004-01-3 350 250 fred 2004-02 2004-02-1 0 50 fred 2004-02...

I have a user who wants a chart to show a trend line (just like on Excel....[bigsmile]) Does anyone know if such a function exists on BO v5.1? to be specific it is a Linear trendline which Excel says is:- ------------------------------------------------------------ Linear Calculates the...

Hello all, I have been asked to produce a report which shows all reports which use a certain table, across a number of universes. I am using the REPOSIT universe and can display the universe and table names, but I cannot find where or how the report name is identified, so I cannot find out...

Hello, I am currently have the following data Part, Qty Sold, Date Sold which I am trying to display in a report where the sales are grouped by month. The report I am trying to create is the one shown below: Widget Jan Feb Mar Apr May Jun Jul Aug .. Dec 123 Nil...

Basically what I am looking for is the ability to detect whether a measure object has been set up to have a default value of null. As far as I can see there is no 'default value' section when you set up your measure object. The only other option I can see at present([sadeyes]horror!!!) is to...

Hello there, As a newbie to this forum, I hope this is not too easy a question. I have had a look in here but cannot find an answer(yet). I need to find identify objects which have a null value in the universe, as these cause record links to be dropped. I have had a look in the repository...