question

Eileen 1 avatar image
Eileen 1 asked

Textbox values not displaying correctly in SSRS 2008

I have a report with a data table and three textboxes above to show header type information. The textboxes are within the body of the report, not in the report header. Two of the three textboxes are working correctly, but for some reason, the value displayed in the third does not update as it should when moving from one page of the report to the next. Textbox 1, which works correctly, has this expression for its value: =Fields!FileName.Value Textbox 3, which does not work correctly, uses this expression: =Fields!Required.Value Both "FileName" and "Required" are fields contained in the query that populates the report, and the query runs correctly when executed in Query Designer. I've searched online and in Microsoft Help files, and I've looked at the xml code for each of the three textboxes and can't find a solution. I'm a real novice in SSRS, so any suggestions will be most appreciated.
ssrs-2008
4 comments
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

One test would be to swap out the expressions in one textboxthat works with one that doesn't. At least you would know if it is the expression itself or another issue. If memory serves, SSRS is very picky about the header area - if the textbox is barely in the header area, the values will not update.
0 Likes 0 ·
The problem could be related to the data type of the column named Required. Is it boolean (maps to bit in SQL Server)? Maybe you should try something like =IIF(Fields!Required.Value, "yes", "no")
0 Likes 0 ·
The problem could also be simply with the -size- of the textbox. Again, SSRS is very picky. A simple test for this would be to increase the size of the box well beyond what you think it needs. It will wreck your formatting, but will test for overflow.
0 Likes 0 ·
It looks like the issue was that the field I was using was boolean and I didn't have the expression quite right. I ended up using a different field from the base table and was able to accomplish what I needed. Thanks for all the good input.
0 Likes 0 ·

1 Answer

· Write an Answer
Fatherjack avatar image
Fatherjack answered
Personally I would place all of these items into a Rectangle object and see if that fixes it. It could be the size of a box over lapping the problem box and blotting it out. Try laying the boxes out vertically and see if they all show. It could be there is no data. Have you set the No Data property for the box? Try removing the data column and adding a fixed expression.
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.