H
H0MELY
Thank you in advance for looking. Basically I have been asked to create
re-occuring reports based upon data in a SQl server. I am using ODBC to go
out and grab the high level data that I want (the ODBC connection is SOO
SLOW). Once the data is captured the next step of preparing useful reports
takes place. The problem is that teh users requesting data really have
ABSOLUTELY no idea what it is that they want to get out of the data. After a
week of constant rush requests (they would change requirements and then
expect a nearly immediate reply) I have decided that I don't want to play the
game anymore.
It is easy enough to get at the data that they are requesting, the problem
is that there are about 15 fields each with about 10 to 20 different options
that they keep changing. Because they do not know how to prepare the
queries, the task falls to me.
I am thinking that I would like to just create tool that goes out and grabs
the data and then presents them with a form made up of option groups and
check boxes. They would select the options they want (could be any number
from any of the groups) and then they would click a button and a query would
run with the criteria set to teh check boxes that were selected. That way
they could actually play with the data and look for what they want without
me...I guess I would think of this as an advanced filter.
Problem for me is that I have never used an option group with check boxes
before, let alone trying to choose simultaneous boxes from anoption group and
applying it as a criteria in a query. I am looking for an example. I am
sure once I see it done I will beable to duplicate the logic...is there
anyone ourt there that can point me in the direction of a tool that has
multiple option groups being the criteria for a query?
The next part (a dream maybe) would be check boxes that are dynamic to the
data...meaning that they would populate like a combo box being linked to a
grouping query. I have thought about using a listbox instead of
checkboxes...but I think asking the users to press shift while clicking on an
option may be more than they can handle.
Anyway...any assistance would be very welcome.
-John
re-occuring reports based upon data in a SQl server. I am using ODBC to go
out and grab the high level data that I want (the ODBC connection is SOO
SLOW). Once the data is captured the next step of preparing useful reports
takes place. The problem is that teh users requesting data really have
ABSOLUTELY no idea what it is that they want to get out of the data. After a
week of constant rush requests (they would change requirements and then
expect a nearly immediate reply) I have decided that I don't want to play the
game anymore.
It is easy enough to get at the data that they are requesting, the problem
is that there are about 15 fields each with about 10 to 20 different options
that they keep changing. Because they do not know how to prepare the
queries, the task falls to me.
I am thinking that I would like to just create tool that goes out and grabs
the data and then presents them with a form made up of option groups and
check boxes. They would select the options they want (could be any number
from any of the groups) and then they would click a button and a query would
run with the criteria set to teh check boxes that were selected. That way
they could actually play with the data and look for what they want without
me...I guess I would think of this as an advanced filter.
Problem for me is that I have never used an option group with check boxes
before, let alone trying to choose simultaneous boxes from anoption group and
applying it as a criteria in a query. I am looking for an example. I am
sure once I see it done I will beable to duplicate the logic...is there
anyone ourt there that can point me in the direction of a tool that has
multiple option groups being the criteria for a query?
The next part (a dream maybe) would be check boxes that are dynamic to the
data...meaning that they would populate like a combo box being linked to a
grouping query. I have thought about using a listbox instead of
checkboxes...but I think asking the users to press shift while clicking on an
option may be more than they can handle.
Anyway...any assistance would be very welcome.
-John