I have a form with a subreport built into it. Here is the picture. (mind you that I am using Tab Controls for the entire Database, but referencing controls isn't an issue)
The command button refreshes the entire database and then makes the control that governs the report visible. I've employed this method before (not with crosstabs) and it works. For the sake of this, this was already set to visible.
As you can see, the report is built off of a crosstab query with 3 parameters (OE, Year, Quarter).
Here is an example of how I have my Query set-up in design view for one particular parameter (OE).
With this set-up, when I open my Crosstab query, I am prompted to input a parameter and the query runs smoothly.
However, now if I go back to my particular form, nothing gets displayed. As you can see.
I would think that you should be able to now select your particular parameters (or at least be prompted for one, of which i am not) and then the report should open accordingly when I refresh and make visible. But nothing shows up, the report itself dosen't show up.
Any thoughts?