Calender Error in SSRS with SSAS Tabular Source

• RADISSOUFAN

  Old Hand

  Points: 333

  More actions

  September 21, 2023 at 7:42 am

  #4290893

  I have a report which get a Date Parameter..

  I don't want to display That as a default list..

  I found what I want exactly on

  https://www.mssqltips.com/sqlservertip/3451/calendar-date-picker-for-mdx-based-sql-server-reporting-services-reports/

  when I go with tutorial I did This

  

  

  

  I used  the

  following Function

  ="[DIM_CREATE_DATE].[Date].&["+format(Parameters!DIMCREATEDATEDate.Value,"yyyyMMdd")+"]"

  

  an now I get the following Error

  

  any one can help me how to solve it?

  • This topic was modified 1 year, 3 months ago by  RADISSOUFAN.
  • This topic was modified 1 year, 3 months ago by  RADISSOUFAN.
  • This topic was modified 1 year, 3 months ago by  RADISSOUFAN.

• frederico_fonseca

  SSCoach

  Points: 16167

  More actions

  September 21, 2023 at 7:52 am

  #4290901

  read this for an explanation https://stackoverflow.com/questions/46312573/ssrs-the-restrictions-imposed-by-the-constrained-flag-in-the-strtoset-function