About the SSRS Perameter Expression

Question

Post reply

About the SSRS Perameter Expression

Ravikptel

SSC Enthusiast

Points: 145
More actions
October 15, 2013 at 2:04 pm

#278859

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
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]

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 1

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

Ravikptel SSC Enthusiast Points: 145 More actions · Answer 2

Ravikptel

SSC Enthusiast

Points: 145

October 15, 2013 at 2:34 pm

#1658713

whole last week of the previous month

Thanks

mister.magoo SSC-Forever Points: 47174 More actions · Answer 3

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);

Ravikptel SSC Enthusiast Points: 145 More actions · Answer 4

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

mister.magoo SSC-Forever Points: 47174 More actions · Answer 5

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);

Ravikptel SSC Enthusiast Points: 145 More actions · Answer 6

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