report issue

building reports webintelligence
1

Hello All,

I have report which use merege dimension and sub query in the firlter. When I run my report its says that there is no data in the query all the query.I ran for diffrent period and with different districts. In some time period returns data for all 4 queries,some time period returns data for 2 queries and some time period does not return data.

sub query is as below

AND
ABC.CL_WEEK_ENDING_DATE > ALL
(
SELECT
ABC.CL_WEEK_ENDING_DATE
FROM
ABC
WHERE
trunc(ABC.CL_WEEK_ENDING_DATE+1) = @prompt(‘Enter Saturday:’,‘D’,‘ABC\Saturday’,Mono,Free,Persistent,User:0)
)
AND
ABC.CL_WEEK_ENDING_DATE <= ALL
(
SELECT
ABC.CL_WEEK_ENDING_DATE + 7
FROM
ABC
WHERE
trunc(ABC.CL_WEEK_ENDING_DATE+1) = @prompt(‘Enter Saturday:’,‘D’,‘ABC\Saturday’,Mono,Free,Persistent,User:0)
)
Need advise.

Thanks SH

SH3230 (BOB member since 2010-10-25)