Expert needed because this is something most people never would have a need for:
In the "on open" event code of a report, I have accumulated a bunch of items in an array that need to be printed, each array row on one detail line.
Naturally, if I were to create a temporary table from the array and make it the recordsource of the report, it would print.
What I'd prefer to do is to create some code for the On Format Event that fills in unbound controls in the detail band and then prints it. This works for the first array row, but since there's no file or query connected with the report, it doesn't put out multiple detail lines. Consequently it doesn't allow me to display the results from around 60 array rows.
So my question for an expert is whether there's a way to trick the report into repeating the detail On Format event VIA CODE so I can get my counters printed without having to turn them into a table.
Any hot suggestions? I hope you folks like a challenge once in a while(!)
-----------
Background info: there are about 60 possible medical conditions for around 10,000 patients in this report. I count how many occurrences for each condition (a) in the overall population and (b) at a particular hospital. By processing the data as I have chosen to do, I can get accumulate the numbers (120 counters) in a single pass of the 10K record file (takes about one second). The queries to get this info aggregated for me, by hospital and overall, for all 60 conditions would be really slow.
I'm only mentioning this because I fear someone will ask "why are you trying to do this? give up and do something else" and I'm supplying the pre-answer for you.
This is a subreport, the most complex one of 10. The others are easier and work fine. On the home stretch...
In the "on open" event code of a report, I have accumulated a bunch of items in an array that need to be printed, each array row on one detail line.
Naturally, if I were to create a temporary table from the array and make it the recordsource of the report, it would print.
What I'd prefer to do is to create some code for the On Format Event that fills in unbound controls in the detail band and then prints it. This works for the first array row, but since there's no file or query connected with the report, it doesn't put out multiple detail lines. Consequently it doesn't allow me to display the results from around 60 array rows.
So my question for an expert is whether there's a way to trick the report into repeating the detail On Format event VIA CODE so I can get my counters printed without having to turn them into a table.
Any hot suggestions? I hope you folks like a challenge once in a while(!)
-----------
Background info: there are about 60 possible medical conditions for around 10,000 patients in this report. I count how many occurrences for each condition (a) in the overall population and (b) at a particular hospital. By processing the data as I have chosen to do, I can get accumulate the numbers (120 counters) in a single pass of the 10K record file (takes about one second). The queries to get this info aggregated for me, by hospital and overall, for all 60 conditions would be really slow.
I'm only mentioning this because I fear someone will ask "why are you trying to do this? give up and do something else" and I'm supplying the pre-answer for you.
This is a subreport, the most complex one of 10. The others are easier and work fine. On the home stretch...
