HI,

I don't know if I understand your doubt, Do you want filter the DeptoId parameter?

You can filter the Dataset of DeptoId using the statment like this:

Select Depto, DeptoId

from Depto

where IdCompany...

HI,

I don't know if I understand your doubt, Do you want filter the DeptoId parameter?

You can filter the Dataset of DeptoId using the statment like this:

Select Depto, DeptoId

from Depto

where IdCompany...

Andreas,

you need a geometry layer, try use a Shapefile or spatial data with a geometry column, after this you need create a layer with your geography column.

Marios,

try to use this code:

;WITH XMLNAMESPACES (

DEFAULT'http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition',

'http://schemas.microsoft.com/SQLServer/reporting/reportdesigner'

AS rd)

SELECTIV.name,IV.[PATH],t.value('DataSourceName[1]', 'varchar(100)') as Data_Source,DS.[PATH] as DataSourcePATH

FROM (

SELECTname, [PATH], cast(cast(content as varbinary(max)) as xml) as content_as_xml

fromdbo.[Catalog]

WHEREType = 2

and content is not null...