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: *

  • Users: hlb6
  • Order by date
  1. hlb6

    Select statement confusion

    Thank you Pete! I find you help to be very useful - you explain things so that one can understand the question and result. [bigsmile]
  2. hlb6

    Select statement confusion

    (Select {?p_Period} [5 to 6] case "12" : ToText((ToNumber(Left({?p_Period},4))),0,"","") default : ToText((ToNumber(Left({?p_Period},4))-1),0,"","")) & (select {?p_Period} [5 to 6] case "12" : "01" case "10", "11" : ToText((ToNumber(Right({?p_Period},2))+1),0) default...
  3. hlb6

    Crystal Export pramater formatting

    [ponder]I answered my own question DUH........ LOL
  4. hlb6

    Crystal Export pramater formatting

    Good afternoon all! How do I export to excel or should I say have the report format in excel formatting using a pramarter that states if Excel then true else false. if true then I get the excel formating otherwise I get the report formatting.
  5. hlb6

    String erorr in sub-report group footer

    If the user wants to export - just the data it keeps the excel formatting
  6. hlb6

    String erorr in sub-report group footer

    The Excel Parameter is for exporting to excel
  7. hlb6

    String erorr in sub-report group footer

    Remember that Group #3 is the Department grouping
  8. hlb6

    String erorr in sub-report group footer

    Okay- from what I am told it is a formatting thing - there are two groups in group 4 that are grouped on user-id: {?Excel) is Boolean 4a: which states originaly that if the user selects true on {?Excel}then it will show everything headers, column names, etc selection expert suppress...
  9. hlb6

    String erorr in sub-report group footer

    This is what I am trying to achieve: If the user selects “Yes” on the Department Parameter, then the Group header is not suppressed , it shows the Department and each user-id (they are not numeric: if they were that would make this a lot easier!) is listed under that department with their...
  10. hlb6

    String erorr in sub-report group footer

    Yes I understand - how do I fix it??????
  11. hlb6

    String erorr in sub-report group footer

    I keep getting this "A string is required here", error (on the last if statement, ({@count2})) on this formula (I hope I am giving you enough information): If {?p_Department} = "Yes" and {?p_Excel} = "Yes" then {?p_Excel} Else (If ({?p_Technician}={Command.usr_id})Then...
  12. hlb6

    Help with a Boolan error when fields are a string

    Is it possible that I am placing the formula in the wrong place; ie.: Group#4 Name:Command.usr_id - I am placing it in the footer of this group. I just saw that when using the Selection Expert and placing the formula there (the Suppress formula editor) it has to have a Boolen Result. If this is...
  13. hlb6

    Help with a Boolan error when fields are a string

    Pete- I am only modifing someone esles work - yes the {?p_Excel} is a Boolean. Now I understand the why - how do if fix this - do I make the {?p_Excel} a string? I have tried to change the second part (the IF) to boolean but then I get a string error.
  14. hlb6

    Yes / No Parameter

    This is what I put in the Selection Expert for the group footer if{?p_Department} = "No" then True else {?p_Excel} I also checked the suppress Thanks to direction to go!
  15. hlb6

    Sum a formula field

    Works like a charm!! Thanks Pete - your an angel!!!!![bigsmile]
  16. hlb6

    Yes / No Parameter

    Solved - Thanks
  17. hlb6

    Help with a Boolan error when fields are a string

    Ok - I am getting frustrated with this. In my group footer ({Command.usr_id}) I have to group together the names and sum each of there columns if my parameter = No and they have more thatn one listing. ie.: Doe 0 12 15 31 Smith 5 6 27 4 Mouse 0 0...
  18. hlb6

    Yes / No Parameter

    Oh, yeah i'm using Crystal 9
  19. hlb6

    Yes / No Parameter

    Okay - Did as directed - when I say yes in the parmaeter box the field writes yes - I need it to show the department id
  20. hlb6

    Yes / No Parameter

    I have to add a Yes / No parameter to my report. Yes = user wants to see the department and no = they don't. Not sure how to go about doing this - this is a new realm for me. I know it is an If statement - how do I get it into the parameter vales parameter dialog box? Here is my Crystal /...

Part and Inventory Search

Back
Top