Hi

You can display estimated query plan and analysis the steps of every satement.

You can use Tuning Advisor or SQL Server Profiler

Did you really try this?

Just select a table...

The best way to avoid SQL Injection is use of Stored Procedures.

and for SSAS use http://www.ssas-info.com

For SSIS go through the site http://www.sqlis.com

Hi Elsa,

You can use Dataset in Header/Footer but you cant view all the details.

You can see only SUM, FIRST, LAST, COUNT etc.

Hi B_boy,

Use following format in ReportItem:- £#,##0.00

--1.

SELECT SERVERPROPERTY('InstanceName')

--2

sp_helpserver

--3

select @@SERVERNAME

--4

SELECT * FROM SYS.SYSSERVERS

--5

SELECT * FROM SYS.SERVERS

And if you required Running Number Total then you can use:

=RunningValue(Fields!FieldName.Value,SUM,Nothing)

Instead of Function you could use following expression in your report item:

=Sum(Fields!FieldName.Value, "DataSetName")

Hi,

you could create parameters for PcDiff Function and paas the values of fields in PcDiff.

However you can't access the Field values directly by using Fields!FieldName.Value

Hi,

You can multiply the Data Values with some fixed number so that scale will be increased during run time.

However its not a good approach but will serve the purpose.

You can...

I am confused about the variable @Condition.

Is it a parameter or variable?

You can use DATEFORMAT to change the format of date.

The following example uses different date...

I think this expression works like this:

set @SqlFilter = @SqlFilter + '''' + '' + dbo.fnDoubleQuotes(@MatchFieldValue)

It means if there...