Recent content by bubu2006

Hi, I have few reports which users have created recurrence instances. If I update any existing report which has a recurrence instance do I have to recreate the recurrence instance all the time. I have report which is using SQL command also I have report with procedure. I am using BO XI R3 and...

We are migrating Business Objects XI R2 server to business objects XI R3. We have both enterprise and LDAP users. Following steps have been taken before the import took place 1. Installed business objects server(R3.1 & SP4) – OS is Windows 2008 server 2. Configure LDAP server We are using...

We are migrating from business objects XI r2 to R3. Operating system is windows 2008. I have reports which are using DB2 9.5 as backend DB. Those reports are using CR DB2 Wire Protocol ODBC Driver 5.3. When I have tried to create those ODBC connection to my new server I cannot find those CR...

I have a column called price which returns following data (e.g) 0.0980 0.9877 0.7890 1.2345 1.2350 I would like to display the value the way it is. It's a numeric column. Can anyone help me to do this? I need to display trail zero. I am using Crystal XI r2 and db2 9. Thanks in advance. bb

the thing is I can not use sql expression. Also I can not use min function in select criteria.

I have a date column called my_date in my database view. I want select data in the report when minimum(my_date)>currentdate. I can not write this in selection criteria. I have tried to create a formula but that is not available in selection criteria. Is there a way I can use this in the report...

can I write following SQL SELECT * FROM emp e PIVOT (e.SUM(sal) FOR e.deptno IN (10,20,30,40)); I am using Oracle 11G.

Thanks LBASS.

Because we are converting days series from number to string the sorting is not perfect. I am attaching the file. The formula I wrote and the help I got from fisheromacse and labss all have same issue. I am creating a crosstab with that formula and putting that into my crosstab row. I have tried...

I guess the sorting order is not working properly because I need to convert that as string

this is doing the math but not working properly. I am getting values from 1021 not from 121. So it is adding 1001 instead of 1 with 120.

I was getting same value with my code before I switch to if..else, Your code is returning values like 1001 to 1030,1002-1032.. and so on. Not going to 120,150 series.

I have a formula which has following code if {@number of days}<=120 then '0-120' else if {@number of days} >120 and{@number of days} <=150 then '121 - 150' else if {@number of days} >150 and{@number of days} <=180 then '151 - 180' else if {@number of days} >180 and{@number of days} <=210 then...

(@number of days}=date1-date2

I have tried o write this but for loop is not working stringvar str; numbervar nod:=120; if {@number of days}<=nod then str:='0 to 120 days' else if {@number of days}>nod then (for nod:=120 to 5000 do str:=totext(nod+1,0)+'to'+totext(nod+30,0)+""+'days') ; str