Search results for query: *

Thanks Renasant it worked..

CR XI Release 2. Tek tips has been great help now i am almost treating it like a buddy whom i can ask anything... well the issue is ..while designing the report when i want to supress the whole section then i right clik on that particular section and then click supress(no drilldown0 then the...

Thanks Lb. You have solved this problem.. I am so glad that i am a member of tek-tips.

yes that is true... I am really sorry if i am making this complicated.. The data should be like this Awards A (heading) Rows for it... (details) Total for Awards Av(footer) Awards B Rows for it... Total for Awards B Awards c Rows for it... Total for Awards c Total Awards to Date $Amount...

I thank you all for replying my post..however i think i have not made my point clear... The issue is i want the totals to appear at the end of 3rd group not at the end of all groups...Calcualtion of the totals is not the isssue.. I hope i have made myself clear If i am still not making any...

if a running total is kept in the report fotter then it will appear after all the groups right.. however i wnat like this Awards A rows of these group Awards S rows of these group Awards G rows of these group TOTAL OF THE ABOVE GROUPS x-Awards A rows of these group x_Awards S rows of these...

I was thinking if there is anyway to avoid subreport..looks like I have to go for it afterall

CR XI release 2. The report has to group by sales performance. And it has the following values. Awards A Awards S Awards G x-Awards A x_Awards S x-Awards G y-Awards A y-Awards S Y-Awards G z-Awards A z-Awards S z-Awards G preawards upcoming awards Future awards other awards User want the...

no problem

and the main thing is the cross tab has to show all the Trialers from the master trailer table

I would like to THANK YOU (by caps i meant emotion not shouting)...for replying back..as i said this is my last and final hope... I want the cross tab to 1)supress the job rows despite of the job parameter i.e. display only trailer and location in the rows of the 2)calculate the values based...

Sum ({Command.TX_AMT}, {Command.BILL_NUMBER}) This gives the sum of tx_amt for that particular Bill_number with out any restriction. create a running total #Rtotal0. In the evaluate -->use a formula --> give the formula if that fall under age 30 or age 31-60... and then replace Sum...

I don't see why you don't just use trailer as your row field, i.e., if you remove the other two rows (jobno and job location), you will have the correct results." if i remove JObno and JOblocation then i can not have correct results the reason for this is..since user have selection criteria on...

Please show the formula you are using for the running total of the vendor. Please explain how are you evaluate runing total.. if you use a formula please show the formula

HI I am working in crystal reports for quite some period. However I would like to ask you all what possible steps i can take to make sure that the performance of the report will be good. Like I want to know what are the first steps I have to take if My pL says please improve the performance of...

please let me know if you need any more information LB.

This is not the perfect solution for what you are asking hwoever did you try to indent row labels.. Rightclick on cross tab -->Crosstab expet-->Customize style --> Check the Indent Row labels..

YOu have "AddCommand" option in the database expert. you can do a search on "Add Command" in crystal help to have more idea. Crystal allows you to get data either By "Add COmmand" or by "By pulling tables" or "By stroed Procedures"... The point is if you use addcommand then you have to get...

load the contacts in to the array only if they are already been shown in the report.i.e. load the values into the array after the subreport and check the values before the subreport.

p.s i can give those conditons in the record selection however then the Trailer T3 will not be visible as it will not have null location adn null job