Hi ,
I need to create " Dynamic date " in my report using data item object .( Assume that we doesn't have Date query item in the database). i.e., When i run the data item its output should display the dates starting from "JAN-1-2013 " to "DEC- 31-2013" . How can i achieve this ,please suggest me . Thanks in advance.
hi,
we need further information in what environment you want to achieve this.
- dmr or pure relational data structures/modell?
- what db?
- do you have a time dimension, and how detailed is it? entrys on daily basis or week/ month?!
br
charon
Hi,
I'm not clear on what you're asking for here. If you don't have any dates in your underlying data, how can anything in your report relate to dates? Do you just want a list of dates with nothing else in the report?
Generating these kinds of dates is quite easy in Excel. You could perhaps do this then bring in the saved xls as an external data source for your report?
MF.
create a table with 1 column and 365 rows. then write a sql statement that will join to that table and do a running count while adding 1 to 20130101 and use a function to convert that to date. you might need to do some complex sql joins to achieve this...
or you can just create a time dimension table