Create Report Template

[Ruth]

I have a database table listing a number of products stocked in a shop.
I have created queries so that I can print off lists of products in a
certain group, i.e. hardware products, pet products, etc.
I want to create a separate report for each group.
I have created a report for my first group and have got the formatting just
as I want it.
I now want to create reports for the rest of the groups but using the same
format.
How do I either change the query my report is based on or create and use a
template based on my initial report?

 

[Duane Hookom]

You should not create separate queries and/or reports for different sets of
data. There are fairly simple solutions for applying filters by using
parameter prompt queries or opening your report with a where condition.

The simplest method is to add a criteria in your query under the
ProductGroup column like:
[Enter Product Group]
Another method is to add a combo box (cboProductGroup) to your form
(frmSelectCriteria) and in your query under the ProductGroup column use:
Forms!frmSelectCriteria!cboProductGroup

Duane Hookom
MS Access MVP

 

[Ruth]

Thanks for your reply. Ok I see your point, but what I want to do is make
report retrieval as simple as possible by just going into each report and
clicking print.
If I set up parameters I'm going to have to look up codes to enter for each
group to get the information I require whereas if I have a separate report
for each group I don't have to worry about codes as they have already been
specified.
I may yet have to set up parameters if the other way is not possible.

You should not create separate queries and/or reports for different sets of
data. There are fairly simple solutions for applying filters by using
parameter prompt queries or opening your report with a where condition.

The simplest method is to add a criteria in your query under the
ProductGroup column like:
[Enter Product Group]
Another method is to add a combo box (cboProductGroup) to your form
(frmSelectCriteria) and in your query under the ProductGroup column use:
Forms!frmSelectCriteria!cboProductGroup

Duane Hookom
MS Access MVP

--
Microsoft Access MVP

I have a database table listing a number of products stocked in a shop.
I have created queries so that I can print off lists of products in a
certain group, i.e. hardware products, pet products, etc.
I want to create a separate report for each group.
I have created a report for my first group and have got the formatting just
as I want it.
I now want to create reports for the rest of the groups but using the same
format.
How do I either change the query my report is based on or create and use a
template based on my initial report?

 

[Duane Hookom]

Users should never be exposed to your database window. It is so much easier
to create a combo box to select your criteria and then just click a button to
open the report. You should not be forced to create and maintain multiple
similar tables.

--
Duane Hookom
Microsoft Access MVP

Thanks for your reply. Ok I see your point, but what I want to do is make
report retrieval as simple as possible by just going into each report and
clicking print.
If I set up parameters I'm going to have to look up codes to enter for each
group to get the information I require whereas if I have a separate report
for each group I don't have to worry about codes as they have already been
specified.
I may yet have to set up parameters if the other way is not possible.

You should not create separate queries and/or reports for different sets of
data. There are fairly simple solutions for applying filters by using
parameter prompt queries or opening your report with a where condition.

The simplest method is to add a criteria in your query under the
ProductGroup column like:
[Enter Product Group]
Another method is to add a combo box (cboProductGroup) to your form
(frmSelectCriteria) and in your query under the ProductGroup column use:
Forms!frmSelectCriteria!cboProductGroup

Duane Hookom
MS Access MVP

--
Microsoft Access MVP

I have a database table listing a number of products stocked in a shop.
I have created queries so that I can print off lists of products in a
certain group, i.e. hardware products, pet products, etc.
I want to create a separate report for each group.
I have created a report for my first group and have got the formatting just
as I want it.
I now want to create reports for the rest of the groups but using the same
format.
How do I either change the query my report is based on or create and use a
template based on my initial report?

 

[Ruth]

What if I want each report to have a different heading, e.g. Hardware
Pricelist, Horse Supplies Pricelist etc?

Users should never be exposed to your database window. It is so much easier
to create a combo box to select your criteria and then just click a button to
open the report. You should not be forced to create and maintain multiple
similar tables.

--
Duane Hookom
Microsoft Access MVP

Thanks for your reply. Ok I see your point, but what I want to do is make
report retrieval as simple as possible by just going into each report and
clicking print.
If I set up parameters I'm going to have to look up codes to enter for each
group to get the information I require whereas if I have a separate report
for each group I don't have to worry about codes as they have already been
specified.
I may yet have to set up parameters if the other way is not possible.

You should not create separate queries and/or reports for different sets of
data. There are fairly simple solutions for applying filters by using
parameter prompt queries or opening your report with a where condition.

The simplest method is to add a criteria in your query under the
ProductGroup column like:
[Enter Product Group]
Another method is to add a combo box (cboProductGroup) to your form
(frmSelectCriteria) and in your query under the ProductGroup column use:
Forms!frmSelectCriteria!cboProductGroup

Duane Hookom
MS Access MVP

--
Microsoft Access MVP


:

I have a database table listing a number of products stocked in a shop.
I have created queries so that I can print off lists of products in a
certain group, i.e. hardware products, pet products, etc.
I want to create a separate report for each group.
I have created a report for my first group and have got the formatting just
as I want it.
I now want to create reports for the rest of the groups but using the same
format.
How do I either change the query my report is based on or create and use a
template based on my initial report?

 

[Duane Hookom]

Isn't "Hardware" and "Horse Supplies" somewhere in your report's data or
somewhere? Access is a data driven type application. Use the data.

--
Duane Hookom
Microsoft Access MVP

What if I want each report to have a different heading, e.g. Hardware
Pricelist, Horse Supplies Pricelist etc?

Users should never be exposed to your database window. It is so much easier
to create a combo box to select your criteria and then just click a button to
open the report. You should not be forced to create and maintain multiple
similar tables.

--
Duane Hookom
Microsoft Access MVP

Thanks for your reply. Ok I see your point, but what I want to do is make
report retrieval as simple as possible by just going into each report and
clicking print.
If I set up parameters I'm going to have to look up codes to enter for each
group to get the information I require whereas if I have a separate report
for each group I don't have to worry about codes as they have already been
specified.
I may yet have to set up parameters if the other way is not possible.

:

You should not create separate queries and/or reports for different sets of
data. There are fairly simple solutions for applying filters by using
parameter prompt queries or opening your report with a where condition.

The simplest method is to add a criteria in your query under the
ProductGroup column like:
[Enter Product Group]
Another method is to add a combo box (cboProductGroup) to your form
(frmSelectCriteria) and in your query under the ProductGroup column use:
Forms!frmSelectCriteria!cboProductGroup

Duane Hookom
MS Access MVP

--
Microsoft Access MVP


:

I have a database table listing a number of products stocked in a shop.
I have created queries so that I can print off lists of products in a
certain group, i.e. hardware products, pet products, etc.
I want to create a separate report for each group.
I have created a report for my first group and have got the formatting just
as I want it.
I now want to create reports for the rest of the groups but using the same
format.
How do I either change the query my report is based on or create and use a
template based on my initial report?

 

[Ruth]

No the product group headings are not in the report data. The only way to
distinguish where each product is grouped is by its code, e.g. 3000 - 3999 is
Horse Supplies. Are you saying I need another column in my table to state
which group each product is in? Or can I tell access that if a product has,
say a code of 3001 it falls into Horse Supplies? It sounds like this could
get complicated and I wanted to keep it as simple as possible. Any ideas?

Isn't "Hardware" and "Horse Supplies" somewhere in your report's data or
somewhere? Access is a data driven type application. Use the data.

--
Duane Hookom
Microsoft Access MVP

What if I want each report to have a different heading, e.g. Hardware
Pricelist, Horse Supplies Pricelist etc?

Users should never be exposed to your database window. It is so much easier
to create a combo box to select your criteria and then just click a button to
open the report. You should not be forced to create and maintain multiple
similar tables.

--
Duane Hookom
Microsoft Access MVP


:

Thanks for your reply. Ok I see your point, but what I want to do is make
report retrieval as simple as possible by just going into each report and
clicking print.
If I set up parameters I'm going to have to look up codes to enter for each
group to get the information I require whereas if I have a separate report
for each group I don't have to worry about codes as they have already been
specified.
I may yet have to set up parameters if the other way is not possible.

:

You should not create separate queries and/or reports for different sets of
data. There are fairly simple solutions for applying filters by using
parameter prompt queries or opening your report with a where condition.

The simplest method is to add a criteria in your query under the
ProductGroup column like:
[Enter Product Group]
Another method is to add a combo box (cboProductGroup) to your form
(frmSelectCriteria) and in your query under the ProductGroup column use:
Forms!frmSelectCriteria!cboProductGroup

Duane Hookom
MS Access MVP

--
Microsoft Access MVP


:

I have a database table listing a number of products stocked in a shop.
I have created queries so that I can print off lists of products in a
certain group, i.e. hardware products, pet products, etc.
I want to create a separate report for each group.
I have created a report for my first group and have got the formatting just
as I want it.
I now want to create reports for the rest of the groups but using the same
format.
How do I either change the query my report is based on or create and use a
template based on my initial report?

 

[Duane Hookom]

Creating and maintaining multiple similar queries and reports is complicated
and a mess. If you have relationships/groupings of values in tables, store
the information. I would probably create a product group field like the
product category in the Northwind Products table. You can then more easily
create queries based on data values.

--
Duane Hookom
Microsoft Access MVP

No the product group headings are not in the report data. The only way to
distinguish where each product is grouped is by its code, e.g. 3000 - 3999 is
Horse Supplies. Are you saying I need another column in my table to state
which group each product is in? Or can I tell access that if a product has,
say a code of 3001 it falls into Horse Supplies? It sounds like this could
get complicated and I wanted to keep it as simple as possible. Any ideas?

Isn't "Hardware" and "Horse Supplies" somewhere in your report's data or
somewhere? Access is a data driven type application. Use the data.

--
Duane Hookom
Microsoft Access MVP

What if I want each report to have a different heading, e.g. Hardware
Pricelist, Horse Supplies Pricelist etc?

:

Users should never be exposed to your database window. It is so much easier
to create a combo box to select your criteria and then just click a button to
open the report. You should not be forced to create and maintain multiple
similar tables.

--
Duane Hookom
Microsoft Access MVP


:

Thanks for your reply. Ok I see your point, but what I want to do is make
report retrieval as simple as possible by just going into each report and
clicking print.
If I set up parameters I'm going to have to look up codes to enter for each
group to get the information I require whereas if I have a separate report
for each group I don't have to worry about codes as they have already been
specified.
I may yet have to set up parameters if the other way is not possible.

:

You should not create separate queries and/or reports for different sets of
data. There are fairly simple solutions for applying filters by using
parameter prompt queries or opening your report with a where condition.

The simplest method is to add a criteria in your query under the
ProductGroup column like:
[Enter Product Group]
Another method is to add a combo box (cboProductGroup) to your form
(frmSelectCriteria) and in your query under the ProductGroup column use:
Forms!frmSelectCriteria!cboProductGroup

Duane Hookom
MS Access MVP

--
Microsoft Access MVP


:

I have a database table listing a number of products stocked in a shop.
I have created queries so that I can print off lists of products in a
certain group, i.e. hardware products, pet products, etc.
I want to create a separate report for each group.
I have created a report for my first group and have got the formatting just
as I want it.
I now want to create reports for the rest of the groups but using the same
format.
How do I either change the query my report is based on or create and use a
template based on my initial report?