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 :(
What's the error? Are you sure that you are matching a date to only date type columns in your queries?
yes i all the date cols are of datatype DATE ! :(
So what's the error?
the result is ...when the report is gettign displayed, no dat is coming at all.only the headers are being shown !
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?
Try casting the date columns to date type.