filter report

[wong]

Can anybody teach me how to filter report based on user input in textbox?I'm using vb6.I want to display results from Access database from user with same name.Thanks

[dee-u]

What reporting tool are you using?

[wong]

I use dataenvironment and datareport to create my report.

[dee-u]

You just have to do the filtering on the datasource sql, use a WHERE clause.

[wong]

I tried using a SELECT query but when i run it,there will be error.The error is:The parameter Text1.text has no default value

[wiz....]

What is the sql you are using?

[wong]

Select * from Data where Name=Text1.text

[RobDog888]

Thread Moved

[wes4dbt]

You should setup a parameter in the DataEnvironment, check out the attachment.

You can set the parameter at runtime,

deCropbyuser.Commands("Command1_grouping").Parameters("param1").Value = frmUrange!txtStart
deCropbyuser.Commands("Command1_grouping").Parameters("param2").Value = frmUrange!txtEnd
rptCropbyuser.Show vbModal

[dee-u]

When working with DataReports you may want to have a look at this (http://msdn.microsoft.com/en-us/library/aa733655.aspx) MSDN article that discuss it.