Re: Auto Formatting Report

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Duane Hookom (duanehookom_at_NO_SPAMhotmail.com)
Date: 10/30/04

  • Next message: Duane Hookom: "Re: Saving report as Gif File" 
    Date: Sat, 30 Oct 2004 00:18:40 -0500

    There is a sample that does this at
    http://www.invisibleinc.com/divFiles.cfm?divDivID=4. 

    -- 
Duane Hookom
MS Access MVP
"TD11" <TD11@discussions.microsoft.com> wrote in message
news:643ADEBC-C6FD-4F07-9FDB-6D5E04E50494@microsoft.com...
> I have a report based on a crosstab. The crosstab will return a varying
> number of columns depending on the user-defined criteria. I want the
report
> to print all of, and only, the columns generated through the crosstab.
>
> The column display data from individual stores, so depending on which
stores
> are selected by user input, the crosstab/report may have 1-10 columns.
>
> This causes an error when I run the report because it cannot find a
defined
> fieldname.
>
> Any quidance would be appreciated...
  • Next message: Duane Hookom: "Re: Saving report as Gif File"

    Relevant Pages

    • Re: SELECT Statement in a Report
      ... If you are still looking for a method to display the results of a crosstab ... probably be handled in the reports source query, ... calculated controls on the report. ... What do I use for the select statement in the Control Source ...
      (microsoft.public.access.reports)
    • Re: Null Column Headings in Crosstab affects Report?
      ... Are you familiar with Crosstab Queries? ... I used customer names as columns. ... included in your report, ... the table and assign the letters "A-F" or whatever. ...
      (microsoft.public.access.reports)
    • Re: Null Column Headings in Crosstab affects Report?
      ... "Duane Hookom" wrote: ... Are you familiar with Crosstab Queries? ... I used customer names as columns. ... included in your report, ...
      (microsoft.public.access.reports)
    • RE: Report based on filtered crosstab
      ... this doesn't help with the report. ... "Duane Hookom" wrote: ... not handling the dynamic columns in the report because I don't know how (that ... Below is the SQL for the crosstab (sorry its so ...
      (microsoft.public.access.reports)
    • Re: Trouble with parameter for crosstab in report
      ... I expect you are using a crosstab report solution that needs to get the ... fields from the querydef in order to set values/control sources. ... > criteria to the crosstab used in my report, it never opens, my Access ...
      (microsoft.public.access.reports)