Hi
I am working on some reporting database, where OLTP data will be replicated. OLTP has some transactions and the date when they will be created. Date will be there if there is a transaction on that day .
In my report, i need to display the count of transactions for each day.
How can i get sequence of dates ? is there any way in the designer that i can get sequence of dates ? (my object can point to date column in a table but they are not sequential)
Autofill works quite nicely. Type the earliest date in a cell and format as desired. Grab the autofill handle on that cell (little block on the lower right) and drag down as far as needed. The dates will automatically increment by 1 day.