Yes, you can do the same thing with the BI Publisher’s scheduled report by doing exact the same but setting such parameter values from the scheduler edit window. In order to get the last 7 days of the data in SQL world, typically you set a start date to be ‘sysdate – 7’ and an end date to be ‘sysdate’. You can’t hard-code any date to the date parameter of the report because then the date range will get too old and invalid. For example, you might want to run a report on every Monday to display the data for the last 7 days. This would be even more critical when you want to set the date parameter values for your scheduling report. So if you open the report today the date would be 11/18/09, if you open tomorrow then it would be 11/19/09. Yes, here comes the dynamic date parameter!įor example, you can use a current date function (sysdate()) to set a today’s date for your date parameter so that the date will be set always to today’s date depending on when you open the report. Ok, so don’t you want to set the default date for the date parameter of the report and make it to be a today’s date or a week before or something ? Or, don’t you want to schedule your report and want it to generate always the last 7 days of the data ? This is actually really not known trick maybe it is not documented in the user’s guide yet, but BI Publisher supports a ‘dynamic date parameter’.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |