I have a report that when it opens it gets the data based on a SQL Statement. I allow the user to set the parameters that are updated to the query each time they call the report via a cmdButton. Here’s the problem, I have 15 row headers with 3 columns of data. Each dataset is based on a different timeframe.
For Example:
Jan ’02 Feb ’02 Mar ’02
Grp A 10 15 20
Grp B 15 20 25
Grp C 20 25 30
I have triedusing labels in the Report Open code but I end up getting the last record although I have the looping to go through each 15 records. Do I need to place 15 labels or am I just missing something in the logic?
Thx for any help you can provide.
CLM