I have a dataset in my report which returns one field and one record.
What I would like to do is use that record's value in another dataset to return results based on the first dataset but I keep getting errors relating to the syntax of my query.
I have attached a code snippet. The part that says 'First(Fields!SUMUSER.Valu
e, "DataSet2")' is the part of the sql I am not sure is correct.
Many thanks in advance
SELECT CLA_NO, CLA_NAME
WHERE CON(CLA_NO, 'First(Fields!SUMUSER.Value, "DataSet2")')='Y' AND cla_co='01' and cla_status <> '3' and CLA_NO LIKE 'C%' ORDER BY CLA_NO DESC