Search results for query: *

It works! Thank you very much and Happy new year. :)

Hi, I have two running total fields. They work fine. The formula that I use in these two running total fields as below: 1) LT_50_SLA_MET {SP_CKLB_SBB_Productivity_and_SLA;1.With_in} ='X' and {SP_CKLB_SBB_Productivity_and_SLA;1.SLA_MET} = 1 2) LT_50_ALL...

Thank for all you guys but it did not work :-(

IS there any example that I can look at it? Thanks

Hello, Is there a way to create a CrossTab drill down report? I mean when I click the one of the row items I'd like to show detail of that item in sub report. Please advise... Thanks

Hi, The field that holds 1,2,3.. value is not a date value. Just shows days of month. Also it is hard to put all the holidays and weekends in array for the coming years. Thanks

Hi , So, do you mean there is no why to do that? Thanks

Hi, That column values shows months days but it is not date field. :( Column shows 1,2,3...for each month and I just want to highlight background color of holiday days. Any help ? Thanks

Hi, Please see the attached screen shots after applying above process. It did not work. :-( Here is the link for the attached file: http://www.mediafire.com/?8o4s2370i1zfy3i Thanks

Hi, highlighting expert shows only field that holds values 1,2,3,4.. (days). Sorry I am new for the Crystal report. What is CT? In Cross tab expert do you want me to add the field holds values N or Y to the column then suppress? can you be more clear please as I am new ? Appreciate your...

Hi, The problem is Y or NO value is not in that field. :(

Hi, Please look at the attached sample crosstab report. The report shows each job's status in a month(1,2,3,4.. is days of the month.) I am trying to change days'(1,2,3,4...) background color based on my one of my field value(field is bd). This field keeps value that shows that day business day...

Hi Ian, Please look at the attached sample report. The report shows each job's status in a month(1,2,3,4.. is days of the month.) I am trying to change days'(1,2,3,4...) background color based on my bdfield value. This field keeps value that shows that day business day or not. If it is weekend...

Hi, I have crosstab report and I’d like to change column header based on one of my field’s value. My field has two values N and Y. I put “if {S_CCO_JOB_STATUS;1.bd} = "Y" then crGreen else crNoColor “ It take only first row value and fills all the columns background with that color. (like if...

Thanks Ken, Really appreciate it! Huseyin

Hi Ken, I have Credit_Centre , Team, Credit_Analyst, and Queuename fields in ROW section , Dec_day field in Column section and dec_cnt and distinctCount of @days_worked in Summarized fields section in cross-tab. I have grouped by Team (I need to get page break for each team) and I have put...

Hi Ken, I have tried but it shows records double :( . Please advise...

Hi Ken, I need a page break for each team. If I put it in footer I lose that option. Please advise... Thanks

Hi Madawc, I know there is an option get sub total and grand total. My problem is I have grouped by Team if then I am getting only Team sub total and Credit Centre -> Team Grand total (for each team) . But I need to get overall grand total. Do you know how can i get it? Thanks

Hi, Can anyone tell me that how can I get the grand total of Center column? Currently I could get sub total of team but I couldn't get the Center total overall all teams. Please see the attached file.