I have date column.So i set "DayName" column properties sort column order i selected "date" column.Now if i create pompt it repeated multiple times like Sun,Mon,Tue,Wed,Thu,Fri,Sat Again Sun,Mon,Tue,Wed,Thu,Fri,Sat............................
I trying to put distinct but it return error.How to avoid multiple entry.Is there any other way solution
I created Logical column dayName(date) and DayOfweek(Date).In DAYNAME column properties i set order by DAYOFWEEK.
After i selected new sample report selected DAYNAME then values displaying correct Sun,Mon,Tue....Sat. But same column i selected prompt.In prompt shows multiple values again.
Thanks for your reply veera.