SSRS 2005 Expression Option Missing

rwheeler23
rwheeler23 used Ask the Experts™
on
I am tryig to add a sum in the footer of this report and when I right-click on the field in the footer, I am not getting the expression option. What must I do to get that option to appear?
SSRS-Expressions.jpg
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Jason YousefSr. BI  Developer
Commented:
Hi,

Just double click to highlight the existing expression and right click. and you'll get the option to change it.


Sum in the footer
Please refer above screenshot for your referecene,
or
Just Press F4 and select Expression and Change expression like SUM(Field name)

rwheeler23President

Author

Commented:
OK, but most times I can just right click and there is the expression option and then other times I do not get the option when I right click? Is there some setting that is controlling that?
Jason YousefSr. BI  Developer

Commented:
No, nothing controls it, expressions starts with = , in ssrs 2005 it's little bit annoying, that's not in 2008 anymore.

you could select the txt box or highlight inside it and it'll be enabled.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial