Easy Newbie reporting services question

I'd like to learn more about what I can put in expressions.
For example: Fields!<FieldName>.Value.Length
Is very useful. I found it on this user group but could not find it in
the documentation (online books). The expression painter does not seem
to be much help.
Where can I find more information on what I can put into expressions?
Thanks in advance :)Hi,
Search for "Using Expressions in Reporting Services" and
"Expression Examples in Reporting Services" this on gives you how to use it
with examples.
Hope you might have seen this. but this is very useful. Moreover you can get
the help from "Edit Expression" form. click on any function. you can get the
help.
Amarnath
"mzwilli" wrote:
> I'd like to learn more about what I can put in expressions.
> For example: Fields!<FieldName>.Value.Length
> Is very useful. I found it on this user group but could not find it in
> the documentation (online books). The expression painter does not seem
> to be much help.
> Where can I find more information on what I can put into expressions?
> Thanks in advance :)
>

Dynamic XSD Schema Location For XML Source

I want to be able to programmatically set the schema location for an XML source. I first thought it would be a simple task using expressions and variables but it doesn't appear to allow anything in the way of setting it at runtime. Is this possible?

It does allow it, but you don't set the expression directly on the component. You have to set it on the data-flow that contains the component.

Switch back to control-flow and look at expressions of the data-flow. Its self-explanatory from there.

-Jamie

|||Beautiful! Thank you.|||Thanks Jamie... just wanted to chime in and say this was really helpful - I would have never thought of looking on the properties of the data flow.

Dynamic SQL in a RDL file?

Can I put parameters and change the SQL in a dataset using expressions?
Thanks
ScottYes. It is a little tricky but totally doable. First, make sure you have
your expression creating the appropriate SQL String. I usually create the
report with no dataset, just the parameters and then a textbox set to the
expression. This allows me to see the resultant SQL prior to using it for
the dataset. Then I like to first use a static query so that the field list
gets populated. Then (from the generic query window) set the SQL to the
expression. i.e. in the generic query window put
= iif(blah blah, blah, blah) & "whatever else your expression consists of" &
"etc etc"
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Scott Meddows" <scott_meddows_no_spm@.tsged-removeme.com> wrote in message
news:emp%23Bf65EHA.2568@.TK2MSFTNGP10.phx.gbl...
> Can I put parameters and change the SQL in a dataset using expressions?
> Thanks
> Scott
>