Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: formula in specific cross-tab Columns Post Reply Post New Topic
Author Message
emad
Newbie
Newbie


Joined: 07 Jan 2013
Location: Yemen
Online Status: Offline
Posts: 3
Quote emad Replybullet Topic: formula in specific cross-tab Columns
     Posted: 07 Jan 2013 at 9:40pm
hello,

i'v an attendance application with a report tat shows the monthly attending action like the example in the link,

http://www.arc-ye.com/ForumStufe/MonthlyReport.pdf

i'm using a cross tab that shows the regno,name as rows,
and the date in tow columns one shows the day name of the week and the other Date column shows the date as (date of day).
the Attending time in is shows as max summary Filed.
as described in bellow:



the problem is:
i want to apply a specific formatting for each weekend column (Thursday and Friday) such like column border size or column background.
can any body help me with a formatting formula for the mentioned columns that can solve my issue<<

Thanks in advance
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 08 Jan 2013 at 5:43am
IP IP Logged
emad
Newbie
Newbie


Joined: 07 Jan 2013
Location: Yemen
Online Status: Offline
Posts: 3
Quote emad Replybullet Posted: 08 Jan 2013 at 6:31pm
thank you DBlank for your quick response , but i couldn't recognize my issue in the links you provided above.

i want the formula for a columns of the weekends (Thursday - Friday)in the whole month to be formatted in different way from the mentioned column header vertically to bottom of report.

please i really needing a way to do that,,

thanks your forbearance
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 09 Jan 2013 at 4:32am
not sure why you have the VattendDaily.daet added twice as a column but if you set it to daily you can use conditional formatting in your cell like so (this changed the font color):
 
if weekday(gridrowcolumnvalue("VattendDaily.date")) in [5,6] then crred else crblack
 
IP IP Logged
emad
Newbie
Newbie


Joined: 07 Jan 2013
Location: Yemen
Online Status: Offline
Posts: 3
Quote emad Replybullet Posted: 11 Jan 2013 at 6:50pm
Thanks MR.DBlank for your good communication,

Things starts to be clear now, i used your formula and it works fine,

thank you very much for your support,,
IP IP Logged
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum