- Re: Line spacing in Text (memo) fields in Access 2007 reports
- Re: Memo fields loos formatting on export to Word
- Hide a text box when condition is met
- Access
- Report using union query
- Palatino Linotype Font Issue
- Custom colours in Graph not working
- test message
- test message
- Conditional change to a field in a printed detail line
- Changing a unbound field in a detail line
- Number Field Automatically Rounding Decimals
- RE: Merge Data Into a Report???
- Query not working with report
- Child/Master Link in Report with SubReport
- Only show subtotals for certain criteria
- 1st page graph disappears when printed to PDF file
- Report using cross tab
- saving report in runtime
- Report Output Errors
- Report calculation
- Set Unbound Control TextAlign Property
- Suppress printing of 1st detail record
- Suppress total for first record of a group
- Unstable Navigation Bar
- pdf file won't print graph in report header
- Re: Hide subreport and main report record if subreport running sum is zero
- single space
- Return Desired Value in a Text Box
- Missing Information in Query - HELP
- Error sending report as pdf attachment
- Parameter query / check box..
- Lookup value in table from value in report query
- Seating Chart
- Multiple Records in One Report
- Print First Character of 30 Byte Field on Report
- chart axis labels
- Page break within one line of text
- Running Sum Changes when not visible
- how to setup event procedure on format?
- Calculating totals in a report in Access 2007
- On Open Event in a report
- QR Barcode Format
- Access 2007 Report shows multiple rows, query shows single row
- RE: Ms Access List boxes
- Access 2007 Report shows multiple rows, query shows single row
- Bar charts in Access comparing a specific detail item to a group.
- 2007 Access Reports On the Web
- Re: sorting on data calculated during DetailFormat?
- how are you doing
- Group summation not working
- How to populate a textbox in a report with a macro command button ?
- Custom function in detail section
- Re: Return to Menu after closing Mailing Labels
- In my Justified Report not all data shows in a memo field?
- formatting report using crosstab query
- Missing data in Access reports
- Annoying errer message
- Sub Report placement
- Re: Avoiding duplicate counting
- Merge fields into one
- doing math on summed totals
- Displaying blank space when no data in subreport
- Report Not Showing All Records
- getting an average on the "Count" in a report summary
- Page break within line of text
- Re: sum totals in report footer
- Re: sum totals in report footer
- no data in subreport
- 2007 Memo Append History - Use
- Barcode a Custom Autonumber field
- Page Break
- Looking for a database to track date specific certification
- Coding in Text box on a report
- Vertical Growing/Dynamic Growth In Access Tables
- Number of records in a group - Access 2003
- Column headings
- Print Preview Works, Paper Printing Does not
- Re: Date limited report
- Re: Date limited report
- trying to sum a group of records but "sum" missing from Group, Sort, and Total dropdown/wizard
- How can I bottom align text inside a control box in Access?
- print ribbon in 2007
- want to add sum fields in different sections of a report
- SubReport On two pages
- If difference is bigger than 0.1, then some more information show upon the report
- Return the Most Recent Update
- How do I look up a value based on a report field
- Custom Print, close, email ribbon
- Access report problem
- Report columns
- Report Conversion issue from 2003 to 2007
- Parameter for Report from Form
- RE: Create report that shows a previous balance as of a date entered o
- separate different categories with a line?
- Hide rows based on values in 3 columns of a report.
- Re: Create report that shows a previous balance as of a date entered on a form
- missing data
- make value of text box (or other control) that of query
- Re: Report has 126 pages and take forever to run
- Re: Report has 126 pages and take forever to run
- Re: Open Reports in Maximum Print Preview
- Duplicate Numbers - Count only once
- How conditionally skip stuff on a report?
- fake checkbox based off lookup column
- Group Header missing
- Error message for DLookUp
- Incessant firewall alerts!
- Protecting a Report from being modified
- Auto Populated fields from a form
- RE: Parameter input with no parameter set up
- Re: Parameter input with no parameter set up
- Grouping by Past and Future Dates
- Currency Alignment
- Only want a page header and page footer to appear on first page
- Query Help
- Report Template
- Grouping by Past and Future Dates
- Message in Null report field
- Vertical Line Help
- Excel spreadsheet as report template
- Is there a way to freeze the Header Row while in report View inAccess 2007?
- Report will not recognize field
- Balance Forward
- conditional detail format
- RE: qty bought should be less than or equal to the inventory balance
- Re: REPORT COMBINATION
- email a Report using PDF
- dlookup based on two criteria
- Access 2007 Won't Open My 2003 Report
- Subreports in Access 2007
- Subreports in Access 2007
- Batching Totals in Groups of 25 - How?
- Show Report Header on First Page?
- Trying to Export Report to Excel 2003
- 1111
- Displaying Last Date in Report Footer
- OLE Object Data type (Package & Bitmap image)
- bold in report or form
- Can Grow moves lower fields
- User-Defined Report Heading
- Query results not showing nulls
- Report to PowePoint?
- How to Print a large memo field on multiple pages without losing .
- Count Only Yes checks in Access Report
- Graphs/Charts in Access 2002
- Access2007 won't run report event procedures (e.g. Detail Format)
- break did not work
- Re: Stacked Reports Printing Issue
- Still looking for deleted Macro
- Picture in report
- Error when going to Print Preview in Access 2003 Report
- RE: Text Box Not Large Enough
- Subreport Madness
- Grouping by Dates before & after Today's date
- Export Report to Word Document
- RE: I don't have any parameters, yet they show up
- Duplicate records/numbers/values
- Compare Different Rates
- Code to create graphs
- Is this possible from Print Preview?
- Run-time error '2100' - Help Please
- Combine 13 different reports
- Why Does the Report Re-Run when printed?
- Having problems linking Child/Master fields in Report
- Out of Memory
- Print Preview issue
- Re: Prevent a "Can Grow" text box from affecting other controls
- Print oreview multiple records
- How do I remove blance spaces from a report?
- Calender Report
- Show Group Footer Only on First Occurance
- RE: How to automatically populate fields in the subform
- Access Reports without an Access Table – Is this possible?
- On Format - runtime 459
- Subreport page breaks
- Problem filtering reports
- Help with Date Difference Expression
- display report records in access 2007
- Having multiply report orientation within 1 report in Aceess
- RE: Field on a report
- Global property change
- Follow-up to DAO.Recordset as Report record source
- Filtering problem
- Slow Reports
- Exclude Report Header and Footer based on Section?
- IFF
- “This Action requires an Object Name argument” Error Message
- Re: Report based on specific dates
- Page Break cause Blank pages
- Multi level grouping
- Report Grouping
- Vanishing subreports
- Re: Conditions on the CanGrow property
- Opening a report only for a specific company
- Where do I find date-picker (to select date via calender) add-on?
- Access 2007 - No close in preview
- Adding a field (Unbound field) that adds a group of numbers
- Sum
- Dynamic report header
- Can Shrink option not working with Rich Text
- Subreport Linking
- Access 2007 - Copy Control and Label
- How conditionally skip stuff on a report?
- Report Footer, multi-column rpt
- Calculating Multiple text boxes
- Detail Section-Field Spacing
- Access Change My Default Printer
- Repeating Data
- Crosstab query is no longer crosstab when I include field (in repo
- Subreport Question
- Group Count of Dates (No Duplicates)
- Passing OrderBy criteria from Form to Report
- Lines in reports
- passing OrderBy criteria from Form to Report in accde file
- calculations of records within detail section
- Gantt Timeline
- Subreport and Header Empty
- Access 2003 report in access 2007
- Message Request Box
- Summing expressions per group in a report
- Detail Format event code
- How can I filter groups in a report ?
- DAO.Recordset as Report record source
- Can Excel charts be used in Access instead of Microsoft Graph?
- Date format
- Equal character in control text
- 6 month time bracket in report header
- Force page setup margins to 0?
- How do I change report from portrait to landscape
- Reports locking up
- Web based graphics
- Access text box borders
- Combining multiple reports into one report or PDF
- Access 2003 Report & VB Problem
- Aggregate Funcation
- Problem With Report Export to Text File
- Filter report based on continuous form
- Show SUM expression in text box
- IIF sum question
- Expression is typed incorrectly or . . . . change to variables
- count in parent report footer
- Page Margin Surprises ... can't reset
- Quick Question regarding the use of charts on reports
- Date Range in Reports
- how do you make "down, then across" columns in a subreport?
- 1 Form w Buttons to sever Reports, how to Share link/shortcut to F
- Running Total from a calculated value
- Access Printing Report
- Calendar-like features
- Calculating Percent of a Group in Report Footer
- Report Control Source Formula
- Vertical Text
- Report Progress Indicator
- Report page number resetting
- Show a report filtered by text fields of a form
- Subreport with headings
- Access 2007 report to many fields
- Table Setup and Reports Suggestions
- Inserting PDF Files into Report
- Prevent rows wrapping over multiple columns in a report
- Keep data from a field together as typed
- SynNeed to account for null values in subreports
- Want to Unify different Reports/Queries
- Mapping data using access 2003/2007
- Page Setup with VBA
- slow access 2007 report
- update cross tab query in a report
- Optional second report page based on field contents and control si
- AMENDMENT to my Conditional Formatting Question
- Conditional Formatting based on another report field
- Access prints the form from wich the report is launch intead of th
- Phone List Report
- Re: selecting record based on months
- Sum unique entries in report footer
- Access 97 crashes opening a report
- Chart help - Y Axis question
- Help In Assigning a color for a value in a Pie Chart
- Main Report without Data
- Print just the current record showing on the form
- Sort a calculated field
- Automatic 1 Week Query/Report?
- Sometime first record does not print
- Filter records in a Report
- Printing a report and the sides and top don't print bold.
- How do I get average days to fill?
- Using ConvertReportToPDF (Stephen Lebans) with Vista
- Combine 2 reports into one
- Problem with page heading
- Page break between sub reports of a sub report
- Format one field in a string to bold
- Display every nth record in report
- Display every nth record in report
- Emailing a report in Access
- combine multiple reports to one PDF
- Group Footer Summarizing Problem
- How to do Event on Open of Report, Choice -Sort by Received Date o
- msgbox, message box text font size
- Access 2007 create report from multiple reports/queries
- #name?
- Count or sum unique records in a report's group footer in Access 2
- Filter a report based on combox value
- How do I expand a column that's been collapsed?
- Custom Label Report?
- Scaling Report Size
- chart multiple pages
- db Objects and Charts
- Make empty subreport disappear
- Chart problem 2
- Page break between sub-sub-reports
- How can I Order By in Access Graph Chart ?
- conditional formatting - days & hours
- Prevent report from running if a field is null
- RE: I need to locate a report from a hard copy
- RE: I need to locate a report from a hard copy
- PDF as Report Background
- Maximize doesn't work
- Conditional formatting for blank cell on report
- OutPutTo to RFT
- Errors in Report total fields
- Print labels rather than numbers from combo box
- Sending Access 2003 Charts through email
- Conditional formatting of date supplied by a form
- Report Expression
- Access 2007 Analyze with Excel
- How do you allow memo fields to break for pages.
- How to add an additional summed up Quantity
- Report chart problem
- Multiple Subreport Problem
- Can Grow property problem
- RE: label-limit to two rows
- view birthdate based on age
- Subtotals, not re-initializing
- Report with dates and dollars
- SendObject Report A2007
- Formatting dates
- global parameter value
- Decode function
- formatting help
- How to avoid blank pages in a report, when there are no data
- Access ADP Report problem
- search for old reports
- Dialog Box with dates
- how can I change the default email software for sending reports
- A3 Report layout help
- Counting Records in a report
- Have I stumped the MVPs?
- Yes/No field in a report parameter form?
- display data in report from tables with same ID
- Dcount help
- boxes with rounded corners
- Why am I getting this error?
- Memo field is truncating in group heading of an Access 2007 report
- Using Access2002, an "&" in a report won't print? Why?
- " & " Text Box in a Report
- Subtotal Problem/Conflict
- Re: drop down menus on reports
- horizontal & vertical on same report??
- line spacing
- Continuous page size
- Interactive report - insert comment (like Excel)?
- RE: FILTER RECORDS ON A TABLE
- architecture / design for MDB Access reports
- Filter report on a form
- Merging Reports
- Creating a template letter/Report via dropdown menu & pop-up table
- Filtering reports
- Rounding Decimals
- A2007 Report not evaluating Where Condition
- =iif Calculated field in report?
- Keeping a group on one page
- Blank pages on his computer not mine
- Weighted Calculations
- Parameter Query of "between ...and "
- A curious note found in report's code sheet
- Report Properties
- How create a hyperlink to a page in a report:?
- Re: Nothing showing for page of pages
- Suppress Report Header
- Using Data from a Report in a Form
- Pivot Table Expression
- individual last records
- Moving data from a report to a form
- Access settings?
- header and body side by side in reports - is it possible?
- yes/no checkboxes
- ms access dynamic reporting
- Format no longer works under Vista?
- Lebans CreateBitmapFile
- Trying to Sort a Pie Chart
- Where did this report come from?
- group on first line instead of offset
- Best way to Add a lot of text to a Report
- pages limitations
- columns in detail area of access report
- How to Create Color PDF instead of B&W only?
- MsgBox when query doesn't open
- Logo visible on MS Access Report but not when I print to PDF
- Display all Pictures
- How to make and executable mdb file
- Decimal places doesn't seem to work
- Re: Limits to the Switch Fonction
- Re: Limits to the Switch Fonction
- Limits to the Switch Fonction
- Need a form for Customer Range - can I copy the one I used for dat
- Print report sections on different pages
- Combining SUM and IIF NULL Statement
- How to run a report from chosing an item form a combo box
- Print objects only on the last page of a report
- Unique ID Problem !!??
- missing data on report
- How to get counts & totals from a drop-down list
- Microsoft Access
- Stefen Lebans' ReportToPDF with high res printing
- Hiding Data Labels for 0 Values in Pie Chart
- change page expression to sheet with preceding 00
- Need help Grouping by date using multiple date guidelines
- block 'print data only' option in report preview in Access
- Multi-page subreport
- Printing Main Report Details on all pages
- Using an Append query in VBA to change the field name provides theSyntax Error 3075
- Re: Is there any ActiveX controls support for Bar Code ?
- Help with columns
- Sum with IIf doesn't pull the info all the time
- Report Details Overlap Headers and Footers
- Possible to select / define printable area in access report?
- RE: Printing Numerous Records on 1 go
- Display partial results when using combo box as control source
- Re: Reports and Events
- Adding Text Box Values
- Report based upon notes enter on Specific Day
- Using CanShrink
- order of Parameter prompts Changed
- Printing incremental number on report.
- the report wizard states that it cannot create rreport
- Re: Conditional formatting won't work
- Need help with emty field in a report
- Access
- Force page after 20 records
- Subreport-report hangs while trying to format subreport
- Full sheet of same label
- Reports with 3 columns?
- Printer Name is blank in Access 2007
- Write separate PDF file for every record of a report
- #Error in Expression
- Variable Sub-report
- Re: alphabetical order of reports in a listbox
- Forcing Page Break
- Conditional Formatting Printing
- combo box or list box
- Adding a duplicate page to a report
- How do I get report to print this way?
- Add the word "continued" in a Repeat Section
- Field changes per senario
- Chart help
- Print Multiple Subreport Copies
- Trial Balance Report
- Display graphical check for completed tasks
- Duplex no longer working
- Access Opening Balance Expression
- Stephen Lebans - access report to pdf converter - update
- Form with date range & macro to run report but dates don't work
- Using Switchboard - how can I have user enter a date range for a r
- Attached jpeg files - cleaning image
- RE: Report & page breaks via VBA
- RE: Report Problem
- Crosstab Row Sorting in Alphabetical Order
- Printing - Data Only
- Access Report to Excel Worksheet
- Re: Draw A Line Across Both Columns
- Stephen Lebans - Access Report to pdf converter
- label wizard
- Print errors
- Pie Charts
- RE: Is it possible to have a subtotal in a report every 10th line
- Pictures in Access Database
- Cannot get my graph to print
- How do I overlay variable items on an imported image used for a re
- Re: Draw A Line Across Both Columns
- RE: Getting "Latest" Exam Date on Query
- Re: Getting "Latest" Exam Date on Query
- Populate unbound controls on report using VBA
- Open Report based on Txt Box Value
- Showing global variable in a report??
- created report but cant find
- Re: Filtering
- Access 2003 - Printing - Fit to Page
- Report with photo
- Good book on Reports?
- How do I force a new report page based on a field's contents?
- Re: Is it possible to have a subtotal in a report every 10th line
- Limit and group slices in a Pie Chart
- Report based on criteria form
- Replace Word Doc with Access 2007 Report?
- Avoid printing spaces
- Can I manipulate my report group header with VBA?
- Add data to page footer
- Would like to see NEW Form.
- Getting Access online
- clear a filter on close
- Access 2003 legal size reports printing on letter?
- query to be exeucuted..
- Problems with AND in multiple IIF statements
- Sub report expands even though Can Grow is no
- Populate a text box on a report by code - help please.
- Can I include a graphic in a report?
- Re: Trying to look like this
- RE: Trying to look like this
- Reports direct to email
- Importing PDF Files INTO a Report
- Missing Data When Printing from new record
- Re: DLookup
- Re: DLookup
- Count IIF
- Does Access still limit #records in a table? Where do i fix?
- Keep size of subreport the same
- Refering to a Reports underlying data using VBA in Detail OnFormat event
- Make a Control Dissapear with Conditional Formatting?
- Sorting and Grouping
- Re: Group By and Grouping
- Re: Dynamic Group Report
- Re: Group By and Grouping
- How do I tell an individual field to not break?
- Re: Group By and Grouping
- ##### covering important info in database HELP!!!! Access2007
- Unable To Use Group & Sort Options
- Main Report Header is on SubReport
- Dynamic Group Report
- Re: Rogue Parameter Value
- Multiple Chart function (Access 2007)-builds graphs on one page on
- Skipping page conditionally
- RE: Run a report of what is missing.....?
- Different behaviour in Accsess-Runtime version
- add blank lines to report
- Property not found error message
- report data grouping failure?
- Formatting Data
- Make a SubReport from a PDF document
- Re: How do I count Columns in Crosstab report
- Show Parameter Information in Report Footer
- how to select parameter in subreport when main report is opened
- Calculating a Null Value
- Publishing a report to PDF
- queries delete themself after i print my reports
- Re: Multi-Select Listbox Value on Form
- Calc Fields in Reports
- Suppression of name in a list
- if it is null how not to get the #error
- Image collection/Report
- Re: Count Rows On Last Page
- Re: Count Rows On Last Page
- Re: Count Rows On Last Page
- query help needed
- how to put multiple results in one text box
- MS Access 2007 Dot Matrix Label Printing
- Mail Merge
- Pulling a report on JUST one record
- Simulating a manual form
- How do I count the number of group breaks?
- Create a seperate page at the end of a report for revision notes
- Sort 1, 1A, 2,3,4,9,10,10A,11,23,45,
- Page Orientation
- Query Criteria
- Sheet Labels in Access
- how do you shade alternating lines in a tabular report
- Count records in Parameter Query for Report
- runtime calculations?!
- chart using query with between
- Detail section's Height property does not alter when shrinks / gro
- Coordinating the sort order in a report with the underlying query
- Option to Print reports for selected records
- Print at two seperate locations
- Report Subtotal
- Digitally Sign Report
- last record
- Data with DateAdd
- Grouping page break not working
- format page takes a long time
- Access 2000 Reports is printing issue
- Conditional formatting based on the value of another field
- No Data
- How to filter data in a subreport
- Group by field repeats
- Re: Microsoft Access Has Encountered A Problem
- Re: Can Subreport Be Made Transparent
- Subreport page break in label controls or textbox controls
- Run Report of Current Record of Subform
- Shrink font size for select records
- Line Charts
- Combining Data for a Quarterly Report
- Re: Pick records from a table
- custom page size
- Re: Pick records from a table
- Looking for work
- Re: Pick records from a table - little stevie is desperate for work
- Truncating memo field
- what does =llf([District]) do in a report
- Re: Pick records from a table
- How do I create a report that has the details shown in columns?
- Too many queries
- Using MoveLayout to print subtotal on last detail line of group
- Count ages in footer
- Re: Microsoft Access Has Encountered A Problem
- Color and bolding don't show up
- RE: Microsoft Access Has Encountered A Problem
- Re: Microsoft Access Has Encountered A Problem
- Re: Microsoft Access Has Encountered A Problem
- Create reports with PDF fields?
- Can My Report Look Like this?
- Totals not working
- column width changes report header width
- count number of records from a specific date
- data appears in Layout View but not in Print Preview?
- Ms Access size?
- dynamic crosstab problems
- Report > Display the title only
- Text controls that grow horizontally
- Trouble with Simple Pie Chart
- Repost > Print double-sided if needed, but new sheet for new perso
- Format part of a text string
- Dynamtic Report columns Based on Crosstab Query
- Count function showing #Error when no Record
- MoveLayout and line feed question
- Closing print preview puts report in design view
- Error 2709
- RE: Can Subreport Be Made Transparent
- OnFormat action not executed when exporting to PDF
- detail size not as wide as report header
- Report page size locked.
- report layout
- Calculating an inventory balance at a "point in time"
- column headings not displaying for all columns
- Reporting total number of clients
- Access Reports VERY slow to display
- How do I have report fields stored as total caps display in Prope.
- Save reports as unique files
- Report Help - Starting/Ending Balance
- sorting order
- rounding up a calculated field to the next $5 level
- Report Recordset
- Prompting for a report
- Report Page Number Change
- Printing Format Different than what displays on the screen
- Printing report issue
- How can I center-vertical align a cell in Access 2007 report ?
- Graph Report
- Keyboard mapping changed on Access no other applications affected
- Running sum calculation
- International dates
- PDF not available
- How can I add 3 pages of formatted text to the beginning of a repo
- Transpose query result into report
- Objects not showing in Print Preview, but appear when actually pri
- Email a single Report?
- Old report from MS Office 2003
- Displaying header of yes/no boxes instead of boxes
- Print report and subreport(no data) without blank page
- use a text box as Y axis lable in a Chart
- Re: Blank Lines Added To Each page Of Report
- Re: REPORT not displaying
- Design Grid Missing?!
- Extra space on reports
- Empty text box
- Page Headers printing on subsequent pages above a subreport
- Microsoft Report won't export or Merge
- Set page size to 11x17
- Hide section line on top of new page
- Conditional Formatting Question
- Conditional Formatting
- Conditional Formatting
- Avoid page breaks on report
- Using DCount in report with parameter qry
- Storing Expression in form
- Inserting Subreports
- Using Detail.Print
- Data showing incorrectly in report
- RE: Blank Lines Added To Each page Of Report
- Totalling Expr1 in a report
- Re: Creating automatic reports in Excel using Access
- Allow page breaks a group of records
- order of processing??
- general report question on hierarchy
- Detail Group Visibility State
- Show Maximum Number in Report Footer
- sorting dilemma
- Sorting Numbers
- Putting all record information in one column/field on report
- RE: Calculations in reports
- need to link with word document
- Slide to left?
- #Number Error in Report - Display Zero
- BOM
- report design
- RE: Reports by Function
- Pop Up Report
- Date on Report
- Is there any way to make and save my own report template?
- Printing Labels but designating which label on sheet to start prin
- Skip printing selected records
- IIf statement
- Iif Statement with Null Values
- Graphs not showing
- Page Header resizing
- selecting data for report
- Re: How to add conditional information
- Print report from command button
- Using Form for Criteria for Report
- Print to XPS with Access 2002?
- print last record of 1-to-many relationship
- Bold the first character of everyline in report
- Re: How to add conditional information
- Columns in sub-report on detail section
- Thanks
- Get Sums for 2 DCount fields on report
- different recordsource for multiple copies of subreport
- Re: 1 table of 1 whole year data
- Re: 1 table of 1 whole year data
- using unbound popup form for parameters
- Missing data
- how do i rank on report
- Conditional Format To Add Text
- Formatting for zero decimals
- Using a list or combo box to set the value for a report- one more
- Running Sum problem
- Report skips through form with parameters
- Change Top property for TextBox in report
- Dynamic Reporting based on Parameterized Crosstab Query
- Widow and orphan control in reports.
- Report/Query Criteria
- How do i create a report in Access. ie: Weekly Call Summary??
- Re: Using a List or Combo Box to set the value for a Report
- Sort by calculation (a summation field) in report
- Calculating the difference between dates in a Running Sum report
- Re: Count Records On Each Page In A Report
- Word to Access
- Cancel printing blank lines
- Traffic Light or Stop Light Chart
- Marginless Labels
- Calculations in a report
- How to display a 0 in a field? Error message #number
- Access07 report requiring all fields of the record source?
- Progress Meter or Gauge
- parameter prompt problem
- totals not visible in report
- Report with conditionnal formatting issue
- Unbound text
- Strange Header Behavior
- Labels in a footer
- Adding a Date Range to a Report
- Report with pivot tables and pivot charts in sub reports