For Reports DATEITEM Lookup - FORMS are Must?
Ravi_Thakkar
Member Posts: 392
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?
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?
0
Comments
-
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.0 -
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?0 -
Categories
- All Categories
- 75 General
- 75 Announcements
- 66.7K Microsoft Dynamics NAV
- 18.8K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 610 NAV Courses, Exams & Certification
- 1.9K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 251 Dynamics CRM
- 103 Dynamics GP
- 6 Dynamics SL
- 1.5K Other
- 991 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 28 Design Patterns (General & Best Practices)
- Architectural Patterns
- 9 Design Patterns
- 4 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1K General Chat
- 1.6K Website
- 77 Testing
- 1.2K Download section
- 23 How Tos section
- 249 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions