Getting error with this query.. please help

SELECT ISNULL(solicitante_dir_ciudad,'DESCONOCIDO'),
COUNT(*) AS [Cantidad_de_Solicitantes],
COUNT(*) * 100.00 / (SELECT COUNT(*) FROM dat_datos_importados) AS [Por Ciento%] FROM dat_datos_importados
WHERE solicitante_dir_ciudad = CASE WHEN @Ciudad='TODOS' THEN solicitante_dir_ciudad ELSE @Ciudad END)
GROUP BY solicitante_dir_ciudad
ORDER BY solicitante_dir_ciudad

From where @Ciudad comes?

Om Prakash

HI,

Well i can see an extra closing paranthesis ")" just before END of case.

Please do mention the error statement also whenever u want others to look inside.

Gud luck

B. Anant

The value expression for the textbox ‘Ciudad’ refers to the field ‘Ciudad’. Report item expressions can only refer to fields within the current data set scope or, if inside an aggregate, the specified data set scope.

This is the query:

SELECT ISNULL(solicitante_dir_ciudad,'DESCONOCIDO'),
COUNT(*) AS [Cantidad_de_Solicitantes],
COUNT(*) * 100.00 / (SELECT COUNT(*) FROM dat_datos_importados) AS [Por Ciento%] FROM dat_datos_importados
WHERE solicitante_dir_ciudad = CASE WHEN @Ciudad='TODOS' THEN solicitante_dir_ciudad ELSE @Ciudad END
GROUP BY solicitante_dir_ciudad
ORDER BY solicitante_dir_ciudad

cross-post at http://p2p.wrox.com/topic.asp?TOPIC_ID=22216

_________________________
- Vijay G
Strive for Perfection