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)

2

Hi,

The first issue I see in the SQL is <= ALL.
What does <= ALL mean? Greater than or Equal to ALL? How is that possible?
:hb:

M H Mohammed :us: (BOB member since 2010-06-16)

3

Hello Mohammed Hussain,

What do you suggest for it? Could you please correct the query?

Thanks
SH

SH3230 (BOB member since 2010-10-25)