Recent content by hlb6

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

(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...

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

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.

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

The Excel Parameter is for exporting to excel

Remember that Group #3 is the Department grouping

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...

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...

Yes I understand - how do I fix it??????

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...

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...

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.

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!

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