How to define a Employee field can use Relative select on Report.

[former_member200889]

Hi experts,

I found that some field on Reports, I can use the relative value of the select.

So I just defie a report that everyone has emerged own data.

Currently, I define Employee Field use

element CreateBy:EmployeeID;

association ToEmployee to Employee;

element CreateOn:Date;

But it looks like the way to define, there is no way relative select.

If the custom data field, I can use relative select. (An example is shown below)

Currently, there are ways to achieve this needs?

Best regards,

Daniel

[Former Member]

Hello Daniel,

What is your exact requirement? Based on that we can suggest some alternative.

Regards,

Saurabh

[former_member200889]

Hi Saurabh,

I want to define a Employee Field can use relatiive select on my Custom BO, similar Standard Report's Employee Responsible

I can use Relative Select Values "Employee - My User Name" or "My Teams".....

Currently, I use EmplyeeID datatype to define my employee field.

But it dose not have relative select feature.

I hope you can understand my requirement.

Thank you.

Best regards,

Daniel

[former_member186648]

Hi Daniel,

Have you used datatype of your Employee as "EmployeeID"?

Thanks, Pradeep.

[former_member200889]

Hi Pradeep,

I define my Employee field code:

I Define my Report: SaleID - Using Variable

SaleID select values NO relative

How to do implementation my requirments?

Best regards,

Daniel

[Former Member]

Hello Daniel,

Did you set "Selection type" to "Any Selection"?, this is the mandaory step for relative select.

Please check the screenshot below.

Let me know.

Regards,

Saurabh

[former_member200889]

Hi Saurabh,

Yes, I set my selection type is "Any selection"

But still no relative select

Is there needs to special attention settings?

Best regards,

Daniel

[Former Member]

Hello Daniel,

There are only 2 prerequisites:

1. Data type- which should be EmployeeID

2. Selection type - Any selection.

Well, I would suggest you to raise an incident if it does not work eve after all those settings.

Regards,

Saurabh

[former_member200889]

Hi Saurabh,

This is a prerequisites for the above two points I have processed.

Thanks for your suggestion.

I will raise an incident, hoping to slove this question.

Thanks.

Best regards,

Daniel.

[former_member186648]

Hi Daniel,

Relative select appears automatically based on the datatype of the field used, example if it is date field then data related entries are shown.

You cannot add new entry into Relative, it is predefined.

Thanks, Pradeep.

[former_member200889]

Hi Pradeep,

Date type field I can use relative select.

Is there a predefined field are Employee type can use relative select?

Best regards,

Daniel