By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,940 Members | 614 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,940 IT Pros & Developers. It's quick & easy.

Graphical Report Examples?

P: n/a
I've got this little app that tracks metadata from about a dozen different
systems and feeds.

Seems to have all the mapping info that's needed to follow a data element from
one place to another...and I've put together a couple of reports that do that.

Problem is that, so far, the reports aren't real easy to look at...or for the
user to understand...

Seems like this begs for a graphical presentation - something where I put an
object representing the DB of reference in the center of a page, then draw
objects representing varous sources/feeds/destinations around it and connect
them with arrows.

But I haven't got a clue.....

Anybody know of some sample code that does something like this? The MS code
behind the "Relationships" report would probably be the kind of thing I'm trying
to do.
--
PeteCresswell
Nov 13 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
Pete,

Have you looked at the org chart in Excel to see if that will work for you?

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"(Pete Cresswell)" <x@y.z> wrote in message
news:63********************************@4ax.com...
I've got this little app that tracks metadata from about a dozen different
systems and feeds.

Seems to have all the mapping info that's needed to follow a data element from
one place to another...and I've put together a couple of reports that do that.

Problem is that, so far, the reports aren't real easy to look at...or for the
user to understand...

Seems like this begs for a graphical presentation - something where I put an
object representing the DB of reference in the center of a page, then draw
objects representing varous sources/feeds/destinations around it and connect
them with arrows.

But I haven't got a clue.....

Anybody know of some sample code that does something like this? The MS code
behind the "Relationships" report would probably be the kind of thing I'm trying to do.
--
PeteCresswell

Nov 13 '05 #2

P: n/a
DFS
(Pete Cresswell) wrote:
I've got this little app that tracks metadata from about a dozen
different systems and feeds.

Seems to have all the mapping info that's needed to follow a data
element from one place to another...and I've put together a couple of
reports that do that.

Problem is that, so far, the reports aren't real easy to look at...or
for the user to understand...

Seems like this begs for a graphical presentation - something where I
put an object representing the DB of reference in the center of a
page, then draw objects representing varous
sources/feeds/destinations around it and connect them with arrows.

But I haven't got a clue.....
Unless it needs to be updated dynamically based on the various feeds, you
could draw a Visio chart and just cut and paste it into the Access report as
a fixed object.

Heck, Visio has VBA embedded in it - you can probably drop a Visio diagram
into an Access report and manipulate the diagram programmatically. Check
here.

http://www.mvps.org/visio/VBA.htm
Anybody know of some sample code that does something like this? The
MS code behind the "Relationships" report would probably be the kind
of thing I'm trying to do.


Nov 13 '05 #3

P: n/a
> Have you looked at the org chart in Excel to see if that will work for you?

No. Will do. Thanks...

(DFS, the data is dynamic)
Nov 13 '05 #4

P: n/a
Pete,

See if any of this is of any use --

Steve
PC Datasheet

Borders, Circles and Lines in a Report

Access has Line and Rectangle tools you can use to create simple graphic effects
on reports (and you can also make text box and label borders visible, as I did
for the Year text box in the Books by Year report). However, you can also create
special graphic effects by using a set of antiquated DOS methods, functions and
properties that have been carried over into Access VBA. Be warned: these
techniques are not easy to use, and some of them can be excruciatingly slow in
operation (though if you have a fast computer, that won't be so problematic). I
won't go into detail about using the DOS print techniques; refer to Access Help
topics for the Line and Circle method for details (possibly more details than
you want), and some examples of usage.

Vertical Line Next To A Textbox

If you want a vertical line next to a textbox with its CanGrow property set to
Yes, and you want that line to be the same height as the text box, you can use
the Line method and the RGB function (together with some of the more obscure
report properties) to achieve this result. The code below runs from the Print
event of the report's Detail section, and the figure shows the report with the
green line next to a txtNotes text box which has expanded because it contains a
large amount of text.

Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer)

Dim sngTop As Single

Dim sngLeft As Single

Dim sngHeight As Single

Dim sngBottom As Single

sngTop = Me![txtNotes].Top

sngHeight = Me![txtNotes].Height

sngLeft = 2300

sngBottom = sngTop + Me![txtNotes].Height

Me.DrawStyle = 6

Me.DrawWidth = 12

Me.Line (sngLeft, sngTop)-(sngLeft, _

sngBottom), RGB(0, 255, 0)

End Sub

Circle

The Circle method is the only way you can draw a circle, arc or ellipse on an
Access report (unless you want to create it in Paintbrush and place it in an
Image control). The sample code below, running from the report's Page event
procedure, draws a red quarter-circle (which could possibly be used as a logo)
on a report:

Private Sub Report_Page()

Me.DrawWidth = 500

Me.Circle (25, 25), 2000, 255

End Sub

Border

A final DOS print effect is to place a border around the entire report page, as
in the code below, which also runs from the report's Page event procedure:

Private Sub Report_Page()

Me.Line (1, 1)-(Me.ScaleWidth, Me.ScaleHeight), , B

End Sub

"PeteCresswell" <Go**********@FatBelly.com> wrote in message
news:74**************************@posting.google.c om...
Have you looked at the org chart in Excel to see if that will work for you?


No. Will do. Thanks...

(DFS, the data is dynamic)

Nov 13 '05 #5

P: n/a
RE/
(DFS, the data is dynamic)


.... and we're talking about 17,000 separate fields in the app's current data
load.
--
PeteCresswell
Nov 13 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.