Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

About the SSRS Perameter Expression Expand / Collapse
Author
Message
Posted Tuesday, October 15, 2013 2:04 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, April 29, 2014 11:20 AM
Points: 9, Visits: 30
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
Post #1504962
Posted Tuesday, October 15, 2013 2:19 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 2:43 AM
Points: 13,559, Visits: 10,435
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?




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1504967
Posted Tuesday, October 15, 2013 2:33 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, April 29, 2014 11:20 AM
Points: 9, Visits: 30
whole last week of the previous month



Thanks
Post #1504976
Posted Tuesday, October 15, 2013 2:37 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: 2 days ago @ 5:29 PM
Points: 1,787, Visits: 5,693
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


  • MMGrid Addin
  • MMNose Addin


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

  • Post #1504980
    Posted Tuesday, October 15, 2013 2:42 PM
    Forum Newbie

    Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

    Group: General Forum Members
    Last Login: Tuesday, April 29, 2014 11:20 AM
    Points: 9, Visits: 30
    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
    Post #1504983
    Posted Tuesday, October 15, 2013 4:03 PM


    SSCommitted

    SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

    Group: General Forum Members
    Last Login: 2 days ago @ 5:29 PM
    Points: 1,787, Visits: 5,693
    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


  • MMGrid Addin
  • MMNose Addin


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

  • Post #1505013
    Posted Tuesday, October 15, 2013 6:37 PM
    Forum Newbie

    Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

    Group: General Forum Members
    Last Login: Tuesday, April 29, 2014 11:20 AM
    Points: 9, Visits: 30
    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
    Post #1505037
    « Prev Topic | Next Topic »

    Add to briefcase

    Permissions Expand / Collapse