Search results for query: *

I have a table that has the following data: TABLE NAME = ASSIGNMENT DEPT ASSIGN DATE FILE# ABC 10/06/05 1234 DEF 10/06/05 1234 GHI 11/10/05 1234 CNC 11/11/05 1234 Each record (file) has multiple rows of data. I would like to be able to do an AGING on the number...

How do I color a field Both items...IF it is duplicated with the item above or below? IF duplicated I would like to isolat those by shading or color. Thx Thank you. MV "A man is only as happy, as he makes up his mind to be....

We are contemplating purchasing the ENTERPRISE edition of CR XI. We already use CR XI Developer's Edition and want users to be able to access reports via web..etc. Does anyone have any guidance on what to look out for when installing CR XI Enterprise...I need both pros and cons of the program...

When I use the following formula in Group Select will this allow ALL items to be imported INTO the report AND THEN summarize by the formula? {ASSIGNH.Assignment Date} = maximum({ASSIGNH.Assignment Date},{BKCYAcct.Acct File Number}) When I use formulas like this, I notice my counts are much...

I'm seriously looking to get some insight from someone that has experience with CR SERVER and also has tried the 3rd party VIEWERS/EXPORTERS etc..to see what the benefits are of using either of these products. Thank you. MV "A man is only as happy, as he makes up his mind to be....

How would you recommend me becoming familiar with Delphi, are there online classes?? What would you recommend? Thank you. MV "A man is only as happy, as he makes up his mind to be....

I'm sorry but I do not know what version of CITRIX I have, but I'm trying to install on my home computer. The install program starts, but it immediately give me the error: ERROR 1606 UNABLE TO ACCESS THE NETWORK \ My OS is Windows XP Professional SP 1, and the error happens early during the...

I'm receiving the following error when creating a union all command. FAILED TO RETRIEVE DATA FROM DB. SYNTAX ERROR CONVERTING THE VARCHAR VALUE '[LPO' TO A COLUMN OF DATA TYPE INT. Any ideas? Thank you. MV "A man is only as happy, as he makes up his mind to be....

I'm using the following "composite expression" in my select expert and it is NOT working: {@File Type} IN ["Bankruptcy Files"] and {Command.WIP_Cost_Dollar_Value} > 0.00 and {Command.System Closed Date} >( Date (2005, 11,30)-45) or isnull({Command.System Closed Date}) IT is ignoring the...

Has anyone found a work around the problem of trying to export a crosstab, when one of the row heading data elements is SUPPRESSED? I get an error when trying to do this,... failed to export...when I go into the crosstab and UN SUPRESS the ROW headings it then exports. Thank you. MV "A man...

I'm receiving an error when I try to VIEW or PRINT and nothing seems to be working. The error is: Logon Failed Database Vendor Code: 18456 ANY IDEAS???? Thank you. MV "A man is only as happy, as he makes up his mind to be....

IS it just me or are parameters...confusing.....as....!!!!!!!! Thank you. MV "A man is only as happy, as he makes up his mind to be....

Does it matter as to the order of the data elements within a UNION ALL statement... in regard to enhancing the SPEED of the processing? My union all command takes about 1 hours to process, granted I can live with this time frame, I'm just wondering if union all statements can be tweaked in...

How can I take the CURRENTDATE and extract ONLY the month and day in the following format? 11-18 I want to test an idea I have for this formula, but I first of all need to be able to extract and place the MONTH and DAY into text as above. Please advise THANKS Thank you. MV "A man is only...

I've been asked to work on an exportable report that will export into a TEMPLETE in EXCEL. The problem is that I have to use NUMEROUS CROSSTABS in order to pull the data and the all do not line up when exporting. They are now trying to write a program in DELPHI that will use an excel...

I need to access some data and wondering if anyone knows anything about a program named AREV.....from Revelation Technologies?? I "think" these are FoxPro Tables (.dbf) but not sure. Any help would be appreciated. M Thank you. MV "A man is only as happy, as he makes up his mind to be....

I have a few Crosstabs that I use to export data to excel. I cleanup data in excel and distribute to management. I would like to export directly to PDF, but I'm having problems with having a page header print for the crosstabs? Is there some way to format a crosstab section to have its own...

WHat is the maximun elements taht can be used in an array? I'm trying to use the SELECT EXPERT to pull a ONE OF type data. I've copied the listing from my excel spreadsheet and HUNDREDS OF ITEMS>..and CR XI is telling me that there ARE TOO MANY ITEMS IN THE ARRAY>..//??? Thank you. MV...

I need help. My field may have either: PRIOR FILE NUMBER 1234-N1234 OR PRIOR FILE NUMBER 1234-N-1234 I need an extraction formula that will extract the number and place it in the following format: 1234-N1234 I did a RIGHT({fieldname},10}) but the SECOND DASH is cause it to be inconsisten...

Just curiuos, I don't get a folder option when I export to ODBC. Is there anyway to choose where the export ODBC file is going to be place????? Thank you. MV "A man is only as happy, as he makes up his mind to be....