problems with installing proclarity desktop pro 6.3 on vista or XP SP3

23/12/2008

Hi all, There is an  issue when installing on Vista where the Desktop installer gets in a loop where it cannot detect the 3.1 v2 Windows Installer or XML 6.0. The popup is titled “ProClarity Install Prerequisites” and will loop even after rebooting. The way to get around this issue is to run the setup.exe from within the installation files, instead of from the Professional installation splash screen. Drill all the way into the installation until you reach the level shown in the screenshot below, and then run the setup.exe. This should end the loop and allow you...
תגיות: , ,
אין תגובות

SSRS Templete

22/12/2008

  Hi, You can use  template behavior by creating specific reports you'd like to have your team use as starters and placing them at  C:\ProgramFiles\Microsoft SQL Server\80\Tools\ReportDesigner\~ProjectItems\~Report-Project directory. Those report "templates" will then show up in Report Designer's. Add New Item dialog along with the Report Wizard, Report, and Data Source templates when you go to add a new report to a project.   Ronen Technorati Tags: SSRS 2008
תגיות: , ,
2 תגובות

MySQL Connector / ODBC 2.50

Technorati Tags: DEV,MYSQL,2008 Hi, Those of you who has to deal with Mysql, here are the connection string that can possibly help you. Have fun. Ronen Local database Driver={mySQL};Server=localhost;Option=16834;Database=myDataBase; COPY TO CLIPBOARD Remote database Driver={mySQL};Server=myServerAddress;Option=131072;Stmt=;Database=myDataBase; User=myUsername;Password=myPassword; COPY TO CLIPBOARD Specifying TCP/IP port Driver={mySQL};Server=myServerAddress;Port=3306;Option=131072;Stmt=;Database=myDataBase; User=myUsername;Password=myPassword; The driver defaults to port value 3306, if not specified in the connection string, as 3306 is the default port for MySQL. COPY TO CLIPBOARD MySQL Connector/ODBC 3.51 (MyODBC 3.51) Local database Driver={MySQL ODBC 3.51 Driver};Server=localhost;Database=myDataBase; User=myUsername;Password=myPassword;Option=3; COPY TO CLIPBOARD Remote database Driver={MySQL ODBC 3.51 Driver};Server=data.domain.com;Database=myDataBase;User=myUsername; Password=myPassword;Option=3; COPY...
תגובה אחת

Sql 2005 SP3 is now available

Hi, Sql 2005 SP3 is now available. Read all about it at this link:   http://support.microsoft.com/default.aspx?scid=kb;en-us;959823&sd=rss&spid=2855 The feature pack was also updated: http://www.microsoft.com/downloads/details.aspx?FamilyID=536FD7D5-013F-49BC-9FC7-77DEDE4BB075&displaylang=en Bye, Ronen   
אין תגובות

Another option for alternate color line

18/12/2008

Hi, As I blogged before, there are several ways to control alternate line color. Here is another way to do it. It uses custom code. private bOddRow as Boolean Function AlternateColor(ByVal OddColor As String ,ByVal Toggle As Boolean ,ByVal EvenColor As String) As String     If Toggle Then bOddRow = Not bOddRow     If bOddRow then          Return OddColor      Else         Return EvenColor     End If End Function Then, paste this line on the table row. =Code.AlternateColor("AliceBlue",False,"White") Enjoy, Ronen
תגיות: ,
2 תגובות

Report parameter in the URL

17/12/2008

If a report requires query parameters, you can directly insert parameter valuesinto the URL. A report parameter is entered into a URL without the rs:Command= prefix, as shown in the following example:  http://localhost/ReportServer?/Reports/SalesReport&rs:Command=Render&SalespersonID=1232  Enjoy, Ronen
אין תגובות

SSRS 2008 Parameters

Hi all, As we all deal now with the new ssrs2008, I will deploy several posts about Best Practice… In SQL Reporting Services, parameters can be: hard coded an expression, or from a query Hard coded values will never be used. Expressions may be good for some instances, but because it's not linked with your data, it may not be good enough. --Expression to get the 1st day of the previous month (aka Start Date) DateSerial(iif( Month(DateTime.Now)=1, Year(DateTime.Now)-1, Year(DateTime.Now)), iif( Month(DateTime.Now)=1, 12, Month(DateTime.Now) - 1), 1) --Expression to get the 1st day of the current month (aka End Date) DateSerial(Year(DateTime.Now), Month(DateTime.Now),1) --Expression to get the 1st...
תגובה אחת