Search results for query: *

I get following error in Infoview: The viewer could not process an event. Your request could not be completed because a failure occurred while the report was being processed. Please contact your system administrator. [RCIRAS0546] ---- Error code:0 [CRWEB00000119] I can see few first pages from...

I have to find overtime hours where employee was called to work immediately. There are following field in database: datetime, employee, salary type. To the field salary type is marked overtime 50%, overtime 100% or alarm. I have to find overtime rows where same employee has marked alarm to same...

I have to calculate difference between two running totals and show result in graph. And I made formula that calculates difference between two running totals. But it is not possible to add that formula to graph. What can I do?

When I try run report from Infoview, I get error message: "Unable to create report page". This problem happens with several reports occasionally. With one report this happens most times when I try to run report, but not every time.

I have problem with Businessobjects Infoview. I have slow report. I am able export it if I just export it when first page appears. If I try move to last page it takes about 35 minutes and Infoview asks to logon again. And run report again... I changed timeout settings in CMS...

I get that error message when I try to run a report from Infoview. I have problem with two reports. Other reports work fine. I get that error sometimes and sometimes I don't have any problems to run these reports. So I can't find out reason to these error messages. Does anyone have similar problems?

Running the report takes long time, over 20 minutes. I had to increase timeout from Crystal Report Processing Server (default is 20 min). After that I can run the report but I can't export the report. I get error message: "The viewer was unable to process the request." How can I solve this...

I have time in form: 14:14:52 (hh:mm:ss), 24 hours. How I can remove seconds (new form 14:14)?

I need to calculate the age distribution of warehouse. I made a formula which shows stock value if there is no events for stock item in five years. {@sum} if ({@year} < ({?year}-4) and (sum ({@stock_event}, {@year}) > 0)) then {stock.value} else 0 But I also need total stock value of stock...

I have date in form year and week, eg. 200452. How I can get first day of that week in date form, eg. 12/20/2004?

I have in selection formula condition: {@next_day} < {?end_date} //end_date is a parameter field {@next_day} datevar nextdt := {@begin_date}; numbervar i := {period}; while nextdt <= currentdate + i do (nextdt := cdate(dateadd("d",i,nextdt))); nextdt When I try to run report I get error...

I try to illustrate down-time and repairing work hours to machines. In my report I have group by machine and by work order code. I get down-time from one table and work hours from other table. Work order code is a link field between tables. Problem is that when I insert summary of work hours to...

In database there are date and period in weeks. I know that I can count next date with dateadd function: dateadd("ww", {@period}, {@date}) But I need to add so many periods that result is bigger or equal than today. I think I need while loop?

I have a parameter field (static) where are two values: XX and YY and field allows multiple values. And code in selection formula is: if {?department} = "XX" then {WORK_ORDER.DEP_CODE_C} in ["AAAA", "BBBB"] else if {?department} = "YY" then {WORK_ORDER.DEP_CODE_C} in ["AAAA", "CCCC"]...

I try to calculate downtime for machines. I know starting time and ending time for repairing works. But problem is that there can be multiple repairing works same time for same machine. I should not sum simultaneous repairing times. Is it possible to make a formula that sums repairing time...

I have dates in database so that there is a year and a week of the year, for example 201029. And I need a formula that calculates first day of the week, for example 201029 -> 19-jul-2010 (monday). Is it possible to make a formula to do that?