XL Reporter Parameter

[Former Member]

Hi Experts,

i download a XL Report "Dashboard-Profit Loss Statement" from SAP Portal. when i run this report it ask for Enter Parameter "Period". its o.k for me but i need to add another parameter Division name and i add this parameter also in Advanced Report Builder using Parameter option.

When i run this report it ask for me Period and Divison as parameter but the problem is for every division that i selected value comes same as Period.Its having no effect of Divisions..every time values comes same.

Let me know Is i am doing any mistake or there is any other way to do this.

Regards,

philip

[former_member186095]

Hello,

When you create the new parameter by clicking parameter, could you tell what type you use in the new parameter ? is it profit center ?

Rgds,

[former_member186095]

In addition to my previous answer, after creating new parameter, e.g .division, do not forget to click periodic report button, click tab column in advance report builder (ARB), put cursor on the #Value cell, fill the selection based on defined dimension in the ARB where it will prompt the parameter you have created in the dimension lookup and then define selection value. have you done that ?

What will be your P&L division ? The division could be based on fields in the account detail

or anything else, if you agree, describe here.

Rgds,

[Former Member]

thanks jimmy..its working now.

[Former Member]

Hi Jimmy,

Can we change the description of the header for period? Can we have Sep 07 instead of 2007 09??

Phil

[former_member186095]

Hello Philip,

I suggest to simulate the field date format in the tab display of general settings. You could find the general setting in the module administration. let me know if it can't work.

Rgds,

[Former Member]

Hi Jimmy,

Its not working and if i changed date over there then it will Effect all documents..

Let me know any other Alternative so that it will efffect on XL Report only.

Regards,

philip

[former_member186095]

Hello Philip,

I am afraid you could not do that but I am unable to replicate here yet, if you are in a hurry, I have pdf file relate to it. Let me know your e-mail address or mail me anthoni76@yahoo.com.

Rgds,

[Former Member]

Hi Jimmy

pls send it to my I.d : pankaj.srma@yahoo.com

Thanks