Fantastic! Do you btw. also know how to change the starting date to be always ex. 30 days ago? ... View more

Manish, here the code. I used the Between code because in this data source there is also predicted info in the future. IF ( DayOfYear(DatePart(Now())) - DayOfYear(Date) ) Between [inclusive] (0, 7) RETURN 1 ELSE 0 ... View more

Hi Manish, Is there a reason why you have chosen the CrossTab report object rather than a Table object? As the data items In_time, Out_time and login hours are column headers in the CrossTab they are not available for display rules (conditional formatting), however if you use a Table object you can set up a display rule for the 3 data items. If you require these specific data items to be category you could duplicate them and change the duplicated data item to a numeric too. Kind Regards, Michelle ... View more

If you want to include a quote inside of a quoted string you need to double up the quote character.  Note that you can also convert from using using double quotes to single quotes. Examples: " ""Mumbai"" " ' "Mumbai" ' "Don't" 'Don''t' ... View more

The best entries with you will find using "tilanus" eg: http://support.sas.com/resources/papers/proceedings13/023-2013.pdf Mailing using Outlook with Eguide is a nogo. SAS and Outlook are not connected that way.  Microsoft did a lot of work to stop Spammers. You can use mail with SAS but you are needing to bypass the spammer protection. What you are needing is a mail configuration within SAS that is open enough. As a pitty SAS is far behind market evolvments. You are needing possibly to run the latest SAS-version (ssl password). SAS(R) 9.4 System Options: Reference, Second Edition ( EMAILHOST= System Option). The server / mail traffic must not be blocked to reach those mailservers by a firewall. The older mail configurations are relying on "bulk-mail" that is an open relay defined to a mail-server. You have to negotiate for that to get those kind of things open. Within bigger organizations sometimes this is done as part of a service.   ... View more

I suspect no, and screen resolution wouldn't necessarily be the answer but window space. I hate all of the designers out there that automatically assume their display is so important it must occupy the full screen and won't display properly or very well in a less than full screen window. ... View more

Thanks a ton Peter! ... View more

There is a similar posting to your question at ... View more

Thanks Renato for your reply. I will try out your suggested solution and will let you know! ... View more

This is the version with a background image. I hope this is what you were looking for: ... View more

Thanks to both David and Michelle for the answers. I will have more questions on this topic though! ... View more