dynamic crosstab subreport problem

[Guest]

I created a dynamic crosstab report (from
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q328320). On its
own, it works perfectly. But my intention for this report is, as a
subreport. Upon embedding it into the main report, it no longer displays (in
print preview) the results. (i.e. subreport is blank). Help....please.

 

[Duane Hookom]

I don't care much for that particular solution. There are solutions at
http://www.invisibleinc.com/divFiles.cfm?divDivID=4 that might work out more
effectively.

 

[Guest]

unfortunately, these solutions are missing a key element that I require.
That is, both the main and subreport depend on a criteria(s):

"Forms!frmOTBRptByDate!txtStartDate"
"Forms!frmOTBRptByDate!txtEndDate"
"Forms!frmOTBRptByDate!cmbDept"
"Forms!frmOTBRptByDate!cmbClassID"

 

[Duane Hookom]

I guess I forgot to add those specific criteria. Sometimes you have to make
easy modifications existing solutions to make them fit.

 

[Guest]

....I don't know if this will bring light to my problem...

when I Debug, I noticed that when the code completes Report_Open() of the
subreport, it immediately closes the subreport i.e; Report_Close.

when I Debug the subreport as a normal report, when the code completes
Report_Open(), the next instructions it goes to is ---> ReportHeader_Format()
then ---> Detail_Format(). and the correct output is created.

Hope this helps....and thanks for taking the time you're spending with this
problem.

 

[Duane Hookom]

I doubt the code/solution you have chosen will work with a subreport. I
would try the solution I mentioned or not use a subreport.