Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Need help with Tree Prompt

Status
Not open for further replies.

loysqc

Technical User
Oct 30, 2006
23
CA
We need help!!!

We want to use a multi-select tree prompt for a report that use a dimensional model. But unfortunatly there is something wrong with our ReportNet environment. When we do that it show this error :

Erreur d'analyse syntaxique avant ou près de la position 113 de 'set([Dimension Layer].[Fournisseurs].[Fournisseurs].[Fournisseur niveau 5]->[all].[H].[H4].[H46].[H461].[H4611],'

As you see it finish with a "," like if he cannot understand it. It should be the separator before the next value.

As you see we use a French setup or ReportNet so I think it came from that. The problem is that the character used as separator between each selection in a Tree Prompt is "," but habitually it put a ";" between each value .. like when we use a Multi-Select ListBox prompt.

First, I want to know if on a english ReportNet setup the separator between each value is a ";" or a "," in each of this case ... (Multi-Select ListBox and Multi-Select Tree prompt)

Is there any people who had the same problem?

NB : In case you don't know how to see the string of your parameter, just use this function ParamValue('param') where param is the name of your parameter

Thank you for your help

L-D
 
Hey hey We find a way to bypass this problem .... When we Pack the report in Report Studio we just have to select an english language instead of the french one.

So it's seems that it is a bug from cognos ... but fortunatly we can bypass it.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top