January 22, 2008 at 7:59 pm
I've just been playing around with RB and AS2005 and it all looks good until you want to use a function in Report Builder (RB)... then I get an error...
I tried a simple convert INT to TEXT function and it failed, however when i did the same for a model built of a relational source it all worked as expected.
I can only assume (can't find any specifically mentioned limitation via google) that this is because you need to express your functions in MDX?
That would make some sense but won't make it very easy for an end-user... Below is the error from the report server log... Not sure exactly whats it's talking about there...
ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing., ;
Info: Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for data set 'dataSet'. ---> Microsoft.ReportingServices.SemanticQueryEngine.SemanticQueryEngineException: Semantic query execution failed. ---> System.NotSupportedException: A grouping expression must be either a scalar field or an entity.
Appreciate any comments, if anyone has used formulas in RB I'd be interested to know how that was done.
Cheers
M
Martin
June 22, 2009 at 12:15 pm
I am experiencing the exact same problem you describe, except my case is even simpler. I'm just trying to do a LEFT(,3) and I get the same error message you describe. Did you ever find the resolution? Thanks for any help!
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply