T
Tokyo Alex
Dear all,
I am trying to prepare a report with a pie chart. I want to (among other
things) show what proportion of quotes are flagged as "Premier" priority,
grouped per week.
Here are the details:
Report -
RecordSource: saved query (qdfQuoteOrderConversion)
Grouping: Week
Graph -
Section: Week Footer (which also contains a textbox bound to Week)
RowSource: SELECT [IsPrem],Count([IsPrem]) AS [CountOfIsPrem] FROM
[qdfQuoteOrderConversion] GROUP BY [IsPrem];
Link Master Fields: Week
Link Child Fields: Week
OLE Class: Microsoft Graph Chart
Class: MSGraph.Chart.8
Errors:
If I go to Report View, the report runs but the graphs display sample data
only, my data is not loaded from the RowSource.
If I go to Print Preview I get the following errors:
"This expression is typed incorrectly, or it is too complex to be evaluated.
For example, a numeric expression may contain too many complicated elements.
Try simplifying the expression by assigning parts of the expression to
variables."
"An error occurred while sending data to the OLE Server..."
If I click on the elipsis in the Link Master/Child Fields properties:
"Can't build a link between unbound forms."
If I remove the Links, I get identical graphs showing the report (not
weekly) totals in both Report View, and print preview. (This, at least, is
expected behaviour).
I have looked at Duane Hookom's "Report with chart using 2 link fields"
(http://www.access.hookom.net/Samples.htm) and it works on my machine.
System:
Windows XP Pro SP3
Access 2007 SP2
Microsoft Graph (12. ...) SP2
I am at my wits' end, so any ideas I could try would be very much appreciated.
Thanks,
Alex.
I am trying to prepare a report with a pie chart. I want to (among other
things) show what proportion of quotes are flagged as "Premier" priority,
grouped per week.
Here are the details:
Report -
RecordSource: saved query (qdfQuoteOrderConversion)
Grouping: Week
Graph -
Section: Week Footer (which also contains a textbox bound to Week)
RowSource: SELECT [IsPrem],Count([IsPrem]) AS [CountOfIsPrem] FROM
[qdfQuoteOrderConversion] GROUP BY [IsPrem];
Link Master Fields: Week
Link Child Fields: Week
OLE Class: Microsoft Graph Chart
Class: MSGraph.Chart.8
Errors:
If I go to Report View, the report runs but the graphs display sample data
only, my data is not loaded from the RowSource.
If I go to Print Preview I get the following errors:
"This expression is typed incorrectly, or it is too complex to be evaluated.
For example, a numeric expression may contain too many complicated elements.
Try simplifying the expression by assigning parts of the expression to
variables."
"An error occurred while sending data to the OLE Server..."
If I click on the elipsis in the Link Master/Child Fields properties:
"Can't build a link between unbound forms."
If I remove the Links, I get identical graphs showing the report (not
weekly) totals in both Report View, and print preview. (This, at least, is
expected behaviour).
I have looked at Duane Hookom's "Report with chart using 2 link fields"
(http://www.access.hookom.net/Samples.htm) and it works on my machine.
System:
Windows XP Pro SP3
Access 2007 SP2
Microsoft Graph (12. ...) SP2
I am at my wits' end, so any ideas I could try would be very much appreciated.
Thanks,
Alex.