Search results for query: *

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

I have a formula number of days which calculates number of days I want to write a formula called age and create a group on that in the report. formula logic If the number of days >=120 Then display 0 to 120 Else for each next 30 days display Previous maximum days +1 to previous maximum days...

I am also using LastFullWeek. My week is from Monday to Friday. The report will run each Monday morning for last o Monday to Friday. No issue in using the function if I ran the report. Now I want to display the date range which is last Monday and last Friday in the report even if I test the...

I can not see that LDAP group so that I can not add that.

I have already tried to manually update that user but did not find that group.

I have found the issue. If I check the group I can see the users but if I check the user and check for members of then I can see they have added to everyone group not the specific group. So that is the reason neither folder rights nor row level security is working. Do you have any ides how to...