tag:blogger.com,1999:blog-5600643399322885262024-02-23T18:16:43.784+08:00Our ChiWai/ 我們的智慧Share Knowledge/Experience which I learn. Share the stuff that I find it interesting.
Computing tips and tricks which I found that would be useful for the other as well. One of the main reason of write this blog is to keep a record of the problem Hopefully I can solve it when I meet the same issue again.
Tips and Tricks for .Net, Crystal Report, PHP, MSSQL,MySQL智/Chihttp://www.blogger.com/profile/15160726870243326116noreply@blogger.comBlogger15125tag:blogger.com,1999:blog-560064339932288526.post-13832097532099957662010-05-08T16:48:00.006+08:002015-08-05T03:52:06.178+08:00Blog Move to http://blog.sharechiwai.com<span style="font-size: small;">Hi,</span><br />
<br />
<span style="font-size: small;">I have create another Blog "</span><a href="http://blog.sharechiwai.com/"><span style="font-size: small;">Share ChiWai/Share 智慧/智慧分享</span></a><span style="font-size: small;">" and moved most of the post to my new blog. To make it looks better [ I hope]<br />
</span><br />
<span style="font-size: small;">Please feel free to visit:</span><br />
<span style="font-size: small;"></span><br />
<a href="http://sharechiwai.wordpress.com/"><span style="font-size: small;"></span></a><br />
<span style="font-size: small;"><a href="http://blog.sharechiwai.com/">http://blog.sharechiwai.com/</a> </span><br />
<span style="font-size: small;">Here it is the stuff I will blog about on my new blog.</span><br />
<span style="font-size: small;">"日常生活/電腦技術經驗分享,...Tips and Tricks for Android, Java, .Net, Silverlight, Javascript, Crystal Report, PHP, MSSQL,MySQL, "</span><br />
<br />
和以下網址和大家分享我的 <b>Life Style Funny </b>這個網誌是用來和大家分享我在香港/英國或其他地方的生活點滴<br />
http://lifestylefunny.sharechiwai.com/<br />
<br />
<span style="font-size: small;">=) </span><br />
<span class="Apple-style-span" style="font-size: x-large;"><br />
</span>智/Chihttp://www.blogger.com/profile/15160726870243326116noreply@blogger.com0tag:blogger.com,1999:blog-560064339932288526.post-406418260793943372009-05-29T07:31:00.004+08:002009-05-29T07:36:21.475+08:00Windows Server 2008 and Windows VIsta Service Pack 2 DownloadWindows Server 2008 and Windows Vista Service Pack 2 is now avaliable.<br />For more information please visit the URL below:<br /><a href="http://www.microsoft.com/downloads/details.aspx?FamilyID=a4dd31d5-f907-4406-9012-a5c3199ea2b3&DisplayLang=en">http://www.microsoft.com/downloads/details.aspx?FamilyID=a4dd31d5-f907-4406-9012-a5c3199ea2b3&DisplayLang=en</a>智/Chihttp://www.blogger.com/profile/15160726870243326116noreply@blogger.com0tag:blogger.com,1999:blog-560064339932288526.post-77534091262106230462009-04-04T04:04:00.007+08:002009-04-04T13:38:36.528+08:00InLink Checker in SilverLightI have updated the <span style="font-weight: bold;">Back-Link checker </span>Beta 1 to have another feature which allow us to check which links your site/page is linking to and is searchable by crawler.<br /><br />It is an useful tool to check if you have linked to any pages which you do not intend to link to/ or recommend to the other which could affect your site's reputation. E.g. some <span style="font-weight: bold;">spam sites</span>, may leave comment/message on your site, which has pasted a link to their <span style="font-weight: bold;">spam URL</span>...etc.<br /><br />To check the Page InLinks:<br /><ol><li>Simply select "<span style="font-weight: bold;">PageLink</span>" on the drop down list which just next to the "<span style="font-weight: bold;">Search</span>" button.</li><li>Whole site check box: Specifies whether to provide results for the entire site, or just the page referenced by the query.</li></ol><span style="color: rgb(255, 102, 0);font-size:85%;" >You can ignore the Omit Link option for this feature.</span><br /><br />Hope you find it useful!<br /><br />Related post:<br /><a href="http://ourchiwai.blogspot.com/2009/03/backlink-checker-in-silverlight.html" title="BackLink Checker in Silverlight">BackLink Checker in Silverlight</a><br /><br /><iframe src="http://silverlight.services.live.com/invoke/78430/BackLink%20Checker/iframe.html" scrolling="no" frameborder="0" style="width:800px; height:600px"></iframe>智/Chihttp://www.blogger.com/profile/15160726870243326116noreply@blogger.com0tag:blogger.com,1999:blog-560064339932288526.post-21324070673019366442009-04-01T04:01:00.000+08:002009-04-01T04:01:04.299+08:00Gourmet Houses' Chocolate 飛機上的朱古力小食之前我試了在搭飛機去英國時派的朱古力<br /><br />他應該是 香港一家朱古力公司 Gourmet House LTD 出品的<br /><br />這個朱古力給我一個高貴的感覺(可能時金色的盒子吧)<br /><img src="http://api.photoshop.com/home_453edadf42c44e2bba351fb5d2dfaeb1/adobe-px-assets/e67546705fad4863a00b839e38a0eadd" alt="Gourmet House LTD's Chocolate" width="320" height="240" /><br />在盒上寫了 朱古力是瑞士出產的 當然是香港生產/製造<br />如果對這間香港朱古力公司有興趣, 可以按這條URL瀏覽 網頁<br /><br /><a href="http://www.gourmethouse.com.hk/">http://www.gourmethouse.com.hk</a><br /><br />打開盒子只有2粒朱古力<br />一黑一白<br /><img src="http://api.photoshop.com/home_453edadf42c44e2bba351fb5d2dfaeb1/adobe-px-assets/965028a749bb4a00827c2e04aacae278" alt="White and Milk Chocolate" width="320" height="240" /><br />我試了黑色這一粒 (我不太喜歡吃白朱古力 = P)<br /><img src="http://api.photoshop.com/home_453edadf42c44e2bba351fb5d2dfaeb1/adobe-px-assets/fe2bd8af42444a3f805a1bf3d9819d34" alt="Gourmet House's Milk Chocolate" width="320" height="240" /><br />吃下去的感覺是<br />他有三層<br /><img src="http://api.photoshop.com/home_453edadf42c44e2bba351fb5d2dfaeb1/adobe-px-assets/60b7bab93b664eccafd875d5d7b6d32b" alt="3 Layers Chocolate" width="320" height="240" /><br />最外一層比較薄和趣<br />之後就有一層牛奶朱古力<br />最入的一層應該是榛子味的CREAM<br />和kinder 繽紛樂 入面的醬差不多<br />算是幾甜了 (對我來說)<br />我個人覺得這朱古力總算是OK<br />可能他的其他產品會比較好食<br />可能這是飛機上的小食<br />所以試過便可以了智/Chihttp://www.blogger.com/profile/15160726870243326116noreply@blogger.com0tag:blogger.com,1999:blog-560064339932288526.post-64688305970964912502009-03-30T03:30:00.002+08:002009-04-04T13:39:03.989+08:00BackLink Checker in SilverlightMy second Silverlight application:<span style="font-weight: bold;"> BackLink Checker Beta 1</span>.<br /><br />You can use this application to check if other people has link o your website. It would be quite interesting to know if people are interest on you website, they properly will place a link on their site and recommend it to others. Of course, on the other hand if people think your website is crap, they could also place a link no their site and say..[Not to visit your website …etc.].<br /><br />Here it is some criteria on this BackLink checker.<br /><ol><li>You should enter full URL of your website (with <span style="font-weight: bold;">HTTP/HTTPS</span>)</li><li>If you put a URL which contain specific page. Then the BackLink checker will only search for the back link for that particular page.</li><li>It has 2 setting for you to specific the result. </li></ol><ul><li><span style="font-weight: bold;">Whole site</span> check box: Specifies whether to provide results for the entire site, or just the page referenced by the query</li><li><span style="font-weight: bold;">Omit link</span> drop down: If specified, link will not be returned if they are from pages in the same <span style="font-weight: bold;">Domain/Sub-domain</span> as the requested page.</li></ul>This<span style="font-weight: bold;"> BackLink Checker</span> only return the links which is indexed by Yahoo, therefore it may not reflect the actually popularity of your website. Hope this can be improve on <span style="font-weight: bold;">Beta 2</span>. = )<br /><br />Hope you find it useful.<br /><br /><iframe src="http://silverlight.services.live.com/invoke/78430/BackLink%20Checker/iframe.html" scrolling="no" frameborder="0" style="width:800px; height:600px"></iframe>智/Chihttp://www.blogger.com/profile/15160726870243326116noreply@blogger.com1tag:blogger.com,1999:blog-560064339932288526.post-62738850686957043512009-03-29T03:30:00.001+08:002009-03-29T16:51:52.061+08:007 Steps to create your own hand-writting FontHave you ever heard some people said, <span style="font-weight: bold;">your hand-written font reflect your personality</span>? I knew some people who study <span style="font-weight: bold;">psychology</span>; they could read your feeling by read the text you have written. They are quite accurate.<br /><br />Today I want to introduce you a site which can help you to generate your own hand writing Fonts.<br />It is fair simple. There are few things you need to prepare.<br />1) <span style="font-weight: bold;">Printer</span><br />2) <span style="font-weight: bold;">Scanner</span><br />3) <span style="font-weight: bold;">Black permanent marker of fine or medium thickness Pen</span><br /><br />Here it is the <span style="font-weight: bold;">7 Steps</span> that you can go through in order to create your own hand-writing font.<br />1) <span style="font-weight: bold;">Print Template</span><br />2) <span style="font-weight: bold;">Complete Template</span><br />3) <span style="font-weight: bold;">Scan & Save Template</span><br />4) <span style="font-weight: bold;">Upload Template</span><br />5) <span style="font-weight: bold;">Preview Your Font</span><br />6) <span style="font-weight: bold;">Download</span><br />7) <span style="font-weight: bold;">Install & Use</span><br /><br />You can simply follow the instruction on the website. Then you should be able to create your own font within 15mins.<br />I would upload my own Hand-writing font unfortunately I do not have a scanner.<br /><br />Here it is the website:<br /><a href="http://www.yourfonts.com/">http://www.yourfonts.com/</a><br /><br />Feel free to let me know how do you feel about having your own hand-writing font on computer.<br /><br />Have fun.智/Chihttp://www.blogger.com/profile/15160726870243326116noreply@blogger.com0tag:blogger.com,1999:blog-560064339932288526.post-84224054503004545502009-03-29T03:29:00.004+08:002009-03-29T16:49:25.748+08:007個步驟便可以在電腦上擁有屬於自己手寫字形今日想同大家介紹一個網頁<br /><br />想信大家都有聽過[<span style="font-weight: bold;">物似主人形</span>]<br />亦都有人講過 見到你寫的字都估到你是過怎樣既人<br /><br />只需要簡單的<span style="font-weight: bold;">7 個步驟</span> 便在電腦上擁有屬於自己手寫字形<br />這個網頁可以將你手寫的字轉做可幾由電腦打出來的字<br />只需要大概15分鐘便可以完成<br />看到這裡是否好想去這個網頁去做自己的字形呢.<br /><br /><span style="font-weight: bold;">需要的工具有</span><br />PRINTER(打印機)和SCANNER(掃描器)<br />還有一支筆 (最好是黑色的幼或中厚MARKER [標記筆?])<br /><br /><span style="font-weight: bold;">有屬於自己的字形這裡就是所需的步驟了</span><br />1) 首先到這個網頁 <span style="font-weight: bold;">打印模板 (Print Template)</span>, 這裡有2 個格式給你們Print出來, 一個字PDF 另一個是個IMAGE 檔<br />(我會建議print PDF 檔)<br />2)<span style="font-weight: bold;"> 填寫</span>剛剛print 出來的<span style="font-weight: bold;">template</span>. (<span style="color: rgb(255, 0, 0);">請記住跟著他的格式</span>) 網頁上的example 可以參考<br />只需要填寫第一頁, 如果你想用其他的特別字你可以填寫埋第二頁岩<br />3) 需要scan 同保存剛寫好的文字template, <span style="color: rgb(255, 0, 0);">請注意他們只支援幾下的檔案格式的 (.gif, .jpg, .jpeg, .png, .tif, or .tiff file)</span><br />4) 上傳檔案和幫自己的字形命名<br />5) 預覽字形<br />6) 下載字形<br />7) 安裝字形<br /><ul><li>使用<span style="font-weight: bold;">windows 的電腦</span>可以按"<span style="font-weight: bold;">開始</span>"-->"<span style="font-weight: bold;">控制台</span>"</li><li>double click "<span style="font-weight: bold;">字形</span>"</li><li>選擇"<span style="font-weight: bold;">安裝新字形...</span>" --> 瀏覽到該檔案位置</li><li>選擇 "<span style="font-weight: bold;">Your font (TrueType)</span>"</li><li>最後<span style="font-weight: bold;">按"確定"</span> 便可</li></ul>之後可以開啓文字程式選擇自己的字形看看 (E.G. Notepad)<br />會不會有一些親切感<br />哈哈<br /><br />以上就是所有的步驟了, 如果還是不太明白的話可以到官方網頁看<br /><br />由於我沒有scanner 所幾沒有得嘗試造自己的字形...<br />(當我找到scanner時我一定會upload 我的字形上網的)<br />哈哈<br /><br />這個網頁的網扯是<br /><a href="http://www.yourfonts.com/">http://www.yourfonts.com/</a><br /><br />希望你喜歡<br />如果你想和其他人分享你的字形<br />歡迎你留言時留下你字形檔案的URL<br /><br />Have fun.智/Chihttp://www.blogger.com/profile/15160726870243326116noreply@blogger.com2tag:blogger.com,1999:blog-560064339932288526.post-31827928332622405972009-03-23T03:23:00.001+08:002009-03-23T03:23:06.672+08:00Trend Micro HouseCall on Vista/ Free online scan for antivirusI have installed <span style="font-weight: bold;">AVG Free</span> as anti-virus software on my laptop. I think they are quite good. Although it is quite safe, sometime I will use other online virus checker to scan my computer to ensure my computer is secure.<br /><br />I used to use <span style="font-weight: bold;">Trend Micro HouseCall </span>to do a online scan on my computer, sometime it did find some Trojan and worms, but AVG did not notice it. But as soon as I upgrade my laptop to Windows Vista, HouseCall did not work again. On the previous version of HouseCall it did say it does not support Windows Vista. When I check it again today, it said it did now.<br /><br />My computer has not done any full virus scan for quite awhile, I think I should have a try now. I am not sure if it is something not quite right on my computer. I cannot get it work on my IE, it said "<span style="font-size:85%;"><span style="font-weight: bold; color: rgb(255, 0, 0);">HouseCall is not available for your platform</span></span>"..."<span style="color: rgb(255, 0, 0);font-size:85%;" >You can not use Trend Micro HouseCall on your machine because your processor type or your operating system are not supported.</span>" etc. (but on the front page, they did say they support vista and IE6 or above). I hope it is not something to do with my CPU which is “Centrino Duo<br />”.<br /><img src="http://api.photoshop.com/home_453edadf42c44e2bba351fb5d2dfaeb1/adobe-px-assets/e2633341ab734509855062b305447f67" width="800" height="387" /><br /><br /><br />When i try again on Firefox, it seems to work. The different is I need to download an exe file instead of running it directly on browser(<span style="font-weight: bold;">Firefox</span>).<br /><br />After I downloaded the "housecall66.exe" I just double click on it to execute it.<br /><br />When you started it, it will ask you to accept the <span style="font-weight: bold;">terms and condition</span> agreement.<br /><img src="http://api.photoshop.com/home_453edadf42c44e2bba351fb5d2dfaeb1/adobe-px-assets/637007f11deb4701bc5320817e5c9e7e" width="809" height="593" /><br /><br />Once you done that you need to choose a <span style="font-weight: bold;">HouseCall Kernel</span> which his either a <span style="font-weight: bold;">Brower base</span> or <span style="font-weight: bold;">Java base</span>. Then you would need to download the plug-in, it may take awhile.<br />(I chose Browser Base)<br /><img src="http://api.photoshop.com/home_453edadf42c44e2bba351fb5d2dfaeb1/adobe-px-assets/b37d09378c6445e6bf285521004c104a" width="809" height="443" /><br /><br />Then you will see a "<span style="font-weight: bold;">Select Scan Options</span>" screen.<br /><img src="http://api.photoshop.com/home_453edadf42c44e2bba351fb5d2dfaeb1/adobe-px-assets/5b0d07c756564b5d885f0eebf8bb77c3" width="916" height="736" /><br /><br /><span style="font-weight: bold;">Recommended scan</span> - only scan for malware, grayware, vulnerability and selected location. It will perform quicker<br /><br /><span style="font-weight: bold;">Complete scan</span> - probably will scan for everything on you PC<br /><br /><span style="font-weight: bold;">Customized Scan</span> - you can select what to scan.<br />It has one more option than Recommended Scan which is scan open network port<br />I think it would be quite useful to see if your computer has open a network port which could be attack by hacker.<br />If you have selected "<span style="font-weight: bold;">Open Network ports</span>" it will pop up a message to inform you that the program will perform a port scan. (It is not a hacker attack (not this time))<br /><img src="http://api.photoshop.com/home_453edadf42c44e2bba351fb5d2dfaeb1/adobe-px-assets/6336549e7d764786b2b5e280b24a049f" width="497" height="197" /><br /><br />It takes about 4 hours to scan my computer, which has 160GB HDD, filled in around 110GB data<br /><img src="http://api.photoshop.com/home_453edadf42c44e2bba351fb5d2dfaeb1/adobe-px-assets/7eca8eaff9324985a6fe84d8fe2ca74b" width="916" height="736" /><br /><br /><br />My scan result<br /><img src="http://api.photoshop.com/home_453edadf42c44e2bba351fb5d2dfaeb1/adobe-px-assets/5857959a5c734dbb90335639e92c79a8" width="821" height="460" /><br /><br />Here it is the URL for Trend Micro HouseCall online scan.<br /><a href="http://housecall.trendmicro.com/">http://housecall.trendmicro.com/</a><br /><br />Hope your find it useful.智/Chihttp://www.blogger.com/profile/15160726870243326116noreply@blogger.com0tag:blogger.com,1999:blog-560064339932288526.post-69067552667418201972009-03-19T03:19:00.002+08:002009-04-04T00:03:02.660+08:00Jquery's NotesI am learning JQuery at the moment, and going to note down the error/mistake which I made while I am experimenting it.<br />Hope you would find it useful if you encounter the same issue, while you are using JQuery. Please correct me if my concept is<br /><br />wrong or you have a better solution.<br /><br />Why learn JQuery?<br />It is a JavaScript library/API/Frameworks allow you to develop website rapidly with nice feature that can work Cross-<br /><br />browser, CSS3 Compliant and Lightweight Footprint, you can found lots of plugin on-line which can save you a lot of time to<br /><br />develop you own method for some common feature.<br /><br />Here it is the official site for JQuery, where you can find JQuery to download download/tutorials/documentation and get the latest<br /><br />information about it.<br /><a href="http://jquery.com/">jquery.com</a><br /><br />One thing that I would like to remind myself from this notes is. All the even/action E.g. Blur, Onchange...etc should register on ready event. Of course, the most important thing is to reference the jquery.js between the HTML header tag.<br />E.g.<br /><pre><br /><span style="color: rgb(0, 153, 0);"><html></span><br /><span style="color: rgb(0, 153, 0);"> <head></span><br /><span style="color: rgb(0, 153, 0);"> <script type="text/javascript" src="jquery.js"></script></span><br /><span style="color: rgb(0, 153, 0);"> <script type="text/javascript"> </span><br /><span style="color: rgb(0, 153, 0);"> //Register on ready event </span><br /><span style="color: rgb(0, 153, 0);"> $(document).ready(function() {</span><br /><span style="color: rgb(0, 153, 0);"> $("#txt_Text").change(function(){</span><br /><span style="color: rgb(0, 153, 0);"> alert($("#txt_Text").val());</span><br /><span style="color: rgb(0, 153, 0);"> });</span><br /><span style="color: rgb(0, 153, 0);"> });</span><br /><br /><span style="color: rgb(0, 153, 0);"> </script> </span><br /><span style="color: rgb(0, 153, 0);"> <title>Jquery Notes</title></span><br /><span style="color: rgb(0, 153, 0);"> </head></span><br /><span style="color: rgb(0, 153, 0);"> <body></span><br /><span style="color: rgb(0, 153, 0);"> <input type="text" id="txt_Text"/></span><br /><span style="color: rgb(0, 153, 0);"> </body></span><br /><span style="color: rgb(0, 153, 0);"></html></span><br /><br /></pre><br />The example above will display an alert box when we change the focus on txt_Text input control.<br /><br />Happy coding.智/Chihttp://www.blogger.com/profile/15160726870243326116noreply@blogger.com0tag:blogger.com,1999:blog-560064339932288526.post-9612613978109015752009-03-17T17:03:00.001+08:002009-03-18T01:29:45.603+08:00Oyster Mushroom Crisps suitable for vegetarians (Health Choice)Today I would like to recommend crisps for you (Oyster Mushroom Crisps Wasabi Flavour). I felt that crisps are a bit healthier than normal crisps as it is not that oily. On the package it said it has No Trans Fat, No Cholesterol, No Artificial Colouring and No Preservative Added.<br />Normal crisps are made from potato, but this one is made from Oyster Mushroom.<br />The taste of wasabi is not that strong, so you probably won’t feel the spice of it. Not like the wasabi on Sushi or wasabi seaweeds…etc. I think it is not only suitable for Vegetarians, it also suitable for children as well.<br /><br />It is quite special, you must try it out : ). But if you do not like the smell of mushroom, you may not like it then.<br /><br />Package<br /><img src="http://api.photoshop.com/home_453edadf42c44e2bba351fb5d2dfaeb1/adobe-px-assets/dca57a5ff44245018b1db0c2193f10c7" width="320" height="240" /><br /><br />Inside the package. It does not look like normal crisps<br /><img src="http://api.photoshop.com/home_453edadf42c44e2bba351fb5d2dfaeb1/adobe-px-assets/65184bb647094d9ba64494bfc252ee0d" width="320" height="240" /><br /><br /><img src="http://api.photoshop.com/home_453edadf42c44e2bba351fb5d2dfaeb1/adobe-px-assets/0d7e00ddd177481f99860ab81dca7321" width="320" height="240" /><br /><br /><br />That is what Oyster Mushroom look like.<br /><img src="http://api.photoshop.com/home_453edadf42c44e2bba351fb5d2dfaeb1/adobe-px-assets/bea0cb6e0a6043779cb67eb563311a23" width="320" height="240" /><br /><br /><img src="http://api.photoshop.com/home_453edadf42c44e2bba351fb5d2dfaeb1/adobe-px-assets/c78a26161f8c4ae38c6583b106e6c9d3" width="320" height="240" /><br /><br />Let me know if you are interested on it.智/Chihttp://www.blogger.com/profile/15160726870243326116noreply@blogger.com2tag:blogger.com,1999:blog-560064339932288526.post-17905909295772945482009-03-11T18:15:00.000+08:002009-03-11T18:15:00.498+08:00Crystal report XI Service Packs 5 solve the PDF font size get reduced/smaller issueToday I just have a look at the documentation about Crystal report XI Service Packs 5, which has released at the end of Nov 2008.<br />They have mention the PDF generation issue which I posted few days ago about PDF font size get reduced after you export it from crystal report.<br /><br />If you have similar issue, the following description may be able to help you get around it.<br /><br />Hope you find it useful.<br /><br /><span style="font-family: verdana; color: rgb(51, 51, 255);font-size:85%;" ><span style="font-weight: bold;">ADAPT00940675</span><br />Description:<br />The registry key option ForceLargerFonts maintains the correct font size of reports that are exported to PDF format; however,<br />this option may cause data to be truncated along the right-side margin.<br />The problem is caused by a mismatch in the way that character widths are calculated between PDF and Microsoft Windows.<br />New Behavior:<br />This problem is resolved.<br />To solve the problem, the PDF export engine has been modified to use an algorithm that positions characters precisely to<br />prevent truncation, while still maintaining the correct font size. This algorithm is activated and controlled by two new registry<br />keys:<br />[HKEY_LOCAL_MACHINE\SOFTWARE\Business Objects\<suite>\Crystal Reports\Export\Pdf]<br />"UsePrecisePositioningForText"=dword:00000001<br />[HKEY_LOCAL_MACHINE\SOFTWARE\Business Objects\<suite>\Crystal Reports\Export\Pdf]<br />"TruncationAdjustment"=dword:00000002<br />The UsePrecisePositioningForText key enables the new functionality when it is set to 1. When this option is enabled, the<br />ForceLargerFonts option is automatically enabled (to maintain correct font sizes in PDF exports), and any manual settings<br />made to it are ignored. The TruncationAdjustment key controls a width calculation rounding function in the new algorithm and<br />accepts values between 0 and 10 inclusively. The default value of 2 has been tested to sufficiently eliminate most truncation<br />issues. If truncation still happens, users can increase the value.<br />Known Limitations:<br />When the UsePrecisePositioningForText key is enabled, exports to PDF format may take slightly longer, but by no more than<br />10%. Also, the exported PDF document will increase in file size over the standard output, and Crystal reports will consume<br />more GDI resources during the export.</span>智/Chihttp://www.blogger.com/profile/15160726870243326116noreply@blogger.com0tag:blogger.com,1999:blog-560064339932288526.post-10219550098151934982009-03-07T03:07:00.000+08:002009-03-07T03:07:00.692+08:00WordWrap on Crystal Report?I have received a task to convert the project handbook from Word Document into Crystal report. It does not sound difficult until I need to do some formatting and Layout.<br /><br />I had a problem on trying to make a field to display in Multi-line, instead of one line. And I am not able to file a word wrap function on Crystal Report. After spending some time on the web. Finally I find out how to do it.<br /><br /><strong>Solution:</strong><br /><br />1) <strong>Select </strong>the <strong>field(s)</strong> that you want to enable WordWrap.<br /><br />2) Right click and select "<strong>Format Field</strong>" OR <strong>"Format Objects"</strong> (if you select more than 1 fields)<br /><br />3) Then in the <strong>"Format Editor"</strong> Click on the <strong>"Common"</strong> tab.<br /><br />4) You will see the screen shot similar as below.<br /><br /><a href="http://api.photoshop.com/home_453edadf42c44e2bba351fb5d2dfaeb1/adobe-px-thumbnails/fe5dd095128d47e39605022d415e78d6/256.jpg"><img title="Crystal Reports fields Format Editor" src="http://api.photoshop.com/home_453edadf42c44e2bba351fb5d2dfaeb1/adobe-px-thumbnails/fe5dd095128d47e39605022d415e78d6/256.jpg" alt="Crystal Reports fields Format Editor" width="412" height="512" /></a><br /><br />5) Then <strong>"Tick"</strong> the <strong>"Can Grow"</strong> check box and click <strong>"OK"<br /><br /></strong>6)After you done that you can save the Report and press <strong>"F5"</strong> to preview the report.<br /><br />Hopefully you the field will be wrapped into next line.<br /><br />Good luck智/Chihttp://www.blogger.com/profile/15160726870243326116noreply@blogger.com2tag:blogger.com,1999:blog-560064339932288526.post-19496565031483931782009-03-04T08:08:00.000+08:002009-03-04T08:08:01.115+08:00TSQL Get Number of Decimal Place (on a field)Today I need to do a query to get all the record which has 3 decimal places on one of the field and process them by using different method.<br /><br />I am wondering if there any default TSQL function that I can use, so that it can save my time. Unfortunately, I could not find one, so that I decided to write my own function.<br /><br />Here it is the TSQL code that I used to retrieve the number of decimal place of a field.<br /><br /><span style="font-size:85%;"><span style="color: rgb(0, 153, 0);">--Example input value</span><br /><span style="color: rgb(0, 153, 0);">DECLARE @DecimalValue FLOAT</span><br /><span style="color: rgb(0, 153, 0);">SET @DecimalValue = 12.34567</span><br /><span style="color: rgb(0, 153, 0);">--Declare a variable to store the result</span><br /><span style="color: rgb(0, 153, 0);">DECLARE @NoOfDecimalPlace INT</span><br /><br /><span style="color: rgb(0, 153, 0);">SET @NoOfDecimalPlace = CHARINDEX('.', REVERSE(CAST(@DecimalValue AS VARCHAR(30)))) -1</span><br /><br /><span style="color: rgb(0, 153, 0);">--Return Number of decimal Place</span><br /><span style="color: rgb(0, 153, 0);">SELECT @NoOfDecimalPlace</span><br /></span><br />Here it is my User Define Function for get number of decimal place of a number field.<br /><br />You can execute it by using the following SQL code<br /><br /><span style="color: rgb(0, 153, 0);font-size:85%;" >SELECT dbo. Get_NoOfDecimalPlace(0.123)<br /><br />CREATE FUNCTION [dbo].[Get_NoOfDecimalPlace]<br />(<br /><br /> @ValueToProcess FLOAT=0<br />)<br />RETURNS INT<br />AS<br />BEGIN<br /> -- Declare the return variable here<br /> <br /> DECLARE @NoOfDecimalPlace INT<br /> SET @NoOfDecimalPlace = CHARINDEX('.', REVERSE(CAST(@ValueToProcess AS VARCHAR(30)))) -1<br /><br /> RETURN @NoOfDecimalPlace<br />END</span><br /><br />Hope you found it useful.智/Chihttp://www.blogger.com/profile/15160726870243326116noreply@blogger.com2tag:blogger.com,1999:blog-560064339932288526.post-47467879149783027602009-02-25T16:32:00.000+08:002009-02-25T16:34:31.988+08:00Deselect an Item on SilverLightSometime you may find it useful to de-select an Item on ComboBox,<br />when you try to force a user to pick one from the list.<br /><br />Here it is the code sample to deselect a selected item on ComboBox in Silverlight.<br />[Just need to set the selected Index to -1]<br />ComboBox1.SelectedIndex=-1<br /><br />Hope you find it useful.智/Chihttp://www.blogger.com/profile/15160726870243326116noreply@blogger.com2tag:blogger.com,1999:blog-560064339932288526.post-65943672139646716122009-02-24T21:48:00.000+08:002009-02-24T21:50:32.766+08:00SAP Business One 2007 System RequirementI have been searching for SAP Business One 2007 System Requirement for quite a long time. I am not sure why I cannot find it.<br /><br />Unfortunately, the company I work, just upgrade their B12005 to B12007 and apparently B12007 only support MSSQL Server 2005 (If you are using MSSQL) and It will work on SQL 2000, but if you encounter any problem, SAP guy do not have to answer you question, as the system requirement did not say they support SQL 2000...<br /><br />If you are looking for System Requirement for SAP Business One 2007.<br /><br />Here it is the link. Hope this can save you time.<br />B12007, SAP System Requirement.<br /><a href="https://websmp105.sap-ag.de/~sapidb/011000358700000310652008E.pdf">https://websmp105.sap-ag.de/~sapidb/011000358700000310652008E.pdf</a><br /><br />B12007 System Requirement, SAP System Requirement, B12007, B12005, SQL Server 2005智/Chihttp://www.blogger.com/profile/15160726870243326116noreply@blogger.com0