OR...
DEPT ASSIGN DATE FILE# DAYS
ABC 10/06/05 1234 0
DEF 10/06/05 1234 1
GHI 11/10/05 1234 36
CNC 11/11/05 1234 1
Thank you.
MV
"A man is only as happy, as he makes up his mind to be....
The final report should look like this? Or give me the data so that I can obtain the data.
DEPT ASSIGN DATE FILE#
ABC 10/06/05 1234
DEF 10/06/05 1234
GHI 11/10/05 1234
CNC 11/11/05 1234
FROM-TO DAYS
ABC-DEF <1
DEF-GHI 36
GHI-CNC 1
I need to do something like...
I'm thinking I'll need to do a Command Prompt at DB level in order to track the change of departments by dates? I need to AGE the amount of time that a file is in any given dept. Within he same dept, it can appear numerous times...with differen dates...but I would need to age only on the FIRST...
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...
Thanks LB, I'll try that... Can you give me an example of the command? Would it be in the same format as the GROUP SELECTION command?
Thank you.
MV
"A man is only as happy, as he makes up his mind to be....
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 have one downloaded, but I'm seeking REAL WORLD input from someone that has used both..and which they prefer and WHY.
Thank you.
MV
"A man is only as happy, as he makes up his mind to be....
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...
Thx LB... It DID error out, but your second reply helped..
thanks as always for your expertise
Thank you.
MV
"A man is only as happy, as he makes up his mind to be....
Here is the logic... after this data element..."BKCYACCT"."Client Type", I added the next data element, but it is only in 2 tables and so I had to "0" fill the others...I get the error....any help is appreciated
SELECT 1 as whichtable,
"B1_WIP_CosDetail"."Matter_ID"...
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....
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.