Databases
StackOverflow2013
Postsdbo
POCrystal Reports - Some fields not showing in Data Context
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POCrystal Reports - Some fields not showing in Data Context
    primarykey
    data
    text
    <p><em><strong>EDIT: I have found out that all of the fields not showing up in the field explorer are of a data type that is not varchar. The three that are not showing up are of type "money", "numeric", and "datetime2". I still don't know how to fix it, but I think this should probably help answer my question!</strong></em></p> <p>I am working on a project with a database (SQL Server) I did not create so what I can do with it is limited. I made a view and selected the fields I needed, however when I use the Database Expert and select the view, only 3 of the 6 fields actually show up, and unfortunately, it's the 3 fields I need the least. I have tried adding a few different tables through the Database Expert and every single one I tested ended up with missing fields. I will say this database is pretty full of nulls and is badly designed, but since I created a view for this, I specifically excluded any row that had nulls in it just to see if that was the problem. It did not help at all unfortunately.</p> <p>I have been googling this for about an hour now and I have found some people with similar issues but not quite the same, and so far none of the fixes have really helped at all. It seems like it should be something relatively simple, but I am very new to Crystal Reports.</p> <p>Any help is much appreciated, thanks!</p> <p>EDIT2: I have deleted all of the images as I don't want to get in any trouble for posting stuff from this project. I don't think there was anything in them important but safety first! Sorry if this causes any inconvenience to future readers :)</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USzack
    1. USzack
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POCrystal Reports - Some fields not showing in Data Context
      1. This table or related slice is empty.
      1. VTApproveEditSuggestion
    2. VO
      singulars
      1. POCrystal Reports - Some fields not showing in Data Context
      1. This table or related slice is empty.
      1. VTApproveEditSuggestion
    3. VO
      singulars
      1. POCrystal Reports - Some fields not showing in Data Context
      1. This table or related slice is empty.
      1. VTUpMod
    1. COHave you verified that the data exists and is available as you would expect from the view/tables outside of CR? Also, the query that CR uses is available from 'Database'->'Show SQL Query' which could help you determine where you're going wrong.
      singulars
      1. POCrystal Reports - Some fields not showing in Data Context
      1. USRyan
    2. CO@Ryan I have looked at the actual data in the view directly if that is what you mean. The table that my view is based upon has a lot of extra data and a lot of the fields are nulls. I made a view and cleaned it up by excluding null data as that was useless to me in this case anyway. One of the fields, for instance, holds the date a check was deposited. This field does not show up in CR, but definitely has data in it.
      singulars
      1. POCrystal Reports - Some fields not showing in Data Context
      1. USzack
    3. CO@Ryan I should also mention that when I go to the field context and right click on anything (the database, the selected view, or any of the fields inside the view), "Show SQL Query" is grayed out. Perhaps that is part of the issue?
      singulars
      1. POCrystal Reports - Some fields not showing in Data Context
      1. USzack
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload