Search results for query: *

Hello friends, this is my case Example: ZONE Case Volume AB AB01 10 AB AB01 20 For this Case I should Get Total Volume 30 ZONE Case Volume AB AB01 10 AB AB02 10 For this case I should get Volume 10 ZONE Case...

I have data like this Zone Case Volume AB01 DCDC 10 AB01 DCD2 10 AB01 DCD3 10 For this Total Volume should be 10 for Zone AB01 Zone Case Volume AB01 10 AB01 10 AB01 10 AB01...

Hello friends need some help on this I have group on field A and anfd Im showing Summary in Group Headrer on Units. Below is the example data Group Summary A 20--------------Group Header B 5 C 1 thing is i want to show whatever the summary value I get for A , I want to show...

Hello friends, I have a data like this Zone Stat Volume AUTO 30 100 AUTO 30 100 Auto 65 100 Auto 65 100 Auto 65 50 I am grouping on Zone then Stat, and now my problem isI have to average volume for each stat in this way AUTO 30 100...

Hello , I have a question. I wrote a Command and I have been pullin up data from that Command table. But now I will repointing Command from Devlopment to Production. Can this be done, I know this can be donr if we use table instead of this command statement. So any other way to work this out, I...

Hello friends , I have a report like shwoing details in which one field in displaying no of hours. For example Group: 24hrs abc 234 USER 24hrs SSD 765 GUI 24hrs Group:48 hrs GFD 990 TMD 48hrs Group:72hrs BCC 754 CCM 72hrs I like to show in this way Group:24 - 48 hrs abc 234...

Hello, I have two date fields Created date and modified date. Suppose if Create Date = 1/22/2007 modified date = 1/23/2007 then I used formula whileprintingrecords; numberVar dur := datediff("s",{@Date1}, {@Date2}); numberVar hrs; numberVar min; numberVar sec; stringVar hhmmss; hrs :=...

Hello all I need to conver the number to time numbers can be of format 163,321.00 or 93,429.00 I did this FORMULA FOR “@PHPTCR” if tonumber({PHPICK00.PHPTCR})<100 then "0000"+ totext(tonumber({PHPICK00.PHPTCR}))else if tonumber({PHPICK00.PHPTCR})<1000 then "000"+...

Is it possible to set-up crystal to not worry about the paper size? For example, in Excel you just make the data and it makes the worksheet as large as it needs to be. Any ideas? Thanks a lot M.

Hello frinds, I have a field IDCASE, and I am doing count on that where IDSTAT> {?Parameter}..this works fine for single values. I want to display the values for IDCASE where IDSTAT>1 in first line, then values of IDCASSE where IDSTAT>>2 in second line and so on upto 10. So that users dont have...

Hello friends, SELECT Count("PHPICK00"."PHPCTL") as CountPHCTL FROM "IASP1"."WMDIBSF05"."PHPICK00" "PHPICK00"..this works fine in Command. But I want to direclty do Count("PHPICK00"."PHPCTL") for PHPSTF = 00 or 10. I like to know how we write for condition. I dont want to use where becaus I...

Hello friends I have this situation, I have the fields DivertLocation, Priority, Stat, (ShipPoint,Sortpoint,ShipVia,Rule(allthese 4 fields use samefield IRFLNM) each of those 4 fields use different selection criteria like if for SHIPOINT--irflm=09 then "YES" Sortpoint--irflm=33 then...

hello friends, if you want to append the formula values into parameter this is the way Go to the database expert and then command in that enter (CASE WHEN "IDCASE00"."IDDCR" <> '' THEN ({fn SUBSTRING("IDCASE00"."IDDCR",1 ,4 )} || '-' || {fn SUBSTRING("IDCASE00"."IDDCR",5 ,2 )}|| '-' ||{fn...

Hello friends, I have converted a number to date in a new formula field and now i want to append all those coverted date formula values into my paramter so that user can know waht date are present on the report and he can choose the date. Can anyone give any idea on this. Thanks a lot. Reed

Hello friends, I converted a number format into date field and now i want to append all those values which in in formuale field into my new created paramter. Can anyone please suggest something on this. Thanks a ton. Reed