Has anyone run into database fields in crystal not displaying when printing the report, but data shows up for those database fields in the XML?
In particular, I’m working on a modified Job Traveler Report in Crystal 11 and the table that is giving me problems is the OrderHed. Any fields I put in the report doesn’t display, but when I look at the XML for the generated report, I see the data that should be displaying.
No error messages when printing.
I’ve recently migrated from E9 to E10.1
As I would like to have all my reports converted to SSRS, I need some reports to still function with crystal for the time being.
Just a FYI If you have been using SAP CR 2013 then any field was set as a varchar(256) type will now be seen as a memo type and will be removed from the report. The older versions of Crystal Reports, with some SQL drivers, see the fields as a limited varchar field.
Thanks for the information Mark, I’ll make a note.
Brad, I’ve tried deleting the links with the problem table and re-adding and no luck. If I switch the outer join with an inner join, no data appears when I print the report. I’ve also tried clearing each link I have with all tables and re-adding everything back, but still get the same results.