Setting Report Filter

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have created a report (with several subreports) for my database that give
me all the data I want in the format that I want. I have it set up so that
the report does seperate the data for each item and page breaks between them.

However, to print the data for a single item, the user has to use print
preview and search (lengthy search through lots of items) for the item they
want and print just those pages. What I would like to do now is to get the
report to ask for a specific item to report on and filter it out. How do I do
this?

I have done some searching on this, but all the results I have found use
forms to do some of the work. I have no forms made. Do I need to make/use one?
 
I have created a report (with several subreports) for my database that
give me all the data I want in the format that I want. I have it set
up so that the report does seperate the data for each item and page
breaks between them.

However, to print the data for a single item, the user has to use
print preview and search (lengthy search through lots of items) for
the item they want and print just those pages. What I would like to do
now is to get the report to ask for a specific item to report on and
filter it out. How do I do this?

I have done some searching on this, but all the results I have found
use forms to do some of the work. I have no forms made. Do I need to
make/use one?

Put the following criterium in your main query at your field "[item]":

Like "*" & [Question?] & "*"

When opening the report, a box will pop-up asking for the name of the
item. The way the criterium is defined, part of the name will suffice.
 
o.k. I'm frustrated! I have a report that has 8 subreports - each
sub-report is based on the same query. When I enter parameters, and then open
the report, I have to answer the same two questions 18 times before the all
sub-reports appear. If I enter one incorrectly, a sub-report does not appear.
There has to be a better way!

Thanks!

dawn
 
Dawn, if you want the subqueries to read the same parameter, then use Method
2 from the linked article.

It explains how you can enter the values once on a form, and have the
queries read the value from there.
 
This works great if you have numeric or date values. My value is ABC/06
(with or w/out the slash) - there are no options available for text choices.
Any other solutions?
 
Dawn, you will have to enlighten me as to what is the problem with having
the query read a text value from a text box on a form.
 
I went through help originally, and created the a form, with text boxes for
my query information. The first field I have is the ABC/06. When I right
click, properties, format, my options are date formats, general numbers,
euro, scientific, yes/no; true/false and on/of. Unless I missed something
somewhere, these are the only formats that are available for text boxes.
 
Okay, so you do not need to apply special formatting to a text field.

That should not stop the query from reading it though.
 
Back
Top