Hi all,
A crystal report developed using a BW query with parameter prompts, has been updated so that the parameters are dynamic instead of static. Upon refreshing in Crystal reports, you are prompted by the parameters to enter restrictions which then queries the data provider and returns values for the relevant Dynamic prompts. This works as expected.
Once the report is saved/published and accessed through InfoView. Either view or schedule the report, the prompts that are displayed do not have any data available for selection. The picklist prompt box displays with 'No Matching Entries'
.
Any of the static parameters do have data available to select.