CR is displaying value ID instead of Value

[Jennacat]

Got a little problem. I'm experimenting with Crystal because Access is splitting my data. Here is the set-up:

Report Header with company logo
Detail Section with 9 subreports (each has their own 'detail section').
Report Footer

The problem is with some of the subreports. When I insert the Values field, instead of displaying Biodegradability, 5 Days; Biodegradability 13 Days; Biodegradability 20 Days; etc, it displays 7.00; 6.00; 5.00; etc. I tracked this down and these are the ID values that correspond to the values:

ID Value
7.00 Biodegradability 5 Days
6.00 Biodegradability 13 Days

The ID field is the Key field. This table is linked to another so it needs the key.

I have two questions: Why is it using the ID instead of Values and how do I fix this?

Thanks for your help!

 

[Kempes]

This is because you must have selected id rather than value to show within the detail of your report.

To correct this, open field explorer (view\field explorer).
expand database fields.
expand your table
drag value into the detail section.

The value field should now show.

 

[Jennacat]

No, I have Values in there. ID isn't on the report. It's not even grouped by it. Any other ideas?

 

[boblarson]

Perhaps your Access table is using Lookups at table level (http://www.mvps.org/access/lookupfields.htm ) which is bad. Check it out to see if the field is actually using lookups at table level.

This is how to remove them if they are:

 

[Jennacat]

They were all set to Text Box, except one. And that one, when I switched it from combo to Text Box, did the same thing to the table! Instead of P >0; 0<1; 1<2, etc, it says 3; 2; 1!!!! The same thing that CR was doing! Here is pic of what the two of them are doing. CR was doing the ID thing before I changed the Chem Fate Results to Text Box.

 

[boblarson]

Yes, that's what it SHOULD do. Now what you do is create a QUERY to pull the values together from the ID, or in Crystal, you display certain fields from one table and then the descripton from the other table and you should get what you need.

 

[Jennacat]

Well, I got one to work, but the other won't. I'm not sure how I did it though. I kept them as Text Boxes and it helped with the one subreport, but not the other. I'll keep at it. Thanks for your help!

 

[boblarson]

Which version of Crystal are you using? If you could share your Access db I could use version 8.5 (the only version I have personally) to do up some screenshots.

 

[Jennacat]

I'm using a trial version of CR 2008. I can't share the database because of company confidentiality. Sorry! I was monkeying around with the report again and I found that when I preview my problem subreport it displays everything fine, but when I preview the main report, that subreport won't display anything in it's detail section. Why is that? It's the only subreport that is giving me problems now.