Faster alternative to Microsoft Graph 5.0 Chart ??

mark

I've got an 83-page report which contains an Microsoft Graph 8 Chart,
but the report takes FOREVER to format, probably because the row source
is a bit complex:

TRANSFORM Sum(qryCallsSum marizedByArbitr aryYear.CallCou nt) AS
SumOfCallCount SELECT qryCallsSummari zedByArbitraryY ear.DateByYear FROM
qryCallsSummari zedByArbitraryY ear GROUP BY
qryCallsSummari zedByArbitraryY ear.DateByYear PIVOT
qryCallsSummari zedByArbitraryY ear.[Property Code];

Can anyone suggest:
(1) A faster query that yields the same graph? or
(2) A faster alternative to the Graph 8 component?

I've tried the MS Graph 5 component with no improvement
Thanks!

Mark

Nov 13 '05 #1

Subscribe Reply

2829

parrishioner

Access will evaluate the query for each chart that needs to be produced
-- even if the query is the same for each chart. If your query is
complex this can lead to very long rendering times, which you've
clearly experienced. One workaround I've had success with is to output
query results to a temporary table, then use that temporary table as
the recordsource for the report. A 20-page report now renders in 10
seconds instead of 2 minutes.

Obviously your use of temporary tables would have to be carefully
controlled in a multiuser environment.

Nov 13 '05 #2

jimfortune

mark wrote:

I've got an 83-page report which contains an Microsoft Graph 8 Chart,
...
Can anyone suggest:
(1) A faster query that yields the same graph? or
(2) A faster alternative to the Graph 8 component?

I've tried the MS Graph 5 component with no improvement
Thanks!

Mark

If you're interested in Adobe Reader readable pdf output directly from
Access take a look at:

http://www.oakland.edu/~fortune/SampleHistogram.pdf

and

http://www.oakland.edu/~fortune/Histogram.zip

for an example of creating graphical output. I haven't gotten around
to solving the 'Rebuild' problem yet (byte count is probably just a
little off) but Reader displays and prints everything nicely. Be sure
to close the Reader file before trying to create another with the same
name as the one that's open. Forms I've built have created thousands of
pdf documents using this technique but use at your own risk. In the
future I'll try to use other pdf readers to test the file created so
that it's more compliant. It's written in A97 so let me know if you or
anyone else have trouble converting to a different version of Access.
Partly because I'm a little unorthodox I've always used code whenever a
crosstab query could be used; so I can't give you any advice about
speeding up your query other than that I agree with the other poster's
comments.

James A. Fortune

Nov 13 '05 #3

Similar topics

4810

Microsoft Graph Chart in Access 2003

by: Dave | last post by:

I have a report that utilizes a Chart with 2 different Chart Types. It works great with the exception that each Item that the chart plots is supposed to have it's own designated color that doesn't change. I can manually set it, but the items don't always come up. When that happens one of the other items assumes that color or Chart Type. I've found the MSOWCVBA.CHM file, but it's not very helpful. Is this the right file? Is there...

Microsoft Access / VBA

3125

Graph Chart using Access 2k3 with 2k format

by: Dave | last post by:

I'm trying to follow the examples in VBAGRP9.CHM and/or VBAGR10.CHM with no success. I'm trying to Chage the Legend Colors based on Content so that I can establish a certain color format on Content. The Chart will reside on a Report and possibly converted to a 2002 format. Currently I'm using the following code with Microsoft Graph 11.0 Object Library referenced.: With myChart.Legend For i = 1 To .LegendEntries.Count...

Microsoft Access / VBA

4880

Microsoft graph and C#

by: Andres Romero | last post by:

I canÂ´t find information about how to work with a Microsoft Graph object in windows forms using C# I have a macro in PowerPoint which creates slides and elements like graphs using Microsoft Graph 10 ("MSGraph.Chart") and I'm migrating to C# with Visual Studio .Net 2003 but not enough information I have found Some help?

C# / C Sharp

1811

Asp.Net Graph / Chart

by: sam | last post by:

I just wonder where could I find sample of ASP.Net Graph / Chart (Line, Bar, Pie) beside microsoft.com? How hard to coding ASP.Net Chart? Or better to do at MS SQL Server 2000 Reporting Service? Please help.

ASP.NET

11637

How to use Microsoft Office Chart control ?

by: Scott H | last post by:

Hello, I'm trying it use the Microsoft Office Chart control 11.0 in VB.net (for a windows forms project) and can't seem to get it to work, I've been playing around with various snippets of code. below is what I've got at the moment, I'm trying to feed in literal numbers. I placed a chart control on the form and called it ChartSpace1 and adjusted a couple of settings to get it roughly as I want it, then ran this code:

Visual Basic .NET

4901

Microsoft Graph Chart - Adding labels in Datasheet

by: ruthboaz | last post by:

Hi, My database is in SQL Server with Access as front end. I have a Microsoft Graph Chart for which the data is picked up with a query from the SQL Server. In the DataSheet the first row is picked up as the label which is the first record in the database. If I insert a row in the datasheet and then add a label its updating the chart correctly.

Microsoft Access / VBA

5966

MS Graph Chart Control...

by: stupidintern | last post by:

Hi, This is my first post here so please be patient. Here is my question: I am trying to include a chart in my VB form. I do it this way: I drop the Microsoft Graph Chart Control (from Unbound Controls) on the form. Then I go to the code and try to type something like this: olebound23.Application.DataSheet.Range("a1").Value = "75" 'stolen from MSDN Here is the problem: olebound23.application doen not have a DataSheet member. I 've spen...

Visual Basic 4 / 5 / 6

2465

Changing Line Graph Colors in Microsoft Graph

by: Neil Ginsberg | last post by:

Anyone know a way to change the colors used for the lines of a line graph in a Microsoft Graph Chart (Access 2003)? Some of the very-light colors they use are barely readable! TIA! Neil

Microsoft Access / VBA

2171

graph / chart from query without summarising data

by: thecheyenne | last post by:

Dear All! I have a query that holds test results for my students; each test is either a listening-test, reading-test, speaking-test or writing-test. All results are in % and already calculated by the query using the expression Percentage: Results!Score*100/Assignments! I'd like to convert these results into a simple bar chart and I'd like to add this chart to each student's report card, which is essentially a simple Access-Report. The...

Microsoft Access / VBA

9554

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

10137

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

9812

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

8814

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

6640

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

5268

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

5405

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

3510

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

2788

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General