Search results for query: *

I will try that and let you know, thanks a lot for you help.

Crystal 11, Heat, SQL server, tables calllog assignmts For each call there is either one assignment and it is resolved by first level. Or it was reassigned to second level. I would like to list the re-assigned calls only along with rest of the assignments. sample data CallID Date...

From the help file" In order to use shared variables, the variable must be declared and assigned a value before it can be passed between the main report and the subreport.

I meant that I am using 2 reports one with joins and one without. I created the command one thinking that it was my joins that was causing the hold up. But they are both the same in the result since there is only one record of subset per callog all it is really is the customer info. Callog is...

I have a another Crystal report created from template with joints and still takes the same amount of time. The people from DBA said it was an indexing issue, but too busy to help fixing. If I remove that client formula and just indicate one type of customers, then it works like a charm...

Hello, I am using Oracle and CR XI. This is the command that I am using. The second code is for a formula in the report that I am also using, but because the field is not indexed, it takes about an hour to run. I would like to insert an equivilant formula in the SQl query to make run faster...

If there are no letters at all, then create a formula and convert the values using tonumber tonumber ( {table.field} ) The sort it

That was it, Thanks A LOT lbass.

The problem is that there are tickets with out any journals at all. So I have to find a way to have either the last journal show up, or a statement such as "No Entries" added instead of the journal entry. That is why I have a left outer joint. Is there another approach, where I can capture the...

I changed them to meet my field names otherwise it would not have worked at all. {@JournalDateEntered} = maximum ({@JournalDateEntered},{CALLLOG.CALLID}) I am wondering if I can make an IF statement that will look like this If ( There is at lease one journal) then {@JournalDateEntered} =...

I think it has to do with the statement in the bottom. I think it is being supressed because it does not meet the condition below. {command.timestamp} = maximum({command.timestamp},{command.ticketnumber})

if isnull ({JOURNAL.ENTRYTEXT}) Forgot to mention that I tried Jorurnal.callid, entrytime, entrydate. Still does not work.

CALLLOG"."CALLID" can not be null, I just checked //@NullJournal StringVar ticketid; if isnull ({JOURNAL.ENTRYTEXT}) then (ticketid:= "Does not Have Any Journals") else ticketid:= "Entered"; ticketid they all show "Entered" and the ones that are not showing are do not have. They are in the...

SELECT "CALLLOG"."CALLID", "CALLLOG"."RECVDDATE", "CALLLOG"."NATURE", "CALLLOG"."ITEM", "CALLLOG"."CALLSTATUS", "JOURNAL"."ENTRYDATE", "JOURNAL"."ENTRYTIME", "CALLLOG"."CALLDESC", "JOURNAL"."ENTRYTEXT" FROM "HEAT"."CALLLOG" "CALLLOG" LEFT OUTER JOIN "HEAT"."JOURNAL" "JOURNAL" ON...

I used yours {command.timestamp} = maximum({command.timestamp},{command.ticketnumber})

From the Crystal XI help file "Shared variables use the same memory block to store the value of a variable throughout the main report and all of its subreports. Thus shared variables are even more general than global variables. To use a shared variable, declare it in a formula in the main report...

Thanks patriciaobreja I looked over that thread http://www.tek-tips.com/viewthread.cfm?qid=1443723 and now, I have another problem. Tickets with no journal entries do not show up. My joint is set as left outer. The sum shows 3 but one of those 3 incidents does not have journal entries so it...

Hello satinsilhouette thanks for your help, but that got me the last entry of all journals in all of the tickets.

If you wanted a group made for this, then create a formula. --------------------------------- @AgeGroup --------------------------------- stringvar AgeGroup; numbervar AgeYears; //finding the number of years. ageyears:= year(currentdate) - year (birthdate); // Labelling the age group if...

Hello All, CRXI & Oracle, Call Center Enviroment. I would like to show the last journal entered in each ticket selected. want it to look like this Incident#(Num) Account(Num) Name(Str) ---LastJournal(memo) Each incident could have a lot of journals, I am only interested in the very last one...