 | |
Re: Access reports question
comp.database.ms-access comp.database.ms-access
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
Re: Access reports question -
04-01-2004
, 08:39 AM
|
"prowsy" <rob (AT) jasperjones (DOT) co.uk> wrote I am having a problem copying a report within an access database. Im using Access2002 and have used the database wizard to create the "order entry" database and have tweaked a few of the names and fields to suit my needs. The whole thing works perfectly except for the reports. The Invoice report that was generated by the wizard works perfectly but I want to duplicate it to create a delivery note as all the fields are the same except I want to title it differently. I have tried to copy and paste the report When you copy and paste the Report, you are pasting the Report Object repleat with all the settings for properties of the original, which in your case the Record Source property of your new report is the same as the original. You will need to open the Report in the Designer, Open the property page for the Report and then on the Data Tab, press the Down Arrow for the Record Source property to invoke the Query builder to set the specification for that report. and then attach it by a button to the orders screen next to the invoice but when I run it it picks up every single order for every client and not the one order. This is my first database with access and I cant get my head around writing a new report, can anyone help????? Rob |
#2
| |||
| |||
|
|
Im still baffled!!! Why doesnt the report work in exactly the same way when I copy it if I am copying all of the properties as well - surely it should do exactly the same if I am not changing anything? All of the specifications are the same when I copy them arent they? |
why everything from the other report is being generated in the new one.
Example:
1. Open the Northwind Database (NWind.mdb) which was installed as samples on your computer.
2. Copy the "Customer Labels" Report to a new Report, say "New Customer Label"
3. Open the "New Customer Label" report in the Designer.
4. Press F4 to invoke the Property Page for the Report.
5. Select the "Data" tab of the Property Sheet.
6. On the "Filter" line enter: [Customers]![CustomerID]="CONSH"
7. On the "Filter On" Line, Change the Value to "Yes".
8. Save the Report.
9. Preview the Report and you will see only one label for "Consolidate Holdings" which is the result of
the "Record Source" that is set to "Customers" being restricted or "Filtered" by the "CustomerID" being
set to a particular setting, in this case "CONSH". You can also base the report on a Query. Click on
the Queries Tab in the Database Explorer and look at the "Sales by Year" Query and then look at Reports
again an open the "Sales by Year" report and you will see that the Record Source for that report is the
Query "Sales by Year" There is a plethora of information and examples in the Northwind database that can
be gleaned to help you solve your problems.
Quote:
|
"MikeB" <m.byerleyATVerizonDottieNettie> wrote "prowsy" <rob (AT) jasperjones (DOT) co.uk> wrote I am having a problem copying a report within an access database. Im using Access2002 and have used the database wizard to create the "order entry" database and have tweaked a few of the names and fields to suit my needs. The whole thing works perfectly except for the reports. The Invoice report that was generated by the wizard works perfectly but I want to duplicate it to create a delivery note as all the fields are the same except I want to title it differently. I have tried to copy and paste the report When you copy and paste the Report, you are pasting the Report Object repleat with all the settings for properties of the original, which in your case the Record Source property of your new report is the same as the original. You will need to open the Report in the Designer, Open the property page for the Report and then on the Data Tab, press the Down Arrow for the Record Source property to invoke the Query builder to set the specification for that report. and then attach it by a button to the orders screen next to the invoice but when I run it it picks up every single order for every client and not the one order. This is my first database with access and I cant get my head around writing a new report, can anyone help????? Rob |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.