This content has been marked as final. Show 6 replies
Add a filter on contact_typ='IA' that should avoid other type from report.
case when contact_typ='IA' then Last_Name else 'N' End
Filter it where <>N
let me know for issues, if helps mark
Thank you!!..But I am looking to filter in backend, rather than in filtering in front end, because when business users pull the report they get confused. Any help is highly appreciated
In stead of the back end, I would suggest to use logical table source properties content tab->Where clause condition to1 person found this helpful
If helps pls mark
For the other reports I need to use other contact types, so I cannot use contact_typ='IA' in content tab. Thanks!!!!
Oh is it! then what is backend? you were telling about it in your last message?
Try out as per my 1st suggestion.
Hi SARU,1 person found this helpful
As per my understanding and the forum - you need display last name for the contact typ -= 'IA'
And, either you dont want to filter them in logical table source or write a case statement which shows nulls or 'N' and filter by 'N'.
And, you mentioned that you need it from back end.
So, Why dont you create another column in physical table (Database).
Say - I have table employee id, first name, last name, cont type
Now modify it by creating another extra column - display name
So, your table changes to employee id, first name, last name , cont type, display name
Now, based on your condition - update your display name column.
If, your unable to do that in database. Create a new physical table in physical layer - using select statement.
And, generate the table Emp Display -- which holds Employee id, Display name. And, display name gets generated by case statement.
this will definitely resolve your issue.