Daily Reports

Stonelynk

New Member
Joined
Oct 18, 2010
Messages
17
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?
 

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().
What do you mean? ...Maybe with a little elaboration on what you are trying to do, someone can help.
 
Upvote 0
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.
 
Upvote 0
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
 
Upvote 0
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.
 
Upvote 0

Forum statistics

Threads
1,224,502
Messages
6,179,126
Members
452,890
Latest member
Nikhil Ramesh

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top