error :'... parameter could not be resolved because it was referenced in an inner subexpression.'

• marija.ruf

  Valued Member

  Points: 73

  More actions

  September 18, 2015 at 1:41 am

  #311668

  Hello everyone!

  I'm building a report in ssrs using MS SQL server Analysis Services for Data Source.

  For designing report I'm using Query designer where I want to create Calculated member with parameter.

  When I write in Calculated member:

  StrToMember("[Dim Vrijeme].[Mjesec u godini].&[" + CStr(@FromDimVrijemeMjesecugodini) + "] "

  I get this error:

  'The FromDimVrijemeMjesecugodini parameter could not be resolved because it was referenced in an inner subexpression.'

  When I write this:

  'AGGREGATE ( { " + Parameters!FromDimVrijemeMjesecugodini.Value + " : " + Parameters!ToDimVrijemeMjesecugodini.Value + " } ) '

  I get null value.

  For now I just want to get a Parameter value witch I can use for some calculation in Calculated member.

  Thank you!

  bye