natasha Posted September 26, 2006 Posted September 26, 2006 Hi, Good Morning I have created a report that shows all the journal entries for a particular account. The problem with this report is that for each journal entry it shows the ticket # each time as well as the other detail information such as the customer name, address, etc. Does anyone know (if possible) how i can display one ticket#, cust name, address, etc for an account that has say 10 different journals. Any help or suggestions you can give would be most appreciated. Thank you again for all your help. tasha Quote
natasha Posted October 3, 2006 Author Posted October 3, 2006 I found this on an earlier post, and it works out great for me. thanks! Add a group on whatever calllog field you would like to group by (like CallLog.CallID). On the right where it says Group Header #1, right click and select Insert Section Below (or Insert if you are using the Section Expert) to add another row that is tied to that group. Add the other calllog fields you want in that section (you can add additional sections if you want for additional info). Add the journal information in the detail section. _________________ Clint Heat 8.03\SQL2K, HAT 8.03, HSS 8.0 Last edited by ShortReed on Thu Feb 02, 2006 6:16 pm; edited 1 time in total Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.