Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI,
I have a table and it has date as YYYY-MM-DD.I'm using calendar thing too.
but in every month i need to add additional records to that table. So i have only month and year.
generally in month data i'm adding summary records.
Can anyone tell me how to handle this problem.
Thank you
Hi Anuradha,
Since you have master calender, link the date field with the master calender date by renaming.
If ur facing issue please upload the app
Not understood completely from your description.. Can you elaborate little more with an example or sample...
Hi Anuradha,
Can u please elaborate.I didn't understand u r problem.
Here i have data for sales
CUSTOMER | RDATE_TIME | Sales |
A | 1/2/2005 | 20,578 |
B | 2/2/2005 | 20,373 |
C | 3/2/2005 | 22,381 |
D | 4/2/2005 | 21,042 |
So i get these data from data base. Then i have use a calender and have Year,Month, Day list boxes. To view data based on selection.
Here i have use drill down group year,month,day.
suddenly i get monthly data from one Customer. I need to add them to this report. Then i have put that data in excel and join it with my existing table. the problem i have is i don't have date for my summary data.
I can use date in that month, but then all moth data display under that date. Is there a way to solve this.
Thanks