I am trying to build a report in Reporting Services 2005, which could be exported to Excel.
what i need is that the report would be able to export some formulas from reporting services as well.
the problem starts when i try to sum something :
this formula i have created in reporting services
=(ReportItems!X.Value+ReportItems!Y.Value-ReportItems!Z.Value*255
after exporting looks something like this =_X&_Y-_Z*255
but it should be =_X+_Y-_Z*255
i tried to convert the fields before adding them to formula like =CDbl(ReportItems!X.Value)
but it doesn't work when i'm trying to include a result of one formula in calculation of another result...
this will gibe an output as a string, what i need is a numeric formula
the excel output is similar to this....
="=" &_X&"&" & _Y& "-" & _Z& "*255"
Bodestone
Yeah, sorry, I see what you mean now.
Hmmm, it seems to be replacing the plus with an ampersand, everything else looks OK right?
I shall ponder and ruminate since nothing springs to mind immediately.
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
x30n30
ASKER
yes everything else works fine,
reason for this problem is that in Reporting Services the plus sign has two meanings - summarizing figures and merging two strings. & has only one meaning - merging 2 strings.
and for some reason excel wants to use the wrong meaning of (+) :D
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
Unlimited question asking, solutions, articles and more.
Bodestone
Aye, I couldn't find a way round the conversion of + to & so I thought, just do away with the +.
Far from elegant but if it works until a proper solution is found....