Function not working in Report Studio

[markcognos]

HI All,

Need help,I was finish to create my FM and Already Publish it,Then ill create a report in report studio and create Filter my example is left, Not only left,Ill create also cast in List but its not working i have an error.The function is not working,Ill already check the Project Function Listin in FM and all function is already their.

Example of my filter:
left([SALES].[order_number],1)<>'O'


Example of my cast in List:

cast([SALES].[order_number],Varchar(10))



Error says:

QE-DEF-0459 CCLException
QE-DEF-0260 Parsing error before or near position : 52 : "left([SALES].[order_number]"
QE-DEF-0261 QFWP - Parsing text: left([SALES].[order_number],1)<>'O'


above error is Same Error in List.

Is ther any way to Activate the Function in Report Studio?

[PRIT AMRIT]

hi there,

What is your Data Base?

Have a look at the screenshot. Have you included your DB? If not then just select the DB and click on 'left Arrow'(as shown in the screenshot) and re-publish your package. Doing so, you can use all the data base specific functions in your reports.

left([SALES].[order_number],1)<>'O'

The expression is correct. BTW, should it be 'O' or '0' ?

Thanks

[markcognos]

Hi Database is sql server,Ill already done this and ill test based on your screen shot,But it still have same error.

Thanks,

[IceTea]

Give it a try and do the "left" on the casted ordernumber, not direct on ordernumber.

[markcognos]

Hi the cast is also not working,I can view the data in list but when ill do use function,All function in Report Studio is not working after ill publish the Package.Cast and Left function ill do it for sample in filter and in list and testing if it's work,But it doesn't.

Thanks,

[PRIT AMRIT]

All function in Report Studio is not working after ill publish the Package.

Find attach screenshot.
Can you check in your environment, in report studio are you seeing all the Data Base folders under 'Vendor Specific Functions' folder?

[markcognos]

Hi,

Yes all the Function is in Their.

Ill try if statement and ill' try the order number into specific order like :

[SALES].[order_number]='M990001'

it's Work,But when ill Try other function like cast,extract,left,substr, is not work..


The function is not working in Report Studio when a NEW publish FM is Not Yet used in Any customization ..

When i try my Used Customized Report with the Other package and Create New ,in Same Report Studio,The function cast,extract,left is working properly.

Why is it the first new publish is not working for all function??

[PRIT AMRIT]

The function is not working in Report Studio when a NEW publish FM is Not Yet used in Any customization ..

When i try my Used Customized Report with the Other package and Create New ,in Same Report Studio,The function cast,extract,left is working properly.

What do you mean by Not yet used any customization or Used Customized report?

[markcognos]

Hi,
First I mean i have another Package that i used named Inventory, I already used that Package by Customizing Report in Report Studio.
Second I have New package named Sales,I Have not yet use that package in Customizing Report using Report Studio becouse it is a New Package that i crated in FM.

Example:
I have a existing report that the package is Inventory,and i open it,then click the new to create new report in Report Studio in that Inventory package,i test the function cast,left,extract,etc...the function is working,

While in the New created package named Sales,and create New report using Report studio,I test the fuction cast,left,extract,etc...the function is not working,my error is in the above explanation.


Thanks,

[PRIT AMRIT]

Strange... :o well, the Inventory package is also created by you?
Can you compare both the packages Inventory & Sales and see if there is any gap?

Otherwise, can you create another TEST package ( make sure you have included SQL Server Data Base folder under 'Vendor Specific Functions' option) and publish, then see if all the functions cast,left,extract,etc working?

Thanks
Prit

[markcognos]

Hi,

Yes that'a strange, ill already create test package in Sales and include all function, But it is same error that ill encounter.

By the way in Inventory package,the first time i use it in Report Studio like Sales package,The function is also not working,then after Days and week Repackage the FM Inventory,and  run the report that i customized and create a report using Inventory Package,when i test again the function extract,cast,etc...the function is already work.

Thanks,

[markcognos]

Hi,

Any Idea??

Thanks,

[markcognos]

up

[PRIT AMRIT]

Is everything fine now? If yes, where was the problem?

[markcognos]

Hi,

   I'ts not okey sir,I have always an error in function. I Can't finish my report becouse the function is not working.

Any solutions?Do you test this scenario?The functions works fine for you?

Thanks,

[PRIT AMRIT]

Honestly me too curious to know why the functions shouldn't work.  I don't see a reason, in fact your other package 'Inventory' works fine with the same functions. ::)

May be somebody else will come up with some thoughts?

[markcognos]

up

[markcognos]

Thanks PRIT

[markcognos]

Any One??

[markcognos]

up

[markcognos]

 :'(

[Gijsbert]

did you try using a semicolon instead of the comma in your expression?

[markcognos]

Hi,

I tried the semicolon and It works,Why it is the comma didn't work??

Thanks,