Search results for query: *

Italy: Think the issue is the trim() function so you might like to try the following version which doesn't need it. if ({TH_PA_WBA_V.REC_TYPE}="B" and instr({TH_PA_WBA_V.WORKING_STATUS_CODE},"WORKING")>0 then {TH_PA_WBA_V.BURDENED_COST} else 0 David C. Monks...

Italy: Thanks for posting those but now you'll need to post the constituent parts i.e. @DetBugWorkingCost, @Department etc. so we can try and track this down further as there is nothing here which could explain your problem David C. Monks david.monks@chase-international.com...

sandrews: CE8 is the replacement for Info so the question is not whether you should use CE8 but when. There are a number of differences between the current releases of SI7.5 and CE8 but over the next few months there are expected to be more releases of CE8 with more of the Info functionality...

Italy: Icytrue was suggesting that if you can show us the formula we will be able to see if there is anything there which is causing your zeros! Check that your Info Server has access to all of the data needed to run the report - it is common for a report to run in the Report Designer (uses the...

matahari: This is commonly an issue if you are using Oracle 7 and the database is set to backup automatically everynight. Solutions if you are: 1. move up to Oracle 8 or 8i (if the latter make sure you download the revised ODBC driver from crystaldecisions web site first!) 2. back up at less...

buckwheat: Sure - cheat!! If you create a formula field (@cheat) which merely has the original item # as its formula you can then select that within your specified group David C. Monks david.monks@chase-international.com http://www.chase-international.com Accredited Crystal Decisions Enterprise...

jfrenzel57: You'll find a helpful download on the Crystal Decisions webite (http://suppoer.crystaldecisions.net) which has 25 or so sample formulas to help you get to grips with the topic David C. Monks david.monks@chase-international.com http://www.chase-international.com Accredited Crystal...

Salvatoref: I think you have not understood the use of the store and fetch process. Storenumbervar will store the value you choose with whatever frequency the section you place it in will print i.e. if you put it in the report header/footer only once, if you put it in the details once per...

Snowdude, Will check this out and get back to you. David C. Monks david.monks@chase-international.com http://www.chase-international.com Accredited Crystal Decisions Enterprise Partner

Italy, Not sure I kmow why Oracle 7 stops the services from restarting automatically - the client used to have to do a manual restart every time until we moved to Oracle 8. I would suggest that if you can you do the same. You say you migrated the APS database manually - did you use the Data...

Frobisher, We've found that other clients have eliminated similar problems through a programme of continuous clearance of cache and temp files - this is why Crystal suggest not to use qry or dc5 based reports because they generate vast amounts of temp files. As each file requires a handle and...

SteveBell, I suggest that you quiz Crystal on the EXACT spec. of Enterprise for Baan - make sure that the first release of CE supports your existing or planned reporting requirements (there are to be a number of releases of CE throughout the year with additional functionality) There are 2...

Italy, What database are you using for the APS system? Does this get taken down for backup every night? I have a client who was using Oracle 7 who had exactly the same issue - services would not restart after a shut down for backup of Oracle7, we solved it by moving the APS database to Oracle 8...

Steve, Do you get the same result if you save the report to the local machine and then add it to the folder rather than save on the APS? David C. Monks david.monks@chase-international.com http://www.chase-international.com Accredited Crystal Decisions Enterprise Partner

Bessebo, Doen this many times. Some documentation about but not to hand as I write this. However, try the following: 1. Install Info on the new machine using the default Access (cinfo.mdb) database 2. Copy onto the new machine the entire contents of both the input and output subdirectories...

Hi Snowdude, Error 2140 is generated either when the service is already running (as in Sentinel is running as a process and an attempt is made to start it as a service) or as a result of a dependent service not having been started successfully - you can achieve the same effect by setting the...

VE: There is a UDF available to convert Btrieve/Pervasive numbers to dates and vice versa. Drop me a line if you need it. I agree with rhinko that this could be the problem. David C. Monks david.monks@chase-international.com http://www.chase-international.com Accredited Crystal Decisions...

SnowDude: You can run Info 7.5 and CE simultaneously - I'm doing so as we speak. All Info settings (those that are used by CE) remain in effect. If you want to replace Info with CE then I suggest you install over the top of Info (you may have to manually remove the program group) David C. Monks...

lester50: Unfortunately I don't think it is possible to access the format formulas via Craxdrt. I'll double check and if I find anything post again. David C. Monks david.monks@chase-international.com http://www.chase-international.com Accredited Crystal Decisions Enterprise Partner

PlaidEmp: Try these for size! 2 formulas - First one gets hour of task - Group report by this, Second one counts tasks per hour @EachHour NumberVar HourPortion:= Val(Mid({TASKS.REQTIME},1,Instr({TASKS.REQTIME},":")-1)); NumberVar AdjustedHour:= if...