none
Expressions don't work in SSRS at all in VS2010 RRS feed

  • Question

  • I've got one project in VS2010 when I use SSRS - lots of raports, and in that project I'm using form authentication and everything is fine. (This is a web site in C# in ASP)

    I had to change my project to windows authentication, and everything would be great, and logging works fine, but raports don't work fine. In all textboxes in rdlc file are #Errors. In lots of textboxes I used expressions with condition that when the value is null then show '-'. It looks like this:

    =IIf((First(Fields!name.Value, "nameOfDataset") Like ""),"-",First(Fields!name.Value, "nameOfDataset"))

    but when I set only:

    =First(Fields!name.Value, "nameOfDataset")

    it works ok.

    Not only this expression doesn't work. I need to show page numbers, and in old project that works fine. In second project the expression:  =Globals!PageNumber     doesn't work.

    I don't know what happened. I only changed logging method to Windows Authentication, and nothing else was changed, and I have no idea why exprssions in textboxes do not work.

    Need help please!!!!

    Friday, September 13, 2013 9:31 AM