Search results for query: *

Hi All I am trying to get the last valuation date using "previous" if the date is not the 30 June 2003.. I wish to display all dates that are the 30 June 2003 and if not then the previous valuation date. I am using the formula as below which is working fine ({ASSDEPRE.DEPRECDATE}) = Date...

I wish to calculate the remaining life of assets at a specific date based on the info below:.. ASSVALUE.ACQDATE..(Date/time stamp) - Acquisition Date ASSVALUE.EXPLIFE..(Life in Years) - Expected Life in Years..(eg 30) Currently I have a formula in an existing report (not developed by me) as...

Hi Team I have a formula below that works as I need to find dates greater than one year...but I also need it to calculate when the PURCDATE is greater than the ACQDATE as well.... as i have some PURCDATE fields (1988 - later) and some ACQDATE fields (1975 - earlier) Should I use ABS...

Hi All I have a DateTime Field in a front end program that has a oracle db backend.. I want to extract data for a date ..eg (June 2003) from the database using Crystal 8.5 I have tried the 'ToText'...but need to get all entries for a specified month. Any help asap would be appreciated. Thanks...

Hi Team I have the following error generated in a Seagate Info Vs 7 excel report...Can anyone give me an indication of what is causing the problem asap.. ".....When report is exported to excel, when asked to print - Printer tells me bad communication, & I have to override. Printer then...

Hi Team I have the following error generated in a Seagate Info Vs 7 excel report...Can anyone give me an indication of what is causing the problem asap.. ".....When report is exported to excel, when asked to print - Printer tells me bad communication, & I have to override. Printer then...

All I am interested in a MSAccess97 db that caters for Human Resources...etc. Unsure whether this is the appropriate medium but if anyone can assist with freeware/shareware solutions without re-inventing the wheel that would be great. TIA acr

All We use a copy of Seagate Info (Reports Vs 7) on Citrix with a 50 User license. Can anyone advise if their are any limitations to the number of folders and subfolders that can be setup under the Administrator(for security) and the Desktop. TIA

All We have a need to transfer and existing copy of Seagate Info Vs 7 to another server as a result of a server upgrade... Because of its now lack of support..I would be greatful if anyone had a copy of the Installation details..This is Urgent..!! TIA

Team I have a folder and sub folder structure...setup geographically to keep everything tidy on Seagate Info Desktop Vs 7.0. However I wish to assign user rights to one of the sub folders only so that the user can only see the appropriate sub folder and non of the others.... I seem to have...

Team I have read all the threads here regarding cinfo.mdb. My question is that our copy of this has blown to over a gigabyte. We are using SI Vs7.0. My questions are:... 1. Can we compact with MSAccess97. 2. Should we repair/compact..?? 3. What causes the 'bloat' in the cinfo.mdb...??? 4. and...

Team When viewing a report using Info Viewer in SI version 7.0 We get the following error..while trying to use the Selection Expert. "Could not find an Info Server to process this request. Please enable Info Server for viewing using Info Admin. Also, make sure that the Info Agent is...

All, I am impressed with the replies I have read here recently in the last few weeks and obv plenty of Oracle gurus.. My question is as follows:.... I have a range of data that I need to report on as in the example as follows; Note that the SOR range is only part of the total SOR range...

All, I have posted this to the data access forum as well as am unsure who reads what..... I have a range of data that I need to report on as in the example as follows; Note that the SOR range is only part of the total SOR range (10000-99999) Where the defect code = 1064 and SOR is in the range...

All, I have a range of data that I need to report on as in the example as follows; Note that the SOR range is only part of the total SOR range (10000-99999) Where the defect code = 1064 and SOR is in the range 18050 - 18999 (inclusive) then the fault code = 3133 Defect SOR Range...

Is anyone aware of any bugs with Seagate Info Vs7.0 with Outer joins...???? TIA

Team I have a report developed in Version 8 and saved in Seagate Info Version 7 (We are using Vs 7). I however cannot change the data source as I wish to point to a different ODBC connection...(and database) Can anyone advise if this is possible please... and/or any workarounds.... TIA

Team I have I assume an array that I need to incorporate in my SQL query... The scenario is as follows:... Where the defect code = 1064 and SOR is in the range 18050 - 18999 (inclusive) then the fault code = 3133 Defect SOR Range Fault Code 1064 18050 - 18999...

Team I have I assume an array that I need to incorporate in my SQL query... The scenario is as follows:... Where the defect code = 1064 and SOR is in the range 18050 - 18999 (inclusive) then the fault code = 3133 Defect SOR Range Fault Code 1064 18050 - 18999 3133 1065 18050 -...

Team I have a report that I wish to ouput to MSExcel. It is working well however one of the fields has to remain blank. When I output To Excel the field is 'lost' unless I populate it with something. I am using SI Vs7.0. Can I output an ACSII code or something...Or can I format in Seagate Info. TIA