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 Chriss Miller 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. wanzek

    Parameter for Sorting

    Thank you for the suggestion. I tried that on one of the fields with this formula: If IsNull({HRRM.udJobLocation}) or {HRRM.udJobLocation} = "" then '999' else {HRRM.udJobLocation} I think updated my sort formula to have: if {?Sort}='N' then {udDriverDatabase.FullName} else if...
  2. wanzek

    Parameter for Sorting

    I have a very strange thing occurring on my report. I have a parameter formula that is supposed to allow you to choose what you want to sort by: if {?Sort}='N' then {udDriverDatabase.FullName} else if {?Sort}='D' then {udDriverDatabase.DriverStatus} else if...
  3. wanzek

    Only Max Values of a group in a cross tab

    Which hid the values but now I have a large white space. Is there a way around the large gap?
  4. wanzek

    Only Max Values of a group in a cross tab

    You are correct. I was putting it in the surpress. I put this formula in the Display string.
  5. wanzek

    Only Max Values of a group in a cross tab

    I didn't get an error on the first formula but when I try the second I get: A boolean is required here.
  6. wanzek

    Only Max Values of a group in a cross tab

    Yes, it seems to be working correctly and it is much faster than it was. As for the top N I don't even see that as an option in the cross tab. I see Nth Largest, Nth Smallest and Nth most frequent.
  7. wanzek

    Only Max Values of a group in a cross tab

    What is a vertical display by week? The problem with a manual crosstab is I need it to be able to run for the life of a job and there isn't a maximum number of weeks that I could determine.
  8. wanzek

    Only Max Values of a group in a cross tab

    I was able to get this working but I am still unsure how to handle values when there are ties. You mentioned you might have a solution to that.
  9. wanzek

    Only Max Values of a group in a cross tab

    That didn't work but I switched it back to the left and it did: SELECT "JCCD"."Phase", "JCCD"."ActualHours", "JCCD"."ActualDate", "JCCD"."Employee", "JCCD"."CostType", "JCCD"."Job", "JCCD"."JCCo", ( select sum(a."ActualHours") from "JCCD" a where a."Employee" ="JCCD"."Employee" and a."Phase"...
  10. wanzek

    Only Max Values of a group in a cross tab

    I received an error: Failed to retrieve data from the database. Details: 42000:[Microsoft][ODBC SQL Server Driver]Syntax error or access violation.
  11. wanzek

    Only Max Values of a group in a cross tab

    Also, something I was wondering if what happens if something ties for first place as the max? How does it pick the one it shows? Is there a way to get all of the tops values?
  12. wanzek

    Only Max Values of a group in a cross tab

    ( select sum("ActualHours") from "JCCD" a where a.Employee ="JCCD"."Employee" and a.Phase = Left("JCCD"."Phase",2 ) and {fn WEEK(a.ActualDate)}={fn WEEK("JCCD"."ActualDate")} and {fn YEAR(a.ActualDate)}={fn YEAR("JCCD"."ActualDate")} )
  13. wanzek

    Only Max Values of a group in a cross tab

    I also forgot to mention that I am using Crystal Reports 2016
  14. wanzek

    Only Max Values of a group in a cross tab

    Here is the SQL Query: SELECT "HQCO"."Name", "JCCD"."JCCo", "JCCD"."Job", "JCCD"."PhaseGroup", "JCCD"."Phase", "JCCD"."CostType", "JCJP"."Description", "JCCD"."UM", "JCCD"."EstUnits", "JCCD"."ActualUnits", "JCCD"."EstHours", "JCCD"."ActualHours", "JCCD"."ActualDate", "JCJM"."Description"...
  15. wanzek

    Only Max Values of a group in a cross tab

    I did get it to work but it takes a really long time to run. I am trying to figure out what I can do to get it to speed up. It takes several hours to complete.
  16. wanzek

    Only Max Values of a group in a cross tab

    Thank you for the feedback! I am struggling getting my SQL expression to work but I will keep trying! ( select sum("JCCD"."ActualHours") from "JCCD" a where a.Employee ="JCCD"."Employee" and PhasePart = Left (ToText("JCCD"."Phase"),2 ) and {fn WEEK(a.`Date`)}={fn...
  17. wanzek

    Only Max Values of a group in a cross tab

    They would need to be a summed for each group for each employee.
  18. wanzek

    Only Max Values of a group in a cross tab

    I need to create a report that is a cross tab because it will have to automatically expand based on days entered. The columns will be the week ending date. The rows down will be the employees. I need the value under each column to be the max value label. So for example: Employee A Group A = 10...
  19. wanzek

    Cross-Tab

    Sorry! Somehow I submitted the post without everything and now when I try edit it doesn't work. This is the formula I am using: if {GLAC.udGLClassification}='Revenue' then {brvGLActtoBud.NetActivity}*-1 This works if the group row I am on in the cross tab is revenue. I need to be able to...
  20. wanzek

    Cross-Tab

    I have created an income statement of sorts using a cross tab. The user now wants the exact same thing but instead of a value they want each field to be the percentage of revenue. Is there a way to always get the value of a field and ignore the grouping in the Cross Tab? I am using this formula...

Part and Inventory Search

Back
Top