McSwifty
Registered User.
- Local time
- Today, 11:37
- Joined
- Jan 14, 2010
- Messages
- 67
Hi peoples....
I am trying to modify the idea presented here ( http://allenbrowne.com/ser-62.html) to be able to have a pivot chart in the form footer (as a subform). The footer is made invisible until the search button is clicked then it show up and should show only the data required.
I am using the search forms to look through certain information in my db.
eg. Name, area of work, hours of work etc.
I want to be able to graph the infomration based on the options chosen in the search boxes in the headr of detail of the form.
After clicking the search button I then run through a few
strwhere = strwhere & "[rest of search string goes here]"
sort of things, one for each search option. Then add on a few other details on the end. ie. group by, having.....that sort of thing.
Basically I have created an SQL source for the pivot chart.
My problem is not the SQL coding, it works great. My probelm is the pivot chart.
When it updates I get not data as the category and data info has been reset.
Is there a way to programatically have the category and data info go back onto the pivot chart? This is the only area I am having issue with as I have not really used them and I have tried google and the forum search with not help in this case. I have thought maybe I should just build a chart from scratch, but I get lost in the code on where the category and data gets put on the page.
Thanks in advance for any help that can be offered.
My db is at work and I cannot bring it home due to workplace policies. Also unfortunately due to nature of actual data cannot currently give real example of what is being worked on (sorry).
I am trying to modify the idea presented here ( http://allenbrowne.com/ser-62.html) to be able to have a pivot chart in the form footer (as a subform). The footer is made invisible until the search button is clicked then it show up and should show only the data required.
I am using the search forms to look through certain information in my db.
eg. Name, area of work, hours of work etc.
I want to be able to graph the infomration based on the options chosen in the search boxes in the headr of detail of the form.
After clicking the search button I then run through a few
strwhere = strwhere & "[rest of search string goes here]"
sort of things, one for each search option. Then add on a few other details on the end. ie. group by, having.....that sort of thing.
Basically I have created an SQL source for the pivot chart.
My problem is not the SQL coding, it works great. My probelm is the pivot chart.
When it updates I get not data as the category and data info has been reset.
Is there a way to programatically have the category and data info go back onto the pivot chart? This is the only area I am having issue with as I have not really used them and I have tried google and the forum search with not help in this case. I have thought maybe I should just build a chart from scratch, but I get lost in the code on where the category and data gets put on the page.
Thanks in advance for any help that can be offered.
My db is at work and I cannot bring it home due to workplace policies. Also unfortunately due to nature of actual data cannot currently give real example of what is being worked on (sorry).
