RE: Duane Hookom's Line graph by code

Assuming you have a [GroupID] field in your report, your function call might
look like:
DrawGraph(Me.GroupID)
The DrawGraph function would then used this value to filter the recordset
that is used to draw the lines.

--
Duane Hookom
Microsoft Access MVP


"george 16-17" wrote:

Hi Duane,

Thanks for replying.

I appreciate the direction and your expertise. I have been able to include
the record source and the bound text box.

A less vague question...how do I add the arugment? That is where I am
stumped. I apology in advance.

Thanks again,
george



"Duane Hookom" wrote:

You would need to include a Record Source for the report that returns the
unique group. Then add a text box bound to the group value in the detail
section.

The DrawGraph() function would need to be modified to add an argument for
the group so the OpenRecordset() method pulls only the group data.
--
Duane Hookom
Microsoft Access MVP


"george 16-17" wrote:

Greetings all,

...asking a vague question...expecting a vague answer...

I have adapted Mr Hookom's line graph by code example report from
http://www.access.hookom.net/Samples.htm. It is based on a crosstab query and
it works fine. It graphs all the data on one graph without using MS graph.
Could the code be adapted to produce a separate graph for each series of data
in a group?

Any direction would be appreciated. I can post the code if needed.
Thanks in advance,
george
.

Relevant Pages

  • RE: Graph in Report
    ... Private Sub Report_Open ... the graph works just fine. ... "Duane Hookom" wrote: ... I am trying to include a graph in an Access report. ...
    (microsoft.public.access.reports)
  • RE: Duane Hookoms Line graph by code
    ... It is almost perfect...The only problem is that the graph does not graph the ... "Duane Hookom" wrote: ... The DrawGraph function would then used this value to filter the recordset ...
    (microsoft.public.access.reports)
  • RE: Grouping w/ Graphs in Rpts
    ... my report up using your sample, but couldn't get it to work. ... combining the data from all the companies into each graph. ... "Duane Hookom" wrote: ... I tried it with the Company_Name and the ItemDescr in the ItemDescr group ...
    (microsoft.public.access.reports)
  • RE: Need help with using a bar graph in a report
    ... Apparently you feel the filtering is not clearing in the report when it is ... "Duane Hookom" wrote: ... the graph to cut off at that point instead of bleeding into the report. ...
    (microsoft.public.access.reports)
  • RE: Chart not working in report - Help requested
    ... "Duane Hookom" wrote: ... I am trying to prepare a report with a pie chart. ... OLE Class: Microsoft Graph Chart ...
    (microsoft.public.access.reports)