trouble with reports

[XKIMBAL]

I am trying to create a report that groups by serial number and has dates across the top for a week (user input here). The report I want looks like a crosstab query, any dates that the serial number has had no sales is left blank and dates with info will populate. I have to have all 5 days on the report though.

Please help me...

 

[Sohaila Taravati]

Make subreports out of each of your 5 dates and put them on the report. I have done the same thing and for each of my subreports, I only show one day for instance, Monday and you don't have to link your report either. I hope this helps.

 

[XKIMBAL]

Im sorry I should have mentioned that each different type of sale I have for the serial number needs its own total count for each day and then at the end of the week too. This is a really rough assignment and I could use the help...

The reports supposed to look like this:

SALES 6/24/02 6/25/02 6/26/02 WTD
Mon Tues Wed
Manual (01) 1 1 2
Cd-Rom (10) 0 2 2
Crossale (15) 1 0 1

TOTAL SALES 0 2 3

I can get the report look nothing like this and there's a total of 3 different types of groups that I have to put together like this all of the same page. (SALES, REFUSALS, UNWORKABLES) each with their own grid. How is the best way to go about doing this?

Thanx...

 

[XKIMBAL]

In the previous example ...

The column of MON should be null and the last column of Numbers is under the WTD column.. sorry

 

[Sohaila Taravati]

I am just curious to know if you are using croostab query to get the information. You said in your first email that your report looks like crosstab. If that is the case, you should create a crosstab query first and run your report based on the crosstab. Then you would be more flexable as far as grouping and setting up your report.