http://www.bizpassion.com Passion for Technology and Business Mon, 21 Jul 2008 22:34:13 +0000 http://backend.userland.com/rss092 en When building a report in SQL Server Reporting Services, we often use date as parameters. When you create dataset from SQL Server Analysis Services source, by default the date will be treated as string and you will have a drop down list of date. In SQL Server 2005, Reporting Services ... http://www.bizpassion.com/?p=84 When you generate a chart using date dimension for x-axis, by default, it will try to show every date as label, which make the label unreadable if you have hundreds of date. This problem can be resolved by setting "interval" in "Major gridlines". For example, if you put "5" in ... http://www.bizpassion.com/?p=83 When designing dataset in Report Designer, null value is ignored by default because the corresponding MDX query uses "NON EMPTY" keyword. This raises a problem in reporting when Date is a dimension because we want to show every date in the range even there is no item or value for ... http://www.bizpassion.com/?p=82 HTTPRequestURIStem is the column contains file path, e.g. /webpage/default.aspx REVERSE(SUBSTRING(REVERSE(REVERSE(SUBSTRING(REVERSE(HTTPRequestURIStem),0, CHARINDEX('/',REVERSE(HTTPRequestURIStem))))),0, CHARINDEX('.',REVERSE(REVERSE(SUBSTRING(REVERSE(HTTPRequestURIStem),0, CHARINDEX('/',REVERSE(HTTPRequestURIStem)))))))) This function will return "aspx" for "/webpage/default.aspx". NOTICE: I put the code in seperate lines for readablity. http://www.bizpassion.com/?p=81 One of my friend called me two months ago because he could not open his MSN Messenger. When he double click the MSN icon, it was simply no response. However, MSN process was shown in Task Manager. I tried to reinstall the program but the problem persisted. A couple of ... http://www.bizpassion.com/?p=80 1. Why Windows Server 2003 and IIS? The optimal environment for running PHP + MySQL application is a Linux server running Apache Web Server. It requires minimal setup and assures the best performance and reliability. However, what if .NET applications are required to run on the same server? I guess the ... http://www.bizpassion.com/?p=79 mail() is a useful and powerful function in PHP, but many developers got problems to make mail() work properly on Windows. Many these problems were related to headers and different line feed formats between Windows and Linux. However, this post does not address these problems. The problem I encountered last ... http://www.bizpassion.com/?p=78 This is not the first time I read news articles about tough questions interviewees were asked during an interview for top companies such as Google. My favorite one is "why are the sewer lids round in shape instead of square"? I have always questioned about the effectiveness of those questions, especially ... http://www.bizpassion.com/?p=77 I have not updated my blog for almost seven months. The main reason is that I am making some big move! I am getting into finance! I have been preparing my Charted Financial Analyst exams for months. Anyway, I need to write about CFA in another post, so I'd better talk ... http://www.bizpassion.com/?p=76 A legacy program we have requires to use a modem to dial-up. The modem is Diamond SupraMax LE internal PCI modem, and the oprating system is Fedora Core 6. Because the modem is using a SmartLink chip, my initial try was to build slmodem downloaded from: http://linmodems.technion.ac.il/packages/smartlink/slmodem-2.9.11-20061021.tar.gz Note: For newest Smartlink linmodem ... http://www.bizpassion.com/?p=73