Using queries to pull up reports...

[neosam]

Hey,

Have been working on a project which requires a report to be pulled when a query is run. Pulling the report is something i have done, but if i have to filter the reports to pull up only certain data is something which i havent been able to master. Is that possible. To filter data in a report something like we do in a excel sheet??

[RuralGuy]

The WhereCondition argument of the OpenReport command simply applies a filter to the report. That sounds like the answer you were looking for but I'm not sure.

[neosam]

The WhereCondition argument of the OpenReport command simply applies a filter to the report. That sounds like the answer you were looking for but I'm not sure.

Hey, could you let me know how do you declare a where condition. is it like a seperate function?

[JKing]

Hey, could you let me know how do you declare a where condition. is it like a seperate function?

Hey there,

The OpenReport command like many other commands has several parameters or arguments that you can use to change how the report acts when opened. If you don't specify all the parameters the default settings are used.

Here is what all the arguments are:

OpenReport(ReportName, View, FilterName, WhereCondition, WindowMode, OpenArgs)

The only required argument is a report name. You can leave an optional argument blank in the middle of the syntax, but you must include the argument's comma. If you leave one or more trailing arguments blank, don't use a comma following the last argument you specify.

In your case I think you only want to use the report name and the where condition. This would look something like the following:

DoCmd.OpenReport "myReport", , , "ID = 'ABC1' "
 

myReport would be the name of the report you want to open and ID is a field you want to be filtered to show only ABC1.

If you need help forming your where condition to your specific case feel free to ask and provide some information as to what fields you need filtered and their data type.

Good luck,
Jking

[neosam]

Hey there,

The OpenReport command like many other commands has several parameters or arguments that you can use to change how the report acts when opened. If you don't specify all the parameters the default settings are used.

Here is what all the arguments are:

OpenReport(ReportName, View, FilterName, WhereCondition, WindowMode, OpenArgs)

The only required argument is a report name. You can leave an optional argument blank in the middle of the syntax, but you must include the argument's comma. If you leave one or more trailing arguments blank, don't use a comma following the last argument you specify.

In your case I think you only want to use the report name and the where condition. This would look something like the following:

DoCmd.OpenReport "myReport", , , "ID = 'ABC1' "
 

myReport would be the name of the report you want to open and ID is a field you want to be filtered to show only ABC1.

If you need help forming your where condition to your specific case feel free to ask and provide some information as to what fields you need filtered and their data type.

Good luck,
Jking

Hi Jking,

This works but it does not open the report in a .xls format, but in a .mdi format.
The code i have used is

DoCmd.OpenReport "myReport", , , "Date = TxtBox "
 

where TxtBox is a text box where user needs to type a date. When i do this application automatically opens a "Save As" Dialog box, but there is no .xls option.

[JKing]

Hi Jking,

This works but it does not open the report in a .xls format, but in a .mdi format.
The code i have used is

DoCmd.OpenReport "myReport", , , "Date = TxtBox "
 

where TxtBox is a text box where user needs to type a date. When i do this application automatically opens a "Save As" Dialog box, but there is no .xls option.

Sorry, I think you also need to add the view argument. You probably want acViewPreview.

If you want to use a control in the where clause you would need to break it out of the quotes and reference it properly.

DoCmd.OpenReport "myReport, acViewPreview , ,"Date = #" & Me.TxtBox & "#"
 

[neosam]

Sorry, I think you also need to add the view argument. You probably want acViewPreview.

If you want to use a control in the where clause you would need to break it out of the quotes and reference it properly.

DoCmd.OpenReport "myReport, acViewPreview , ,"Date = #" & Me.TxtBox & "#"
 

Hi Jking,

Thanks a lot... it works...