Symptom
A Crystal report is created with a date prompt. The first prompt is 'StartDate' and the second prompt as 'EndDate'. When the report is published to Enterprise, the report displays 'EndDate' as the first prompt and 'StartDate' as the second prompt.
Cause
This happens because a Command Object and a stored procedure are used to create the Crystal report.
The issue has been identified and tracked under ADAPT00883735.
Resolution
Do not use a Command Object with a stored procedure. Without the Command Object the report behaves correctly with the same prompt order as in the the Crystal report.
Keywords
Prompt order changes , 8974126 , KBA , BI-BIP , Business intelligence platform , Product Enhancement