Crystal Report 8.5 Data Selection Problem?

[Plucky]

hi there,

While i'm using CR 8.5 and VB6 with Access 2000 i want to give option to user to select view or print data through Crystal Report in range.. Forexample View Data FROM (01-01-2005) TO (31-01-2005)...

Please tell me the selection method in detail i don't know how to fix it..
thanx in advance

[RobDog888]

You can use the Crystal Report Viewer control to give the user a print preview type of display. also, you can use the .PrintOut method to dirextly print it.

I have a couple of CR/VB6 examples in my signature.

[Plucky]

RobDog888, Thank you very much for your attention. But i'm sorry you could not understood what i want to say. My users are already viewing the reports those i have designed in Crystal Report 8.5. Those are working fine. Users are viewing and taking print out nicely. But i want to give to view data by selecting between 2 dates. Like Data of Cement Paking Plant if user want to see how much bags packed in the dates FROM 01-03-2006 TO 31-03-2006. I want to give this option to users. Because user is entering data by date in Database.

Please understand..

[RobDog888]

How as your setting the .DataSource of the rport then? ADO recordset?

[Plucky]

i'm using ADODC1 to connect database with my program.

[RobDog888]

You should be using pure ADO to code it as once you learn it its allot easier to implement and you also gain more control and have less issues.

I havent used the ADODC data control since 1995 or so but I do believe if you set a new recordsource of a sql statement that passes the start date and end date it should work.

[Plucky]

how about ADODB, if you think positive about it, please let me know how to connect a database using ADODB?

Thanx in advance

[RobDog888]

Check this tutorial - http://www.vbforums.com/showthread.php?t=337051

[Plucky]

didn't get from there.. plz help