Dump? Report Builder?

Yahoo Archive
1
Do you have different shifts in data collection for different lunch hours?
Then you could run your report off of laborhed and show the shift with the
scheduled lunch and no heartburn over excel.

Just an idea.

Lydia

IS Administrator
Canyon Engineering Products
661-294-0084 x115



-----Original Message-----
From: James Piper [mailto:admin@...]
Sent: Monday, July 14, 2003 9:58 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Dump? Report Builder?


Suggestions please
Our receptionist (Who has no computer - don't go there)
Needs a report of current employees and their lunch schedules

How can I get either excel or report builder to know that if its a code
of 11 to print out 11:00 - 11:30?
I need to list the employee name and their appropriate lunch time
An excel dump would work then I can take it from there

We have several different lunges
If I do a dump to excel fine
But the schedule are like schedule 11 - 11:00 - 11:30
12 - 11:30 -
12:00
etc


Any help would be appreciated



J.P.
2
Suggestions please
Our receptionist (Who has no computer - don't go there)
Needs a report of current employees and their lunch schedules

How can I get either excel or report builder to know that if its a code
of 11 to print out 11:00 - 11:30?
I need to list the employee name and their appropriate lunch time
An excel dump would work then I can take it from there

We have several different lunges
If I do a dump to excel fine
But the schedule are like schedule 11 - 11:00 - 11:30
12 - 11:30 -
12:00
etc


Any help would be appreciated



J.P.



[Non-text portions of this message have been removed]
3
If the format is always the same (that is, if the last 13 characters
represent the lunch range you want to display), you can add a new column in
excel and parse out the data you want. In the new column, the equation
would be "=RIGHT(C25,13)" where C25 is the cell location of the full
description.



[Non-text portions of this message have been removed]