January 8, 2008 at 5:44 am
In report builder, when adding a date field for filtering, the report display a NULL tick box next to that field. Is there a way not to display the tick box?
Thanks
Laetitia
January 11, 2008 at 10:24 am
does your field have some null values for that date? then, my guess your report model will have it too :-).
January 11, 2008 at 10:42 am
Thank you for responding. In the database the date field does not allow null but I am not sure for the report model. It is confusing because when ticked it seems to run the report for any date and not a null date.
January 11, 2008 at 10:48 am
sure. hard to say something without seeing your sql but i would run your sql again, order by that date and see if it has nullls. also, it may not have nulls today, but tomorrow, when you rebuild your model with new data, you may have records that does have nulls, right? the best way i think would be to use from 'date1' to 'date2' to get data you are after.
January 15, 2008 at 4:42 am
The only way I know of is to bring the report into bis and change the properties of the parameter in there.
January 15, 2008 at 4:53 am
Thanks. So is it correct that in report builder, I cannot change the way the prompt filters are displayed on the report?
January 15, 2008 at 5:32 am
As far as I know, report builder is a bit limited for end users in many many respects while bis is too scary. If your happy to use bis then this is the best way to go with the report model until 2008 improves things. You can change quite a lot in bis and still have a report that can be edited in report builder, the main things that exclude it from being opened in rb after editing in bis are header/footer and multiple queries.
January 15, 2008 at 5:50 am
Thanks for the info.
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply