Go Back   Access World Forums > Microsoft Access Discussion > Reports

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 11-08-2019, 06:42 AM   #1
aattas
Newly Registered User
 
Join Date: Dec 2014
Posts: 60
Thanks: 12
Thanked 0 Times in 0 Posts
aattas is on a distinguished road
Chart from crosstab

Experts
I have created a crosstab type of query. and I have created from it a report. wthin the report i created extra unbound fields with sum functions and division function.
next i wanted to created a chart to display the results from the unbound fields and no results. anybody tried the same and succeed . Help

aattas is offline   Reply With Quote
Old 11-08-2019, 08:30 AM   #2
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 6,590
Thanks: 58
Thanked 1,444 Times in 1,425 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: Chart from crosstab

Hi. I could be wrong, but maybe charts need a data source bound to a table or query to work. Have you tried using a query to do your sum and division functions and maybe you can use that query for your chart?
__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is online now   Reply With Quote
Old 11-08-2019, 08:42 AM   #3
aattas
Newly Registered User
 
Join Date: Dec 2014
Posts: 60
Thanks: 12
Thanked 0 Times in 0 Posts
aattas is on a distinguished road
Re: Chart from crosstab

Thankyou for your prompt reply. I appreciate it very much. As a matter of fact, yes I tried to do the sum and division in the query, but because of its is crosstab nature, the report is not seeing it as a data or value. Everytime i tried the sum and div in query I get the message not aggregate or something. The result of sum and div only appears in the report .
Any suggestions will he appreciated.

aattas is offline   Reply With Quote
Old 11-08-2019, 08:48 AM   #4
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 6,590
Thanks: 58
Thanked 1,444 Times in 1,425 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: Chart from crosstab

I'm pretty sure we can help you figure it out. Can you show us what you have? Thanks.
__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is online now   Reply With Quote
Old 11-08-2019, 10:16 AM   #5
isladogs
High Noon Moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 11,326
Thanks: 115
Thanked 3,101 Times in 2,819 Posts
isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold
Re: Chart from crosstab

Depending on what you are trying to sum and divide, you may need to do that from the original query. Possibly use DSum for the first of these.

However you should be able to do that in a group footer section of your report.
I regularly do that on crosstab reports for sum, count, max, average etc

Its certainly possible to create charts for crosstab queries
__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Colin (Mendip Data Systems)
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Website links:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Common sense and a sense of humour are the same thing, moving at different speeds. (Clive James - RIP)
isladogs is offline   Reply With Quote
Old 11-09-2019, 09:39 AM   #6
aattas
Newly Registered User
 
Join Date: Dec 2014
Posts: 60
Thanks: 12
Thanked 0 Times in 0 Posts
aattas is on a distinguished road
Re: Chart from crosstab

DBguy, what can I send you. Thanks.

Isladog. I never tried the Dsum. Can I have see example that I can replicate with my data.
The chart that I'm trying is in the footer.

Thanks very much
aattas is offline   Reply With Quote
Old 11-09-2019, 09:45 AM   #7
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 6,590
Thanks: 58
Thanked 1,444 Times in 1,425 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: Chart from crosstab

Can you post a sample copy of your db with test data?

__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is online now   Reply With Quote
Old 11-09-2019, 09:55 AM   #8
isladogs
High Noon Moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 11,326
Thanks: 115
Thanked 3,101 Times in 2,819 Posts
isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold
Re: Chart from crosstab

Quote:
Originally Posted by aattas View Post
Isladog. I never tried the Dsum. Can I have see example that I can replicate with my data.
The chart that I'm trying is in the footer.

Thanks very much
There's a crosstab report with sums for each column in this example database
https://www.access-programmers.co.uk...d.php?t=294548

That uses SUM rather than DSum. As we don't yet know your data, its hard to know which will work for you.

There are various screenshots of charts, some of which are based on crosstabs on my website. For example http://www.mendipdatasystems.co.uk/s...ser/4584605482

Hope that helps

__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Colin (Mendip Data Systems)
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Website links:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Common sense and a sense of humour are the same thing, moving at different speeds. (Clive James - RIP)
isladogs is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Question crosstab query to chart, unrecognized field john33john3 General 11 07-26-2015 06:48 PM
Excel Chart - Macro to globally change multiple chart titles? parodytx Excel 1 04-30-2011 06:54 AM
Crosstab Chart damian Modules & VBA 2 04-05-2011 05:40 AM
Bar chart Line/bars from crosstab HELP Singlespeed Reports 1 06-19-2009 03:02 AM
Chart Wizard from a crosstab query? chris.mo Forms 1 11-24-2001 02:13 PM




All times are GMT -8. The time now is 05:58 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World