Re: insert a chart to a report

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

Why do you think you need to set the Row Source at run-time. Your first
question didn't make any mention of doing this.
--
Duane Hookom
Microsoft Access MVP


"iccsi" wrote:

On Jul 11, 12:28 pm, iccsi <inu...@xxxxxxxxx> wrote:
On Jul 11, 12:09 pm, Duane Hookom <duanehookom@xxxxxxxxxxxxxxxxxx>
wrote:





You can generally create a chart based on any table or query and then
afterwards set the Row Source property to whatever you want.
--
Duane Hookom
Microsoft Access MVP

"iccsi" wrote:
I tried to insert a chart to my report.

Access asks me to select table or query.
This is a crosstab non-fixed column report.
Does Access reprot support non-fixed column report?

Your information is great appreciated,- Hide quoted text -

- Show quoted text -

Do you mean that I can set them at run time, because the report is
from crossab non-fixed columns?

Thanks again,- Hide quoted text -

- Show quoted text -

do you have any example to set rowsource and chart type example code
at run time?

Thanks again,

.

Relevant Pages

  • RE: Graph in Report
    ... What is your issue with the graph? ... Microsoft Access MVP ... "Duane Hookom" wrote: ... the rest of the row source remained the same. ...
    (microsoft.public.access.reports)
  • RE: Include last available date in graph
    ... You may be able to use the "TOP" argument in your graph's Row Source. ... SELECT TOP 35 SomeDate, SomeValue ... Duane Hookom ... Microsoft Access MVP ...
    (microsoft.public.access.reports)
  • RE: runtime error record is deleted
    ... Microsoft Access MVP ... Should I run an update query to update all of the tables or should I load ... "Duane Hookom" wrote: ... Public Function ParseText(pstrText As String, intElement As Integer, _ ...
    (microsoft.public.access.queries)
  • Re: Hide blank columns
    ... Microsoft Access MVP ... "Duane Hookom" wrote: ... certainly would appear to be a violation of relational database design ...
    (microsoft.public.access.reports)
  • Re: How to list all tables of a database in a combobox.
    ... Graham's given you an SQL statement that would be typed into the Row Source ... Doug Steele, Microsoft Access MVP ... >>> differant tables are each a differant catagory (Stainless Steel, ...
    (microsoft.public.access.forms)