Report problem

HCL Domino Domino Forum
1

Hi everybody ,

I had a application that captures visitors visiting date here the requirement i have designed a form with two fields startdate and enddate both are date/time fields when ever user needs a report he will enter his desired startdate and enddate the report of the documents between two dates should generate in excel sheet here the problem is how should i pass the key, i have no problem with excel sheet coding, i used

keys(0)=doc.stdate(0)

keys(1)=doc.eddate(0)

set dc=vw.getalldocumentsbykey(keys)

but i am not getting the document collection

can any body tell me the logic are send me the code to get the collection handle that will be great

thanks

2

Subject: This will only work if the view’s first column is sorted by start date and the second column by end date

The retrieval will find only those documents which start on the specified start date and which end on the specified end date.

HTH

Mark

3

Subject: RE: This will only work if the view’s first column is sorted by start date and the second column by end date

Thanks mark,

so how can i get the document collection handle of those documents

scenario: startdate=05/01/2007(mm/dd/yy)

            Enddate=05/20/2007(mm/dd/yy)

here the report should generate all the dates between startdate and enddate

here the search should start from 05/01/2007(startdate) and end the search at 05/20/2007(enddate) can u send me the logic or code for this scenario Mark

4

Subject: Try something like this

Set notesDocumentCollection = notesDatabase.Search( formula$, Nothing, 0 )where formula$ is “StartDate>=[05/01/2007] & EndDate<=[05/20/2007]”

That way you are searching the database rather than the view so you may need extra criteria in your formula to restrict you to just the documents in the view?

HTH

Mark

5

Subject: RE: Try something like this

Thanks Mark