Search results for query: *

Hello All, It just took me more working time but I was able to figure out finally. I was using company parameter to link sub report but I got this working when I link 2 report with company field instead.

hello All, I have a new requirement from Business office. This new requirement requires to pull sub report values and match to each value with main report. EG. if sub report has 3 values for 3 different companies, is it possible to match each of those company values with main report 3 different...

That's exactly what I did. But the issue with that was the performance. This main report was already taking 6 minutes to run and if I add subreport then it would be double the time to run report. And adding subreport works however due to performance issue mgmt team decided not to add total at...

Hello All, Please help me to figure out this issue on my new report requirements. In below report, I have GH 1 Company Name and Group Header 2 Aging Date. I want to include total at bottom of report. current% is calculation of (1074318.08-1114098.75)/1114098.75*100, and all other % calculation...

Thanks to IanWaterman. I finally figured it all out. I was using wrong field for my @Current Aging Amount Due. With correction, your suggestion and formula worked fine. Thanks again.

Thanks Madawc for your input on my issue. Also, thanks to IanWaterman for your input as well. I kinda have similar formulas set up in my report. @Current is a formula to calculate amount due. @Current%% shared numbervar firstbiweek; shared numbervar secondbiweek :=...

Hello All, I am struggling to figure out a way to calculate couple of the requirement that my business office requested on their new report. A report that has 3 groups Company, Aging Date (for each two weeks), and Customer name. Report looks like below and I need to calculate as below. Customer...

Thanks Madawc for your reply. I tried and worked around with variable but can't seems to get it right. Could you provide a sample example to direct me to right path?

I have a new report requirement. Where I need to display monthly ranking of colors and also display the color variance compared to previous month. I have tried sub-report but doesnt' seems to work for me. Can any one suggestion what are my other option to be able to display like in follwoing...

Updating repository objects doesn't seems to work on global bases in crystal report 2008. I created a template report with colored text object and used that template to create new report every time but now my company wants me to change the color or that repository object used in all reports. I...

I read previous thread dated back on Jan 2010. by LisaRR (Geometric Mean) link to thread: http://www.tek-tips.com/viewthread.cfm?qid=1586227 or thread767-1586227 Thanks everyone for their input on LisaRR thread. It works great for me too for each month calculation. however, I am in a...

Thank you Ibass for your quick respond, I also realized after posting that I wasn't clear enough explaining my issue. When i meant recent date, I meant the latest date in date row. I have customer, Sales order number and sheduled to ship date 3 rows and available to ship date on column and...

Hi all, My PM wants a cross - tab report that has muitiple dates in a date column to print only recent date instead of multiple dates. I know the cross tab is very picky and I am wondering if someone knows how to get this to work or even it is doable. Thanks in advance,

Nevermind Ibass, I got it right. I modified your formula on with currbk := sum({table.emp},GF1a); and it worked great. Thank you so much, whileprintingrecords; numbervar currbk;numbervar prevbk := currbk; currbk := sum(GF1a,{table.emp}); prevbk

Thanks for solution. I works great except for one which i failed to mention in my previous note that the count of book and emp are my running total instead and now I get "This field can't be summarized" error message. I have to have running total on my GF2 and only way out for me to correct...

Ibass, thanks for quick reply. I guess, i meant to say Total only instead of Avg. total. Do you follow my question now? How would you tackle this problem? Thanks.

Hi all, I need help understanding how can I accompolish my goal here to display previous month total on group footer. EG. I have 2 groups Month and Date by weeks Gp1: Month, Gp2: Date by week. GH1: June Count of BOOk count of emp Gf2 06/01/11 50 100 Gf2 06/07/11...