Difference w/prompt in Full client and WebI

building reports webintelligence legacy 1/2
1

I have a full client report that uses a prompt. The full client version of the report prompts with the date. Then there are two more columns next to the date and it sorts the data by the last column. This works perfectly in Full client. Now I have put this report in WebI. The prompt only shows the date in the prompt and not the other two columns. It is not even sorting the columns properly. Does anyone know why there is a difference? Here’s the code I am using for my prompt MTS.MTS_FTE.PAY_PERIOD_END = @Prompt(‘Please select an Ending Pay Period Date’,‘D’,‘FTE_Proj\Pay Period Ends’,mono,constrained)

Any ideas on how to fix the issue of it not sorting properly and not show the other two columns?

Thanks in advance
Lori

bachman :us: (BOB member since 2002-09-24)

2

Lori, did you export the LOV with the universe? If not, then it might just be on your workstation, and not on the WebI Server.

Anita Craig :us: (BOB member since 2002-06-17)

3

Thanks Anita that worked! However in WebI there aren’t any label headings on the fields of the prompt to tell which fields are which. Is there any way to make the heading labels appear like in full client??

Thanks
Lori

bachman :us: (BOB member since 2002-09-24)