Solved

Packages for Microsoft Access

Posted on 2011-03-09
12
407 Views
Last Modified: 2012-05-11
Is there any package that I can purchase for Microsoft Access so that I can have more flexibility with Pivot Charts within Reports
0
Comment
Question by:wilbur88
12 Comments
 
LVL 15

Expert Comment

by:Simon Ball
ID: 35093507
Not to my knowledge, and a quick google doesnt reveal anything specific.

Have you thought about Crystal reports, reporting services or web focus?

I think all of those can link to msaccess as a data source, (I know crystal can) and give you lots more control over your reporting, as they are specific reporting packages rather than a one system does a bit of everything solution e.g. access.

If you get a mircosoft developer license you can use visual studio ( from VS 2005 onwards i think) to develop crystal reports and there is loads of .net code for opening them in the .net crystal reports viewer, saving them as pdf, and emailing them to your clients or saving them on ftp / shared/ dropbox etc.

I have a report which has a massive array or parameters to make a huge pivot table based on an sql table, and using crystal is a whole new skill set, but much better for data display on reports.... And i wrote a vs project from online tutorials which opens either of two crystal report files, assigns parameters and displays the report on screen... with a button to save as pdf...Its suprising easy with the help of some good tutorial sites.
0
 
LVL 77

Expert Comment

by:peter57r
ID: 35093556
I think you need to be more specific about your requirements.

To me, 'flexibility ...  within reports'  is almost a contradiction in terms, given the fixed nature of a report.

0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 35095911
^
Yes, and "Flexibility" (Depending on what you are looking to do) will probably be different in Reports than it is for Pivot Charts. (There are two different Objects)
So you may be asking two separate questions here.

From my experience here, a lot of these requests stem form the fact that Pivot Charts and Reports are not really "Easy" for a novice to customize/manipulate.
For example, most requests for "Customizable" pivot charts can be created with a "Standard" chart.

So, ...specifics please...?

;-)

JeffCoachman

0
 

Author Comment

by:wilbur88
ID: 35099189
Thank you all very much for your reply,

By flexability I mean that I want to be able to put my data on the axis in whatever order that I want. I would like to have it in a spacific order rather than only having it in ascending order or in descending  order.

For example if my x-axis in a pivot chart reads 1, 2, 3, 4, 5, 6 is there a way to make it read 3, 2, 4, 1, 6, 5?

I also want to be able to control the coloring of a graph (like a bar) for any given category

Again thank you all so much
0
 
LVL 28

Expert Comment

by:burrcm
ID: 35107374
Pivots and graphs are best done in Excel, which can easily query Access data.

Chris B
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 35109705
You can do this in Access as well.

I won't have the time to look into this until next week.

So if burrcm can get you going with something in Excel in the mean time, then you can use that temporarily
0
Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 250 total points
ID: 35135136
<For example if my x-axis in a pivot chart reads 1, 2, 3, 4, 5, 6 is there a way to make it read 3, 2, 4, 1, 6, 5? >
Sure, but not "dynamically".
You will have to create a "Sort Order" field in the source and set your sort Order by that.

0
 

Author Closing Comment

by:wilbur88
ID: 35140568
I was looking for a little more of an explanation but thank you very much for your response
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 35141312
<I was looking for a little more of an explanation but thank you very much for your response>
Nobody here is in a rush.

If you want more info then just ask...
What is it that you would like more info on?
0
 

Author Comment

by:wilbur88
ID: 35141729
I wanted to know if I could change the coloring for the bars of the graphs itself or if I am stuck with that navy blue color? I also want to know what u mean by creating a sort order. And you are sure that there are no packages that I could purchase correct?  
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 35142231
<I wanted to know if I could change the coloring for the bars of the graphs itself>
Right click the bar and select "Properties"
Click the "border/Fill" tab
Under "Fill", click the icon for "Color"
;-)

<I also want to know what u mean by creating a sort order.>
Create a new filed in your table for the sort order (Priority Order or whatever you like), Then use this Priority Order field as the field to sort by .
Something like this:
PrimaryKey,Priority
1,7
2,10
3,2
4,4
5,8
6,5
7,1
8,3
9,9
10,6
Now, if you sort the Pivot Chart Source by the "Priority" field, ...ID 7 will be first, ID 3 will be second and so on...

<And you are sure that there are no packages that I could purchase correct?  >
Am I sure that some developer in Azerbaijan did not create something that does this?
No.
;-)

All I am saying is that with my experience with working with Access since before Pivots were introduced, I don't know of any utility(s) that will do what you are asking for,  specifically in MS Access.

;-)

JeffCoachman
0
 

Author Comment

by:wilbur88
ID: 35160096
ok thanks so much for your help
:)
0

Featured Post

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Join & Write a Comment

When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

758 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now