We have some users who have access to LBI but not to Portal, so we have several Portal reports that we read into Crystal and output in LBI, usually in Excel format. One report that I am trying to do this with is the Payment Voucher Interface Error Report (YP520). This report has two logical sections to is, depending on the types of errors encountered. The report populates 0, 1, or both sections, depending on the errors encountered, if any.
My problem is that I need to be able to report this in Crystal. If one or both sections of the report are empty (just the message <<< NO ERRORS >>>) then the report does not contain the fields from that section and my Crystal report burps and dies.
What would be a proper method for me to use to allow my Crystal report to recognize that there is no data and to allow it to report both sections of this report?
Thanks David, that is where I am heading with it. However, the column from the report that indicates that there is no data does not exist if there is data. I'm trying to figure out how I can determine whether to produce the subreport, but I can't figure a way to determine if any given column exists or not.