Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 500
  • Last Modified:

Need help with getting Weekday from data parameter in SSRS report headder

I have a report that I am writing in SSRS.  In the report header, Iv'e got a textbox that I need to display "Wednesday 11/10/2010 yadda yadda yadda".  How do I get the "Wednesday"?

Currently I've got the textbox value set to:

= "For " & Parameters!ForDate.DayOfWeek & " " & Parameters!ForDate.Value & " yadda yadda yadda " 

but that just yields "For 0  11/8/2010 yadda yadda yadda"

How do I easily convert the numerical day value to text without a lot of syntax?

Thanks.
0
okacs
Asked:
okacs
  • 2
1 Solution
 
käµfm³d 👽Commented:
Try:
= "For " & Parameters!ForDate.DayOfWeek.ToString() & " " & Parameters!ForDate.Value & " yadda yadda yadda " 

Open in new window

0
 
okacsAuthor Commented:
DOH!  <smack>






Thanks!
0
 
käµfm³d 👽Commented:
NP. We've all had those moments  ;)
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now