If i use the F7L datasource and I have an url parameter for instance 'foo;
and I use a filter for example
Title = @url_foo
i get the following error
A critical error has occurred.
Cannot find column [@url_foo]
the same setup works if I use an older query to get my user defined table data
SELECT
dbo.UserDefinedRows.UserDefinedRowId, Data1.FieldValue AS Title, Data2.FieldValue AS Summary
FROM
dbo.UserDefinedData AS Data1
INNER JOIN
dbo.UserDefinedFields AS Fields1 ON Data1.UserDefinedFieldId = Fields1.UserDefinedFieldId
INNER JOIN
dbo.UserDefinedRows ON Data1.UserDefinedRowId = dbo.UserDefinedRows.UserDefinedRowId
INNER JOIN
dbo.UserDefinedData AS Data2 ON dbo.UserDefinedRows.UserDefinedRowId = Data2.UserDefinedRowId
INNER JOIN
dbo.UserDefinedFields AS Fields ON Data2.UserDefinedFieldId = Fields.UserDefinedFieldId
WHERE
(Fields1.FieldTitle = 'Title')
AND (Fields.FieldTitle = 'Summary')
AND (dbo.UserDefinedRows.ModuleId = 713) AND (Data1.FieldValue like @url_foo)
but this is not the most optimal query so I was hoping to use the reports f&l datasource but so far nu luck with url parameters