I have created the view like this category,year - month,totals of each year-month.I exported this data into Excel.but now i need to export this data according daterange i.e startdate and enddate and according that show in chart.
can anyone guide me?
with hope
thanks alot
Subject: How to create the report in excel
As I said in the last post to your previous question here
If you want a date range you’ll need to sort a view by the relevant date field and add the documents within that range to a notesdocumentcollection, then use that instead of the view to create the excel sheet.
You can use prompts to get the start and end dates.
Subject: How to create the report in excel
Check the FAQ of FAQs and the OLE/COM faq (both available as a link when you make a new post).
Lots of info on how to create Excel files, charts, pivot tables, etc.
TIP: record a macro in Excel and then convert it to work in Notes (check the FAQs for more help).
doug