I found out that when I rebuilt the join that my criteria in the Active Link got changed since the Id fields all changed. Once I fixed that the report started working again.
________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Pargeter, Christie Sent: Friday, June 01, 2007 8:54 AM To: [email protected] Subject: Re: Crystal Report Not Showing Data ** That is checked. Still get the error message. It seems to be only this new join that is the problem. All of my other reports work. ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Gordon M. Frank Sent: Friday, June 01, 2007 5:46 AM To: [email protected] Subject: Re: Crystal Report Not Showing Data ** This is a symptom of not having the Tools, Options, Advanced, ODBC Use Underscores checkbox unchecked. Check it an they will probably work. The Crystal interface is ODBC but it is like a Web Page which cannot have blanks. Therefore the checkbox ensures that all blanks are replaced with underscores. Gordon Frank EDS From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Pargeter, Christie Sent: Thursday, May 31, 2007 5:26 PM To: [email protected] Subject: Crystal Report Not Showing Data ** Hi All - I had to delete a join that I had some Crystal reports built against this join. I then recreated the join (with the exact same name) and all the reports are now broken. I have been trying to rebuild these reports from scratch but for some reason the reports are not showing any data when I run them in the user tool. Note there is no search criteria on the report. I then when to the actual join and brought up one record then tried to bring up the Crystal report and it is still not showing any data. Right now the report has 2 fields on it and some static text. The static text is showing but not the fields. Any ideas? The report runs just fine when I use Crystal Developer. ARS 6.3 Crystal 9 Win 2000 ____________________________________________ Christie Pargeter Weyerhaeuser Documentation & Training [EMAIL PROTECTED] Portland, OR tel: 503-553-8512 fax: 503-553-8479 __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
