Hi,

In order to help you find this script faster…

There it is:

select left(CONVERT(varchar(10), GETDATE(), 103) ,12) will return 30/12/2008

Ronen

• Read more
• 1 comment(s)

Hi all,

Finally the oracle connector has been released.

Download the SSIS Connectors for Oracle and Teradata that provide additional value for SQL Server Integration Services (SSIS) 2008 from this link.

http://www.microsoft.com/downloads/details.aspx?FamilyId=D9CB21FE-32E9-4D34-A381-6F9231D84F1E&displaylang=en

Have fun,

Ronen

• Read more
• 1 comment(s)

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 to install the Professional client.

Try it,

Ronen

• Read more
• No comments

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

• Read more
• 2 comment(s)

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 TO CLIPBOARD

Specifying TCP/IP port

Driver={MySQL ODBC 3.51 Driver};Server=data.domain.com;Port=3306;Database=myDataBase;User=myUsername; Password=myPassword;Option=3;

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

Specifying character set

Driver={MySQL ODBC 3.51 Driver};Server=data.domain.com;charset=UTF8;Database=myDataBase;User=myUsername; Password=myPassword;Option=3;

COPY TO CLIPBOARD

OLE DB, OleDbConnection (.NET)

Standard

Provider=MySQLProv;Data Source=mydb;User Id=myUsername;Password=myPassword;

COPY TO CLIPBOARD

MySQL Connector/Net (.NET)

Standard

Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;

Default port is 3306.

COPY TO CLIPBOARD

Specifying port

Server=myServerAddress;Port=1234;Database=myDataBase;Uid=myUsername;Pwd=myPassword;

Download the driver at MySQL Developer Zone >>

COPY TO CLIPBOARD

Named pipes

Server=myServerAddress;Port=-1;Database=myDataBase;Uid=myUsername;Pwd=myPassword;

It is the port value of -1 that tells the driver to use named pipes network protocol. This is available on Windows only. The value is ignored if Unix socket is used.

COPY TO CLIPBOARD

Multiple servers

Use this to connect to a server in a replicated server configuration without concern on which server to use.

Server=serverAddress1 & serverAddress2 & etc..;Database=myDataBase;Uid=myUsername;Pwd=myPassword;

COPY TO CLIPBOARD

Using encryption

This one activates SSL encryption for all data sent between the client and server. The server needs to have a certificate installed.

Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;Encryption=true;

This option is available from Connector/NET version 5.0.3. In earlier versions, this option has no effect.

COPY TO CLIPBOARD

Specifying default command timeout

Use this one to specify a default command timeout for the connection. Please note that the property in the connection string does not supercede the individual command timeout property on an individual command object.

Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;default command timeout=20;

This option is available from Connector/NET version 5.1.4.

COPY TO CLIPBOARD

Specifying connection attempt timeout

Use this one to specify the length in seconds to wait for a server connection before terminating the attempt and receive an error.

Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;Connection Timeout=5;

COPY TO CLIPBOARD

Inactivating prepared statements

Use this one to instruct the provider to ignore any command prepare statements and prevent corruption issues with server side prepared statements.

Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;Ignore Prepare=true;

The option was added in Connector/NET version 5.0.3 and Connector/NET version 1.0.9.

COPY TO CLIPBOARD

Specifying port

Use this one to specify what port to use for the connection.

Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;Port=3306;

The port 3306 is the default MySql port.

The value is ignored if Unix socket is used.

COPY TO CLIPBOARD

Specifying network protocol

Use this one to specify which network protocol to use for the connection.

Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;Protocol=socket;

"socket" is the default value used if the key isn't specified. Value "tcp" is an equivalent for "socket".

Use "pipe" to use a named pipes connection, "unix" for a Unix socket connection and "memory" to use MySQL shared memory.

COPY TO CLIPBOARD

Specifying character set

Use this one to specify which character set to use to encode queries sent to the server.

Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;CharSet=UTF8;

Note that resultsets still are returned in the character set of the data returned.

COPY TO CLIPBOARD

Specifying shared memory name

Use this one to specify the shared memory object name used for the communication.

Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;Shared Memory Name=MYSQL;

This one is applicable only when the connection protocol value is set to "memory".

COPY TO CLIPBOARD

MySqlConnection (.NET)

eInfoDesigns.dbProvider

Data Source=myServerAddress;Database=myDataBase;User ID=myUsername;Password=myPassword;Command Logging=false;

COPY TO CLIPBOARD

SevenObjects MySqlClient (.NET)

Standard

Host=myServerAddress;UserName=myUsername;Password=myPassword;Database=myDataBase;

COPY TO CLIPBOARD

Core Labs MySQLDirect (.NET)

Standard

User ID=root;Password=myPassword;Host=localhost;Port=3306;Database=myDataBase; Direct=true;Protocol=TCP;Compress=false;Pooling=true;Min Pool Size=0;Max Pool Size=100;Connection Lifetime=0;

COPY TO CLIPBOARD

MySQLDriverCS (.NET)

Standard

Location=myServerAddress;Data Source=myDataBase;User ID=myUsername;Password=myPassword;Port=3306;Extended Properties="""";

• Read more
• 1 comment(s)

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 

• Read more
• No comments

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

• Read more
• 3 comment(s)

Hi ,

In order to show the parameters of the report on the body ( BEST PRACTICE),use the following code on the custom code properties.

Function ParameterList(ByVal Parameter As Object) As String

Dim sParamItem As Object

Dim sParamVal As String = ""

For Each sParamItem In Parameter

If sParamItem Is Nothing Then Exit For

sParamVal &= sParamItem & ", "

Next

Return sParamVal.SubString(0, sParamVal.Length - 2)

End Function

Then use the following code on the text box that show the parameters:

="Report Filtered By: " +"Param1: "&Code.ParameterList(Parameters!ParamID.Label).

Bye,

Ronen

• Read more
• 3 comment(s)

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

• Read more
• No comments

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 day of the next month

DateSerial(iif( Month(DateTime.Now)=12, Year(DateTime.Now)+1, Year(DateTime.Now)), iif( Month(DateTime.Now)=12, 1, Month(DateTime.Now) + 1), 1)

Enjoy!

Ronen

• Read more
• 1 comment(s)

The ProClarity 6.3 SP2 is now available from the Microsoft Download center.

You can download the SP2 files from the following locations:

ProClarity Analytics Server 6.3 SP2

ProClarity Desktop Professional 6.3 SP2

• Read more
• No comments

Hi all,

At last the SP is available.

For more information about what's available in SP2, please check the online help:

Office Online: http://office.microsoft.com/en-us/performancepoint/FX102380591033.aspx

Overview of specific enhancements in Service Pack 2:

Ronen

• Read more
• 1 comment(s)