Support Article
Unable to use Page Group 'StartDate' Properties in Grids
SA-7841
Summary
There is a page structure like below which is generated after running a Report Definition
ListZZ
pxResults(1)
pxPages(XXX)
YYYStartDate -- Date Property
While trying to refer the .YYYStartDate property in Repeating Grid getting compile exception saying that page is not defined.
It happens only while trying to override control defined on the property. If same property is used and given Control as "Inherited from Property" then there is no issue, but default Date displays as 1/1/2000 whereas it is requierd to show to end user as 01 Jan 2000. So, pxDateTime Control is being used to specify custom format.
Error Messages
String value of a cell:
.pxPages(ListZZ).StartDate doesn't exist or is not a valid entry for this ruleset and its prerequisites Java stack traces identify the original exception in the very last Caused By log entry.
Steps to Reproduce
1 - Create a Report Definition to fetch results using Join
2 - Use the result in Repeating Grid by referring the page where results are available
3 - Use any data sub-page (pxPages) in the Repeating grid
4 - Override the default control defined on the property
5 - Save the section
Root Cause
pxDateTime Control is being used to specify custom format.
Resolution
This issue is resolved through the following local change:
Create dummy datetime property.
In the presentation tab of the DateTime property configure the read-only(always) and read-only Value as “Another Property’s value.” and another property as .pxPages(VendorList).StudioStartDateRead-Only Format is Type-Date, Date Format : Custom mmm dd, yyyy
Published January 31, 2016 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.