I use to write livereports that use variables in SQL Server.
This is a working example:
****************************************************
DECLARE @CategoryID int;
SET @CategoryID = (SELECT Distinct CatID
FROM CatRegionMap
WHERE CatName='01-Technical')
SELECT *
FROM LLAttrData
WHERE DefID=@CategoryID
********************************************************
But when I try to use variables in a CS instance connected to an Oracle DB It seems not possible.
has anyone written Livereports using variables in a CS connected to Oracle?
