• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 455
  • Last Modified:

SSRS - simple question passing report parameter to dataset text?

Hello all,

I have a dataset that is using SYBASE DSN connection then text.  I have a parameter called BeginDate that is a string such as 'Dec 1 2009'.  My text currently has that string such as:

WHERE StartDate = 'Dec 1 2009'  I need to change this to use my new parameter I have called BeginDate.  When I went into the expression builder and selected my Parameter it placed in
 "Parameters!BeginDate.Value".  

This is throwing an error not liking the "!".  

Any idea what I am doing wrong>

Thanks all
0
sbornstein2
Asked:
sbornstein2
1 Solution
 
Faiga DiegelSr Database EngineerCommented:
Check to make sure you have that parameter on the list (left side node).
I'm assuming that should be =Parameters!BeginDate.Value
0
 
sbornstein2Author Commented:
thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

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