Monthly Archives: November 2008

Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding (SQLUtilities)

Posted on November 29, 2008 by chanmingman

Recently I have written a small search utility to search the text contain in SQL database. This utility was divided into three major parts. One important trick to avoid the above error is as follow:   1.       Retrieving all the … Continue reading →

Posted in .Net | Leave a comment

The report parameter ‘sales’ has a DefaultValue or a ValidValue that depends on the report parameter “sales”. Forward dependencies are not valid.

Posted on November 22, 2008 by chanmingman

LiveJournal Tags: Reporting Services Parameter Error Technorati Tags: Reporting Services Parameter Error Normally you will encounter the above error when you intend to make your parameter as a selection (dropdown) as follows: When developers try it in the first time and … Continue reading →

Posted in Uncategorized | 3 Comments

How-to Passing parameter for Analysis Services using MDX from Reporting Services

Posted on November 15, 2008 by chanmingman

In order to navigate from one report to another report that with parameter (Create a report with parameter) the developer will add a link by performing the following steps: 1. Right click the Textbox on the report –> Properties 2. … Continue reading →

Posted in Servers | 3 Comments

How-to start Business Intelligence in Microsoft SQL Server

Posted on November 13, 2008 by chanmingman

Business Intelligent is a concept. The users will not find a single product called Business Intelligent in Microsoft products’ stacks instead of Business Intelligent in Microsoft is formed by using various sets of Microsoft’s services and products. Business Intelligent can … Continue reading →

Posted in .Net | Leave a comment

One thing you cannot achieve using command prompt but Windows PowerShell

Posted on November 2, 2008 by chanmingman

I found it is not so special to run vbs (Visual Basic Script) in Windows PowerShell because most of the time you can do that using cscript with command prompt (cmd.exe). But what I guarantee you cannot do is to … Continue reading →

Posted in Operating System | Leave a comment