Dynamic Report?

pdavis41

New member
Local time
Today, 11:32
Joined
Oct 4, 2004
Messages
8
I am trying to create a very custom report for a accounting program I am working on, and I am having great difficulties.

The report needs to look like this:

Reciept Date Payee PO Number Reciept Total Account Acccount Account Account.....

As you can see it is breaking reciepts down into the amount spent for each expense account.

Each line in the data base looks like this:
Reciept ID Quanity Description Account UnitPrice

I then do a cross tab query to get all the data into a line format with each account that has a expense in it accross the top (colums). This is where I start to run into some trouble.

I run a second query on the cross tab query to sum each account for each recipet. If a new account is added for a new reciept this second query does not get the new colum because it is not in the query. I then build a report off of this query.

What I need is a report that will change for each time I run it. It must be able to add or delete accounts from the report so that it looks neet and there are no blank accounts.

If you have any ideas on how to do this or if you need more info from me please let me know.
 
I have started playing around with the samples9.mdb and have set up the code for the dynamic cross tab report.

I guess the major problem I'm having is that the cross tab is not looking the way i want it to. I want one line to appear per recipet but I am getting the number of lines that there are detail entryies for. I am attaching a copy of what I have so far.

Please let me know what you all think.
 

Attachments

I've solved half of my problem. I have got the query to do what I want. It is now updating with each new reciept and totaling everything on one line per reciept.

I still havent gotten the report to display the data right. I took the code from the sample but it is only displaying empty boxes. It is showing the number rows that there is data but just no data.

So I will keep working on it tonight but if you have any ideas as to why it is doing this please let me know.

Thanks
 

Attachments

GOT IT!!!!

The problem with the report was that the names of the sections were wrong...
For example the header section of code was
Private Sub PageHeader1_Format(Cancel As Integer, FormatCount As Integer)
This was causing the header not to be formated because it was not named PaterHeader1.

I will post the final report for people to referance.
 

Attachments

Users who are viewing this thread

Back
Top Bottom