Daily Reports

[Stonelynk]

I want to produce a daily report from a database which my pivot tables extract filtered data from but present it in a modified layout to the normal Pivot table, is this possible?

 

[taigovinda]

What do you mean? ...Maybe with a little elaboration on what you are trying to do, someone can help.

 

[Stonelynk]

Yes your right , not enough detail. I want to produce a update report on Service tasks which details what work has been completed during the day (Text) along with some details, time stamp on update entries, user ids etc.

I don't believe I can display Text in a data area of the pivot table therefore I may need to import data in Access and compile report that way.

 

[taigovinda]

You're right, pivot table values will only show numeric values. But I still don't understand what you're doing well enough to stand a chance of helping ...and not sure how Access could represent text better than Excel can.

From the data you described, it sounds like everything would go in the rows/columns except perhaps for the quantity of each task completed. If I'm visualizing it right (and if you have a limited number of possible tasks) then maybe put the users in rows, task descriptions in columns and quantity of task in values, with date in the page field. Then one can see at a glance who did what for a day, and can drill into a number to see the time stamps, etc... Still comes down to what you're trying to do and why Excel won't do it for you, that's when you can get some real help

Tai

 

[Stonelynk]

Thanks for spending the time on this issue. Each task that is generated by customers is given a unquiue number and hold a free text text area to report the fault. Operatives then work on the issues and create updates against each Task number, there can be a number of updates posted against each task over a period of time.

I woant to produce a summary of the Text entries against eack task no created during a specfic time period, by operative.

Some like;

TASK 123456 Status In Progress

27/4/11 I investigate the database structure all was found to be OK
27/4/11 Transfer issue to Network dept

TASK 45678 Status: Complete

27/4/11 Re-built database and tested.