Crosstab Report built on the fly

[lemon_balm]

Good Afternoon All

I have finally managed to create a report that builds on the fly to correlate all my data into a summary.

However, for some reason, the detail section of my report only throws one line instead of moving on through the recordset.
Also, (probably due to the above problem) the figures within the summary section itself do not display correctly.
Can someone please have a look and see if they can spot where I went wrong.
The file is attached and is in Access 97 format.

Regards

Jason

 

[lemon_balm]

Another day, another dollar?

Well, I've spent the entire day trying to revise the code for this and cannot figure out where the issue is.

I want to say that the problem lies with either a property in the detail section of the report or within one of the event procedures pertaining to it.

Unfortunately, I cannot prove this.

THe headers and footers work fine but the detail section does not give more than 1 row. WHY??????????????????????????????????????????????/

Please can someone have a look for me. I'm going for a drink.

Good weekend to all

Regards

Jason

 

[lemon_balm]

What I need to do (Final Push)

Ok,

I need to deliver this system on Monday morning, whether the crosstab works or not.
FOr now I have created an Excel Output to show the data but I want this to only be a temporary fix.
I have attached pics of what I recieve for both the report and the excel output.
I have created this using the solutions.mdb crosstab designs.
Does anyone have any ideas.
If it would help, I can post a copy of the database for perusal.
Regards
Jason

 

[lemon_balm]

Sorry to bring this back to the top but I am really struggling. The issue is still the same, when a crosstab is generated, it displays multiple items but they are all the same and the figures are all wrong. Can someone please have a look at the coding for me and get back to me. I can't be far off now.

Sample database posted on the first post of this thread

Regards

Jason