I am running Crystal 9.2.0.448 against an 2003 Access DB and am pulling fields from two tables. The problem is that one of the fields (contacts.bounced?), which was removed from the report and also from the DB is now appearing as a parameter. When I open the Field Explorer to see if the field is being used (as demonstrated by the handy green check mark) I’m assured that it’s not being used in the report. Yet when I try to run the report, I get a parameter value prompt for Contacts.[Bounced?] and if I leave it null it takes longer than my lifespan to run, rendering the report useless.
When I put in a dummy field Contacts.Bounced? in the Access DB (and regardless of the data type) the report works fine and I'm able to see the SQL:
SELECT `Contacts`.`cst_member_flag`, `Contacts`.`Record`, `TOTAL_FINANCIAL`.`MinOfdate`, `TOTAL_FINANCIAL`.`MinOfInv_Trx_Date`, `TOTAL_FINANCIAL`.`MaxOfdate`, `TOTAL_FINANCIAL`.`MaxOfInv_Trx_Date`, `Contacts`.`Last Member Type`, `Contacts`.`Join Date`, `Contacts`.`cst_add_date`, `Contacts`.`Expire`, `Contacts`.`crt_certification_date`, `Contacts`.`no email_flag`, `Contacts`.`cst_eml_address_dn`, `Contacts`.`receive marketing emails`, `Contacts`.`cst_src_code`, `Contacts`.`MaxTerminate`
FROM `Contacts` `Contacts` LEFT OUTER JOIN `TOTAL_FINANCIAL` `TOTAL_FINANCIAL` ON `Contacts`.`Record`=`TOTAL_FINANCIAL`.`Record`
which clearly isn't pulling the Contacts.bounced? field.
So why is the report insisting on this field? Obviously I can just add the dummy field to the Contacts table and call it quits, but this seems messy and leaves me ignorant. So if anyone has any ideas, I’d greatly appreciate your help.
Thanks!
When I put in a dummy field Contacts.Bounced? in the Access DB (and regardless of the data type) the report works fine and I'm able to see the SQL:
SELECT `Contacts`.`cst_member_flag`, `Contacts`.`Record`, `TOTAL_FINANCIAL`.`MinOfdate`, `TOTAL_FINANCIAL`.`MinOfInv_Trx_Date`, `TOTAL_FINANCIAL`.`MaxOfdate`, `TOTAL_FINANCIAL`.`MaxOfInv_Trx_Date`, `Contacts`.`Last Member Type`, `Contacts`.`Join Date`, `Contacts`.`cst_add_date`, `Contacts`.`Expire`, `Contacts`.`crt_certification_date`, `Contacts`.`no email_flag`, `Contacts`.`cst_eml_address_dn`, `Contacts`.`receive marketing emails`, `Contacts`.`cst_src_code`, `Contacts`.`MaxTerminate`
FROM `Contacts` `Contacts` LEFT OUTER JOIN `TOTAL_FINANCIAL` `TOTAL_FINANCIAL` ON `Contacts`.`Record`=`TOTAL_FINANCIAL`.`Record`
which clearly isn't pulling the Contacts.bounced? field.
So why is the report insisting on this field? Obviously I can just add the dummy field to the Contacts table and call it quits, but this seems messy and leaves me ignorant. So if anyone has any ideas, I’d greatly appreciate your help.
Thanks!