Recent content by dhv919401

I am eargerly waiting for any clue. Any thoughts from anybody please? Thank you,

I have the following: Month Subtotal District year quarter Days Sum(Days) Crewsize First(Cresize) Example: 1 2 3 Subtotal GP 2007 FirstQuarter Days 101...

Thank you so much. I have already built exactly the same way you mentioned. But I just wanted to confirm that there is a built-in function in Crystal to do this. May be it is worthy to have one in the later versions of Crystal. Thank you for all your help,

I do not have a date. I need to know based on the monthnumber. Like Days(1) = 31 days in January. Is there anyway? Thank you so much,

How can we get days in a month, if the month number is given. I need a function as below: DaysInAMonth(MonthNumber) = NumberofDaysInMonthNumber Thank you,

Can you give me a little more explanation please. I did not catch what you were saying in that. Thank you for your time.

I have the following crosstab: --------------Month------ District Year Quarter 1 2 3 Total XX 2007 FirstQuarter 6.2 6.1 5.6 Avg(6.2,6.1,5.6) YY 2007 FirstQuarter 1.1 1.3 0.4 Avg(1.1,1.3,0.4)...

I tried manually adjusting the field width. But unfortunately, the value is pushed to the farmost left but not wrapping around.

I tried ampersand and also CHR(10) (Line feed). I am using Version 9.0

The formula in the format field - Display string in a crosstab is: stringVar Result; Numbervar AfterDistribution; whileprintingrecords; AfterDistribution:= currentfieldvalue - val({@DistributionAmount}); Result:= TRIM(totext(currentfieldvalue,1))+ CHR(13) +TRIM(totext(AfterDistribution,1))...

Yes. But I tried resetting the formula in a group header etc.. But because it is not really flexible, I gave up my trials using crosstab in Crystal. I wrote a stored procedure in t-sql and called the procedure through report. This way I found it much easier than fiddling with the Crystal...

I have a crosstab as follows: SUMMARY FIELD = Operatingdays year Quarter Month district1 district2 total unit1 1 2 3 unit2 14 1 15 Total 15 3 18 I created two groups in the report. 1. By...

Now... another problem. When I am trying to show the column total for each district, it is resetting the adddispl value to 0 for each page and also it is showing the total for the entire month because it is a running total. How do I display column totals and row totals for the displayed values?

I created another group by unit and created the summary formula field by the Unit and "monthly". This solved my problem. I still want to keep this chain open as I need to do variations of this report. I will be bugging for some more time I think......:-) Thank you very much once again for...

Unfortunately, this solution I already implemented before. Further explanation: Year Quarter Month MonthTotal District1 District 2 DistrictTotal Unit1 1 18 19 Unit2 3...