Search code examples
reporting-servicesssrs-2012ssrs-tablix

Using Lookup function if it contains any function in SSRS report?

I have to define a lookup like this in my *.rdl file;

=IIF(Parameters!CompanyId.Value<>67,IIF(LAST(Fields!GallonsPumped.Value)>0, 0, " "),
Lookup(Fields!TankDateCombo.Value, Fields!TankDateCombo.Value,IIF(LAST(Fields!GallonsPumped.Value)>0, 0, " "),"Dataset2"))

But I get error saying that I canot use functions in LOOKUp. How can I do this in correctway>

enter image description here

Solution

  • I have fixed like this(surrounding lookup with function name) eg:

    =IIF(Parameters!CompanyId.Value<>67, IIF(LAST(Fields!GallonsPumped.Value)>0, 0, " "),

IIF(LAST(Lookup(Fields!TankDateCombo.Value, Fields!TankDateCombo.Value,Fields!GallonsPumped.Value,"Dataset2"))>0, 0, " ")


)