About the SSRS Perameter Expression

  • Hello guys,

    I need help with expression in SSRS which can give me last week of the previous month by default. and that only option I can get while user trying to run the report. only last week of the previous month

    Thank you

  • What do you want exactly with the "last week"?

    The week number? The first day of that week? The first and the last day of that week?

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • whole last week of the previous month

    Thanks

  • Ravikptel (10/15/2013)


    Hello guys,

    I need help with expression in SSRS which can give me last week of the previous month by default. and that only option I can get while user trying to run the report. only last week of the previous month

    Thank you

    If you want the only option to be "last week of the previous month", why have it as a parameter at all?

    Just code it into the data source.

    MM



    select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);

  • Forum Etiquette: How to post Reporting Services problems
  • [/url]
  • Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
  • [/url]
  • How to Post Performance Problems - by Gail Shaw
  • [/url]

  • Hi Budd,

    I want last week of the previous month by default into parameter. and if there is an option for the user. they can pick only last week of the month only there is no more option for the other days.

    Thanks

  • I'm really sorry, but I just don't understand what you want.

    What parameters do you want default values in ?

    What data type are those parameters?

    Can they hold other values than the default?

    Can the user choose a value?

    From what source?

    What specific values would you expect to see if you ran the report today - please provide actual date(s) ?

    MM



    select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);

  • Forum Etiquette: How to post Reporting Services problems
  • [/url]
  • Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
  • [/url]
  • How to Post Performance Problems - by Gail Shaw
  • [/url]

  • Hi MM,

    What parameters do you want default values in ?

    I want (AsOF_Dt) Parameter. which shows by default last week of the previous month

    What data type are those parameters?

    datatype of that parameters is Date/Time

    Can they hold other values than the default?

    yes they only can hold each month of last week.

    Can the user choose a value?

    yes

    From what source?

    from log table

    What specific values would you expect to see if you ran the report today - please provide actual date(s) ?

    if I run the report today. It suppose to show last week of the previous month .

    Thanks

  • Viewing 7 posts - 1 through 6 (of 6 total)

    You must be logged in to reply to this topic. Login to reply