Single date prompt, 5 queries

[coghost]

i require a report where the user selects a a date from a single prompt, and this selected date should be applied on 5 queries present in my report, where all the date cols are from different facts.

i have created a date prompt ( ie created a parameter)which is not associated with any query. then i placed a filter on the date cols of all my 5 queries using the created parameter. but i am getting error. need sol ASAP  :(

[blom0344]

What's the error? Are you sure that you are matching a date to only date type columns in your queries?

[coghost]

yes i all the date cols are of datatype DATE ! :(

[almeids]

So what's the error?

[coghost]

the result is ...when the report is gettign displayed, no dat is coming at all.only the headers are being shown !

[blom0344]

Which may be the result of wrong filters / joins etc. In the stricted sense your report runs without an error, only no data is fetched. Does it return data if you supply a hardcoded value instead of using a prompt?

[Suraj]

Try casting the date columns to date type.