problem with data report +Pl.help

[hrishi111]

Dear Friends,

I am facing a deep trouble at the end of a road. In a Hotel Management software one report is not working instead showing some unusual errors.
I have explained here the whole thing.

I have used MSACCESS as back end database. In the database there is table usage wherein users logged in time in the software is noted.The structure is as such.

User Id: Text field
Date: Date
Entrytime: Date/Time
Exittime: Date/Time

Using this table i need to produce a report showing user id and entry,exit time group by date that is selected by the user on his choice. That is each user will select dates from a Calendar Control and then click a button to show it.

Now using DataEnvironment i have designed the data source, but the problem how will input the criteria for the date to the DataEnvironment at run time.

I have selected the table then group it under the group tab as date. I am just wondering how to select the date but then there's no idea flowing till now.

Pl. help. Your effort will always be highly regarded as this is my first commercial project and i need to deliver it in time. I will also appreciate if anyone cities me some important tutorials on Data Environment ( I have cheked down MSDN's but couldn't find anything interesting).

Regards to you all,

Hrishikesh

[Nrapendra Singh]

u can not set any query at run time to the dataenvironment because it is always binded with the table and always get the data which is only in the table.but u can chose another otion for that...

get a new table and store the query result in that table runtime.
and bind that table to ur data enviroment.

what will hapen is that when u put a query its results will be stored in the table and when u run the dat report it will take the result from the table..

[hrishi111]

Ok, that fine but then if i use a sql query to retreive data and then display it using the following source,

set datareportname.datasource=recordsetname
datareportname.show

will it be done. Can you pl. guide me the sql query in this case. I tried but then failed miserably..

Hrishikesh
India

[hrishi111]

one more thing, can i use a view and then bind it to the data environment. But in this case then how will i take the input from the form's control for specifing the criteria.

regards,
hrishikesh