0

I have an issue with SSRS. In a filed called "InformacionDirecta" from the dataset "Solicitud" I have the following expression:

=iif(Fields!ModifInfoDirecta.Value,chr(254), chr(168))

It works well and shows me the type of checkbox I want according the value returned by the field (true or false) but, when I add another dataset ("Dataset2") the report shows me an error that says:

"the value expression for the textbox refers directly to the field without specifying a dataset aggregate".

How could I solve that?

Brian Tompsett - 汤莱恩
  • 5,753
  • 72
  • 57
  • 129
David Acosta
  • 27
  • 1
  • 1
  • 5
  • It's tough to be sure without seeing your report, but you probably have a table without a Dataset defined. All tables need a Dataset; but if you haven't specified a Dataset for a table but only have one Dataset in the report it will just use that and work fine. But as soon as you add another Dataset you will have to explicitly define the Dataset for all tables in the report. – Ian Preston Apr 22 '14 at 08:53
  • ^ What he said. Read about "Data regions" – kyzen Apr 22 '14 at 13:26
  • http://stackoverflow.com/questions/9676149/ssrs-expression-using-different-dataset-fields – Eric Hauenstein Apr 22 '14 at 18:01

0 Answers0