Skip to Content
author's profile photo Naquessa Boddie
0
Naquessa Boddie

Views not showing in Crystal Report

Posted on Apr 08 at 04:14 AM 48 Views Last edit Apr 08 at 04:19 AM 2 rev.

I have a crystal report that is connected to a IBM DB2 database that I am converting to a Microsoft database. When I do -> Database -> Set Datasource Location -> connect to the database and click the update button. When I try to map the fields only one column show and it should be two.

( I ran the query view in Mirosoft SQL Server Management Studio)

Here is the view data:

Here is what it shows in Crystal Report:

Can anyone help with why all columns are not showing in this view in crystal report?

viewcapture.png (153.8 kB)
convertmap.png (32.6 kB)
Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • author's profile photo Dell Stinnett-Christy
    Dell Stinnett-Christy
    Posted on Apr 08 at 01:57 PM
    0

    I suspect that the data types of the fields don't match up well. What type is the field in DB2 and what type is it in SQL Server?

    -Dell

    Add a comment
    10|10000 characters needed characters exceeded

    • Dell Stinnett-Christy
      yesterday

      Yeah, Crystal won't let you use a memo field for a group. However, you could do one of two things to get this to work:

      1. Modify the view to something like this:

      Select
  [JobNumber],
  [UserText],
  Left([UserText], 50) as UserTextGroup
From [dbo].[AJ_D40]
Order by UserTextGroup

      This will give you a field that isn't a memo that you can group on. You don't have to use 50 characters - it could be more or less based on your needs. It just has to be less than (max). This method would process more efficiently in Crystal than the next one because it pushes the processing to the database instead of doing it in memory in Crystal.

      2. Create a formula in the report something like this:

      Left({ViewName.UserText}, 50)

      Then group on this formula. Again, you don't have to use 50 characters. This formula would then be processed in memory in Crystal to configure your groups.

      -Dell

    Comment on This Answer

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.