Hi

I have a "Bookings" report that displays orders booked in the month & year that the user provides. This report is sub summarized by Purchaser ID, Client ID, Sales Rep Last Name. Purchaser ID & Client ID are stored in Order Lines table. Sales Rep Last Name is stored in Sales Rep table. When the Report is displayed on screen, Purchaser Name is displayed for the Purchaser ID (Purchaser Name is from Purchaser table). Order Lines table and Purchaser table are related by Purchaser ID.

Problem is when I try to export this report in excel, If I add Purchaser Name to export, then "0" is exported. If I export Purchaser ID, it works fine. I want to export the Purchaser Name.

I don't understand what I am doing wrong. All other data gets exported fine.

Thanx

I think that you have that calculation result formatted as a numerical value instead of text "Calculation result is a _____". Change it to text and see how that does.