Hello all, I am adding one Lookup field value in my table in the report builder but it only show me Id of lookup. so, how to show the lookup field value in table?? Kartik Associative Software engineer, Synoverge Tech Pvt. Ltd. Ahmedabad

Hello, You have to join the table containing the value.Olaf Helper * cogito ergo sum * errare humanum est * quote erat demonstrandum * Wenn ich denke, ist das ein Fehler und das beweise ich tglich Blog Xing

Hi Olaf Thanks for your quick reply, Can you please explain me in detail as i am new to report builder. Kartik Associative Software engineer, Synoverge Tech Pvt. Ltd. Ahmedabad

This is nothing Report Builder dedicated, it's the kind of you query. You have to join the other table with the account name, sample: SELECT Y.* ,A.* FROM yourTable AS Y INNER JOUNT Accounts AS A ON Y.AccountID = A.AccountID Olaf Helper * cogito ergo sum * errare humanum est * quote erat demonstrandum * Wenn ich denke, ist das ein Fehler und das beweise ich tglich Blog Xing