Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. urbanhim

    HR Hierachy report in Excel

    I shall give what you have suggested a go, it might be a good option, so thanks for your post! UrbanHim Data Analyst London [shadeshappy] What's good for a hangover?... Heavy drinking the night before!!
  2. urbanhim

    HR Hierachy report in Excel

    I want something to show Hierarchy, where you can see who reports into who, to build like a tree, organisation chart type thing, in my original post I said "I want something like this" the word "something" suggests that what I posted was merely an example of what I wanted! Preferably I would...
  3. urbanhim

    HR Hierachy report in Excel

    You have a soloution!? That is fantastic! I look forward to your post, thank you! And yes, how you've posted is exactly what I want, so from your example, we can see that Biddy Small reports into Paul Underearth, Paul himself reports into Ave Garnet and Ave reports into Paul Robinson! Only...
  4. urbanhim

    HR Hierachy report in Excel

    I don't have any VBA programming experience, but i'm really glad that you have mentioned that its not something that can be done in Excel directly - I have spent the past four nights laying awake thinking of possibilties before posting this question on here! If it cannot be done without some...
  5. urbanhim

    HR Hierachy report in Excel

    Hi, i'm hoping someone can help with a query I have... I am trying to build a Human Resources Hierachy report - Basically the report has staff names, details such as cost code, and department etc etc, and also their line manager. What I need to do is show a drill-down, starting at the top...
  6. urbanhim

    Formula to trim name form Email address field

    Thanks for that, very useful too! At some point we want to get firstname and surname so your formula will be very useful for that! Cheers! UrbanHim Crystal XI Report Writer London [shadeshappy] What's good for a hangover?... Heavy drinking the night before!!
  7. urbanhim

    Formula to trim name form Email address field

    Very nice too! Even the sun can't lift the grime off of South London which is where our office is based! Very depressing, and you can bet your bottom dollar that come the weekend, it will be raining! ;-) UrbanHim Crystal XI Report Writer London [shadeshappy] What's good for a hangover...
  8. urbanhim

    Formula to trim name form Email address field

    Blimey, that was quick! Thanks so much, has worked a treat! UrbanHim Crystal XI Report Writer London [shadeshappy] What's good for a hangover?... Heavy drinking the night before!!
  9. urbanhim

    Formula to trim name form Email address field

    Hi, i've done a search, i'm sure its on here but have spent a while looking but cant find anything. I have an email field, which i need to trim to show only before the "@" : So for example: my_name@domain.com should return just: my_name Thank you UrbanHim Crystal XI Report Writer London...
  10. urbanhim

    Convert Milliseconds to HH:MM:SS

    In our Oracle database we capture the time our website takes to complete an order (the automated process between when a client clicks "SUBMIT ORDER" to when the screen refreshes saying "ORDER COMPLETED" etc - anyway, this time is recorded in Milliseconds. I need two new formula fields...
  11. urbanhim

    Need to create a simple Average per month formula

    Mmm... Not a bad idea at all! Thanks UrbanHim Crystal XI Report Writer London [shadeshappy] What's good for a hangover?... Heavy drinking the night before!!
  12. urbanhim

    Need to create a simple Average per month formula

    The average of 4232 isnt the actual figure, I just typed that in, but how I would like to get to that figure is by simply calculating the average per day for each unique client, regardless of whether its a Info or News view. To clarify, the Total Unique is not a sum of the two averages, because...
  13. urbanhim

    Need to create a simple Average per month formula

    Brilliant... I dont know what its doing, or how it works but it does and im very grateful! Is there anyway I can get total average per day in the same report regardless of view type. I can do this in a seperate report, by deleting the Type Group 1, and just having a Group on date, and then...
  14. urbanhim

    Need to create a simple Average per month formula

    Everytime one of our clients reads a news or info article on our website, an entry is added against their account ID for that date for either "Info" or "News". So I have a table with just three fields in it: Date Type (either "News" or "Info" Account_ID I have two groups, group1 on Type and...
  15. urbanhim

    Date range selection criteria formula for specified period

    This formula is spectacular!! It works a treat, thank you so much! Its brilliant!! UrbanHim Crystal XI Report Writer London [shadeshappy] What's good for a hangover?... Heavy drinking the night before!!
  16. urbanhim

    Parameter to show chosen or records or ALL if need be?

    LBass - I simply copied your formula into my Select Expert, hit refresh... and bang... PERFECT!! This done what ive been trying to do myself for weeks! I love the simplification of it too, makes much more sense! Very much appreciated! Thank you! UrbanHim Crystal XI Report Writer London...
  17. urbanhim

    Parameter to show chosen or records or ALL if need be?

    Hi, i'm hoping someone can help... ive seen similar posts on here but having gone through responses, still cant get this to work. I have a report with four parameter's in it... ?View Type - Picklist ?Exchange - Picklist ?Site Type - Picklist ?Account ID - Type in (over 500k entries) What I am...
  18. urbanhim

    Add a basic count field to my report.

    Ive gone with this approach... Ive created a formula for Hour: @Hour hour({ORDER_HISTORY.MODIFIED_DATE}) And then grouped on that field. I have then created my average formula: @Average Count ({ORDER_HISTORY.ORDER_HISTORY_ID},{@Hour})/60 And dropped that into the group line. I can now add...
  19. urbanhim

    Add a basic count field to my report.

    Yes sorry, I was hoping that I could show an average along multiple timescales in various charts. I know from the chart expert I can pick whether to show Hour, Minute, AM/PM etc, I wanted to do that on multiple charts showing average orders (ie, average per hour, average per minute, average per...
  20. urbanhim

    Add a basic count field to my report.

    I was thinking that if i added a count field which worked like this: TIMESTAMP ORDER_HISTORY_ID @COUNT 10:04:31 45678 1 10:04:33 45679 2 10:06:12 45680 3 I have a Sum field which shows total of...

Part and Inventory Search

Back
Top