dbTalk Databases Forums  

Reporting Services Error - Formula error

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Reporting Services Error - Formula error in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Durval Mateus
 
Posts: n/a

Default Reporting Services Error - Formula error - 03-16-2005 , 01:31 PM






Hi All,


When i run a report i have the following error:


"An error has occurred during report processing. (rsProcessingAborted) Get
Online Help
Query execution failed for data set 'ListMeses'. (rsErrorExecutingCommand)
Get Online Help
Formula error - syntax error - token is not valid:
"{DESCENDANTS({[Date].[All Date].[2005] }^,^ [Date].[Nome Mes])}" "


The strange thing is:

I have in one machine with everything installed and the reports works fine.

I installed in client's machine Anlysis Services, Reporting Services,
Services Packs, etc

i made a backup of my cube, and put in client.

put the report as well, and gives this error!

what could be making this different behaviour?

I have run the query in the MDX Sample application on client's machine and
works fine.

Any suggestions?

Thanks in Advance
Durval Mateus

Reply With Quote
  #2  
Old   
Ohjoo Kwon
 
Posts: n/a

Default Re: Reporting Services Error - Formula error - 03-16-2005 , 08:06 PM






Next is original syntax of Descendants().

Descendants(¡ìMember¡í, [¡ìLevel¡í[, ¡ìDesc_flags¡í]])

It did not support Set as a parameter, but it began to support Set since
SP3.

So I wonder you apply SP3 or higher.

Ohjoo Kwon


"Durval Mateus" <DurvalMateus (AT) discussions (DOT) microsoft.com> wrote

Quote:
Hi All,


When i run a report i have the following error:


"An error has occurred during report processing. (rsProcessingAborted) Get
Online Help
Query execution failed for data set 'ListMeses'. (rsErrorExecutingCommand)
Get Online Help
Formula error - syntax error - token is not valid:
"{DESCENDANTS({[Date].[All Date].[2005] }^,^ [Date].[Nome Mes])}" "


The strange thing is:

I have in one machine with everything installed and the reports works
fine.

I installed in client's machine Anlysis Services, Reporting Services,
Services Packs, etc

i made a backup of my cube, and put in client.

put the report as well, and gives this error!

what could be making this different behaviour?

I have run the query in the MDX Sample application on client's machine and
works fine.

Any suggestions?

Thanks in Advance
Durval Mateus



Reply With Quote
  #3  
Old   
Durval Mateus
 
Posts: n/a

Default Re: Reporting Services Error - Formula error - 03-17-2005 , 01:55 PM



thanks for the reply.

Indeed i had not installed SP3 for Analysis Services.

I have installed but the problem remains.

i'm deciding to format pc and start from the begining.

thanks for the help

Durval Mateus

"Ohjoo Kwon" wrote:

Quote:
Next is original syntax of Descendants().

Descendants(¡ìMember¡Ã*, [¡ìLevel¡Ã*[, ¡ìDesc_flags¡Ã*]])

It did not support Set as a parameter, but it began to support Set since
SP3.

So I wonder you apply SP3 or higher.

Ohjoo Kwon


"Durval Mateus" <DurvalMateus (AT) discussions (DOT) microsoft.com> wrote in message
news:352BF2A7-86CC-4B8A-9FBC-77A4A666C4DE (AT) microsoft (DOT) com...
Hi All,


When i run a report i have the following error:


"An error has occurred during report processing. (rsProcessingAborted) Get
Online Help
Query execution failed for data set 'ListMeses'. (rsErrorExecutingCommand)
Get Online Help
Formula error - syntax error - token is not valid:
"{DESCENDANTS({[Date].[All Date].[2005] }^,^ [Date].[Nome Mes])}" "


The strange thing is:

I have in one machine with everything installed and the reports works
fine.

I installed in client's machine Anlysis Services, Reporting Services,
Services Packs, etc

i made a backup of my cube, and put in client.

put the report as well, and gives this error!

what could be making this different behaviour?

I have run the query in the MDX Sample application on client's machine and
works fine.

Any suggestions?

Thanks in Advance
Durval Mateus




Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.