Within our LOS, we have User Defined Fields (UDF) to be completed. They are different types, (ie, Character, Date, Currency, Percentage). I have written a report that only wants to look at a couple of the Character type fields. I've written an "if-then-else" function looking at the sequence # & if there is a value. (FORMULA: if {sequence# = 16} and startswith "y" then 1 else 0) The problem is if more than one character type UDF is completed in the LOS, I get a detail line for each field completed. I want one line with all the completed UDF's indicated (I have a column for each UDF). I have successfully written a Cross-tab report for the UDF's, but I have numerous other fields for each customer that need to display. Is there any way to combine my initial report & the crosstab report so I have one line for each customer?
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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Duplicate details due to User Defined Fields in LOS
- Thread starter kooley
- Start date
Similar threads
- Locked
- Question
- Locked
- Question