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!

  • Congratulations Westi 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. jherold1

    Linking two fields with different naming conventions

    Thank you for your response! Yes the user/pass combinations are identical. I did try what you suggest, and for most it returns the expected value, however, for resources with no hours data it pulls a blank. This is what I figured as well... it is trying to split a blank value and gives an...
  2. jherold1

    Linking two fields with different naming conventions

    Hi all, I have a solution that is working in Crystal, but when I upload it to BOE schedule it I get an Array error, that the subcript has to be between 1 and the size of the array. What I have is a report pulling a name from one source and comparing it to the name of another source to get...
  3. jherold1

    Select Records based on multiple conditions

    Thanks for your responses! For the future reference of others, this is a solution I found that returns what I was looking for. I will try your solution as well lbass, as the performance on my solution is fairly poor. I put this query as the data source(oracle db): Select x.* from [table] X...
  4. jherold1

    Select Records based on multiple conditions

    No, I want all hours for all resources who have any support hours. That inclues admin and support hours. So something like If resouces has any support hours then select proj,admin, and support hours else ignore Does that make more sense? This is more about the data selection than the graph
  5. jherold1

    Select Records based on multiple conditions

    thanks for replying! maybe i didn't explain this well. we have these fields resc_nm (resource name) to_dt_hrs (hours to date) proj_nm (project name) so in the database we could have ted 10 support ted 15 admin ted 5 project rita 4 admin rita 10 project bob 30 support...
  6. jherold1

    Select Records based on multiple conditions

    All, I am having a problem creating the follow selection criteria... any help greatly appreciated. CR XI R2, oracle database, data is time tracking. What I'm looking for is a graph that is filtered down only to resources that have >50 hours to date in support. It's a stacked percentage graph...
  7. jherold1

    Summing Across Groups

    To elaborate, first off im using Version XI I have created a group "Selected" above district and made a formula to separate them... If {?District}={HPD.District} Then "RegionSelected" else "OtherRegions" I then tried to insert a chart that shows teh value instances per month on change of...
  8. jherold1

    Summing Across Groups

    I am trying to create a report that will show average tickets per user by region against the over-all average tickets per user. What I have is this Group #1 Region Group #2 Date Group #3 Product Group #4 User In Group #2 I have a line chart that shows average resolution by...

Part and Inventory Search

Back
Top