Prestwood IT: Charts and Graphs probs

Charts and Graphs probs

Charts and Graphs probs in Paradox Graphs & Charts topic (part of our Corel Paradox / ObjectPAL Coding group).

Quick Search: Charts Graphs Charts Graphs probs

Charts and Graphs probs

Post ID #10916, 7 replies 12/29/2004 2:51:00 PM

Jon

Central California

I have a report that has a chart on it. If there are 4 records being graphed - i get 4 duplicate charts. Since I have a page break after the chart - it results in 4 pages - all the same. Any ideas or help much appreciated.

Posted 22 years ago (Thread Starter)

Comment

Quote

About Jon

Visit Profile

Approved member.

Member subscribes to this thread with a verified email.

About Jon

I am a self taught Paradox programmer. I have been programming in Paradox since the first Paradox for Windows release. I have done some Visual Basic and Embedded Visual Basic programming as addons to one of my Paradox applications.

Post ID #10916, 7 replies

Thread Started 12/29/2004 2:51:00 PM

View Counter=3047

Last Reply Posted 1/3/2005 2:59:00 PM)

Location=Central California

Joined=23 years ago MB Posts=32

Re: Charts and Graphs probs

12/29/2004 6:00:00 PM

Tony M

(Inactive)

Does it help to put the graph in the Report or Page Header?

Posted 22 years ago

Comment

Quote

About Tony M

Visit Profile

Inactive member.

Member does not subscribe to this thread.

Post ID #10917 (Level 1.1) Reply to 10916

Thread Started 12/29/2004 6:00:00 PM

View Counter=2

Location=

Joined=24 years ago MB Posts=410 KB Comments=1

Re: Charts and Graphs probs

12/30/2004 12:07:00 PM

Tony M

(Inactive)

Originally posted by Jon:
I tried Montana's solution and it worked - just put it in the Report Header with the grouping. Doesnt seem right or necessary but it worked so I am not complaining.

Glad to hear it worked for you. There's likely a simple explanation of why, but...

It took me a LOT of playing around, not to mention frustration, to arrive at that solution on my own. Wish I'd found the public forums with people available to help prior to working this one out. :)

Posted 22 years ago

Comment

Quote

About Tony M

Visit Profile

Inactive member.

Member does not subscribe to this thread.

Post ID #10923 (Level 1.2) Reply to 10916

Reply Posted 12/30/2004 12:07:00 PM

Location=

Joined=24 years ago MB Posts=410 KB Comments=1

Most Recent Post

Re: Charts and Graphs probs

1/3/2005 2:59:00 PM

Tony M

(Inactive)

Originally posted by Hoosier Boy:
Did you try putting it in the GROUP header, rather than page or report header?

I believe that'll cause multiple graphs in the GROUP header.

From his description, I don't believe that is what he needs/wants.

Correct me if I am wrong, please.

Posted 21 years ago

Comment

Quote

About Tony M

Visit Profile

Inactive member.

Member does not subscribe to this thread.

Post ID #10927 (Level 1.3) Reply to 10916

Reply Posted 1/3/2005 2:59:00 PM

Location=

Joined=24 years ago MB Posts=410 KB Comments=1

Re: Charts and Graphs probs

12/30/2004 9:47:00 AM

Daniel Fought

Prestwood IT

Home office in Fresno, CA.

How about giving us an idea of what the datamodel for this report looks like and what the graph is attempting to display.

Dan Fought
Senior Programmer Analyst
Prestwood IT Solutions
http://www.prestwood.com

Posted 22 years ago

Comment

Quote

About Daniel Fought

Visit Profile

Approved member.

Member subscribes to this thread with a verified email.

About Daniel Fought

Danial Fought is a senior programmer analyst with Prestwood IT where he develops custom Windows software and custom websites. When Dan is not coding for clients, he participates in this online community. Coding specialties include Paradox/ObjectPAL, MS Access, Visual Basic, and VS.Net/VB.Net.

Post ID #10920 (Level 1.4) Reply to 10916

Reply Posted 12/30/2004 9:47:00 AM

Location=Home office in Fresno, CA.

Joined=24 years ago MB Posts=401 KB Posts=12 KB Comments=4

Re: Charts and Graphs probs

12/30/2004 7:25:00 AM

Jon

Central California

I haven't tried that - the problem is that I do need grouping. I am showing all employees at one location - but the report has multiple locations. I know I could get around this by quering out the location and running several reports but would prefer not to if there is another way.

Posted 22 years ago (Thread Starter)

Comment

Quote

About Jon

Visit Profile

Approved member.

Member subscribes to this thread with a verified email.

About Jon

Post ID #10919 (Level 1.5) Reply to 10916

Reply Posted 12/30/2004 7:25:00 AM

Location=Central California

Joined=23 years ago MB Posts=32

Re: Charts and Graphs probs

12/30/2004 10:46:00 AM

Jon

Central California

I tried Montana's solution and it worked - just put it in the Report Header with the grouping. Doesnt seem right or necessary but it worked so I am not complaining. Big Grin!

But as far as the Data Model goes - it is just one table that is the result of a query. I have a Location, Score, Month, and Employee field. The report is grouped on Locations, with Score being the Y-Axis and Month being the X-Axis grouped on Employee (2D graph).

Posted 22 years ago (Thread Starter)

Comment

Quote

About Jon

Visit Profile

Approved member.

Member subscribes to this thread with a verified email.

About Jon

Post ID #10921 (Level 1.6) Reply to 10916

Reply Posted 12/30/2004 10:46:00 AM

Location=Central California

Joined=23 years ago MB Posts=32

Re: Charts and Graphs probs

1/3/2005 1:56:00 PM

Steve Caple

Steve Caple Company

Sacramento, CA

Originally posted by Jon:
I tried Montana's solution and it worked - just put it in the Report Header with the grouping. Doesnt seem right or necessary but it worked so I am not complaining. :)

Did you try putting it in the GROUP header, rather than page or report header?

Steve Caple
Programmer Analyst
Prestwood Software
http://www.prestwood.com

Posted 21 years ago

Comment

Quote

About Steve Caple

Visit Profile

Approved member.

Member subscribes to this thread with a verified email.

Old Account!

If this is your account, sign in to activate web presence data (sign in quarterly to keep active). Alternatively, you can subscribe to our monthly eMag with a valid email address.

Web Presence Hidden.

Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

About Steve Caple

Steve Caple I first saw Paradox in 1985 when a guy named Rick Albers came to demo Ansa's new 1.1 release to the Sacramento PC Users Group. The feeling was like going from WordStar to WordPerfect 3.0, a sense of freedom and power.

A long time dBase user had an evaluation copy he let me use for a few weeks. Going from dBase to Paradox was like finding yourself walking WITHOUT your shoe laces tied together. I was hooked; within a week I wrote my first useful Paradox DOS program. It took a few evenings to put together a script to generate a Basic Bulk Mail sort, using a series of Paradox queries against a bicycle club Century ride mailing list. It then used PAL to send text to the printer, printing it out in 5 digit Zip, three digit Zip, and miscellaneous by state groups, including group header labels and spacers on one-across stock - just tear it apart at the headers and give it to the mailing volunteers, and a job that used to take 20 people 4 or 5 hours could be done by 5 or 6 in a single hour.

Later, Paradox for Windows version 5 added many needed structural and indexing and linking features, and as hardware caught up with the needs of a GUI environment it became a powerful database for small companies and divisions or branches within large corporations. Despite some years of no real changes it remains one of the best products for that purpose.

Post ID #10926 (Level 1.7) Reply to 10916

Reply Posted 1/3/2005 1:56:00 PM

Location=Sacramento, CA

Joined=22 years ago MB Posts=71 KB Posts=3