Today I ran into a strange problem in a report in SSRS. In the report I have one rectangle, in which I have some textboxes. Textboxes contains either static text or fields from datasets. One which shows static text work properly, but the one with values from dataset, shows me "#Error".

If I pull that suspicious textbox outside of the rectangle, then it works properly.

I must add that I have few datasets, both shared and embedded, and only from embedded dataset i can show values, while from shared datasets i constantly getting error.
–
veljasijeNov 22 '12 at 14:58

You're not providing enough info for us to answer your question. The "#Error" should also provide feedback on what the problem is. In fact, once you see the additional info it may very well be easy to fix your problem. (Also note that you can edit your question to add info, no need to use comments for that.)
–
JeroenNov 22 '12 at 16:06

Ok, Jeroen, thanks for suggestion, I'm very new to StackOverflow, so I need some time to catch all things about posting and editing :) I tried today to catch what cause problem to see error, and maybe I got some idea. When I tried to preview some field value from embedded dataset it works properly, in Preview mode I see given value. When I put some field from shared dataset into textbox expression, in Preview mode I see only famous #Error, in place of textbox. I suppose that problem is with shared dataset, but cannot be sure.
–
veljasijeNov 22 '12 at 18:34

Can you provide the expression code for the textbox in question
–
JKFNov 22 '12 at 21:43

@veljasije Don't worry about being new, and thanks for taking the time to "catch all things"! SO is a bit different from forums, for one you can always click the edit link below your question to improve it and add details requested in comments. This helps others answer your question, and helps people landing here through search queries to see if they have a similar question or not.
–
JeroenNov 23 '12 at 0:16