no data to fetch error

building reports desktopintelligence
1

hi all,
i have a deski report.which i am creating using free habd sql.now when i test my sql in toad and teradata it gives me the output but ,when i use the same in BO it gives me message that no data to fetch.so what’s the issue?
can anyone help?

Biku724 (BOB member since 2008-07-29)

2

got the output.the thing was when using financial data dealing with date we need to use full year e.g. mm-dd-yyyy.

Biku724 (BOB member since 2008-07-29)

3

Hi,

The problem might be the input which you gave in the wrong format or wrong value.IF it is a date then give a existing value/format by checking in database.

Cheers,
Suresh Aluri.

sureshbabualuri :india: (BOB member since 2008-03-26)