Selecting a Field on Opening the documnet

[#1]

Hi All,

I want to set a field on opening of the document.

The field is not a filter,

How can i do it.

I tried to do it with the help of trigger, but it is not happening.

Thanking in advance.

[MK_QSL]

It should work by creating a trigger for Document Properties in Field Even Trigger.

Can you provide sample data file?

[PrashantSangle]

Hi,

Go to Sheet Property->Triggers->OnActivateSheet->Add Actions->Add->Action Type(Selection)->Select in Field->Ok.

Then in Field column ->write field name.

Search Field->write field which you want to select on open.

Regards,

[#4]

Hi all,

Actually I want to use the value of the function QVUser() for filter criteria.

but it is not happening currently.

[#5]

hi

go to-

menu bar--> setting-->document properties  --> Triggers--> Document open trigger--> select on open then clik on add action--> Add --> selection, choose select in field --> then write field name and its value

hope this helps you.

[#6]

Hi all,

Actually I want to use the value of the function QVUser() for filter criteria.

but it is not happening currently.

[#7]

Actually the QVuser() is returning 'Undefined',

so i am not able to user this function to get to know the name of the cal, which is currently accessing the file.

[ashfaq_haseeb]

Hi use osuer() instead of qvuser().

Regards

ASHFAQ

[#9]

Hi Ashfaq,

Thanks for your reply.

I want 1 clarification.

When we access a report through Web-browser, we have to give some username and password.

As per my knowledge, it is the CAL which is we need to provide.

I want to know, how can I get this CAL(If above thing is right)

or is there anything else,I need to do in server side configuration.

thanks in advance.

[ashfaq_haseeb]

Hi,

It really depends on type of authentication or authorization you use.

In order to open any document via web you need a licence either document cal or named cal.

for more details, Please go through the attached fie.

Regards

ASHFAQ