For Reports DATEITEM Lookup - FORMS are Must?

Ravi_ThakkarRavi_Thakkar Member Posts: 392
edited 2010-05-27 in NAV Three Tier
Hello All,

I have customized own Pages of RTC.
I have not Designed the Forms for the same.

Now, I have developed one Report for CLASSIC and RTC with the DataItem which is the SourceTable of Above designed Pages.

Due to unavailability of Form, I am not able to set the LOOKUPFORMID property in the SourceTable of above created Pages.

Due to this property BLANK,

On Running the Reports, Lookup in RequestPage not showing me the Data. While data is present in Table.

So, Do I must have Form for the same and set the LOOKUPFORMID property in Table?
Or any other way to do this?
Ravi_Thakkar
Ahmedabad, Gujarat, India
E Mail : ravi.thakkar@hotmail.com

Comments

  • vijay_gvijay_g Member Posts: 884
    To retreive PK field need to set LookUpFormId and anyother field set tablerelation property.
    lookup by code on the onlookup trigger not suffiicient for this.
  • Ravi_ThakkarRavi_Thakkar Member Posts: 392
    Hello Vijay,

    Thanks for your reply.
    I got your point but, the query is if I run any Report then RequestForm will come first.
    In that, I have ReqFieldFilter (PrimaryKey) "No." of dataitem X.

    X does not have LookupformId property set due to unavailability of Form. (Page is available, but can not be specified in Lookupformid.)

    So, in RequestForm, "No." field lookup is not showing any data.

    Any suggestion?
    Ravi_Thakkar
    Ahmedabad, Gujarat, India
    E Mail : ravi.thakkar@hotmail.com
  • Ravi_ThakkarRavi_Thakkar Member Posts: 392
    Any Suggestion?
    Ravi_Thakkar
    Ahmedabad, Gujarat, India
    E Mail : ravi.thakkar@hotmail.com
Sign In or Register to comment.