sql server reporting services: excel rendering - using formulas -- sql server reporting services

excel rendering - using formulas

Frank Cegelski
3/21/2005 1:05:06 PM

sql server reporting services:

I have a report with several textboxes that contain a formula, such as
"=reportitems!textbox2.value - reportitems!textbox1.value". In this case,
textboxes 1 and 2 may or may not contain another formula, such as
"=sum(fields!x.value)". My problem is that the original textboxes render ok,
but the textboxes referencing the others come up with an error. All three

RE: excel rendering - using formulas

Frank Cegelski
3/21/2005 2:55:02 PM

I found the problem. RS is using the report name as the worksheet name. If
the name has spaces in it, it will cause problems when the name is used in a
formula

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server reporting services group.