Crystal in E10.1

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.

Any help would be much appreciated!

This happens sometimes even on E9. You need to go into the crystal dataset
area and set the database links there.

Brad

In the crystal database expert \ Links, I verified the links from the table is set. Do I need to “re-link” or check anywhere else?

You might check the links to see if they are inner or outer.

The links usually do it for me.

Brad

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.