Skip to Content
avatar image
Former Member

Select all the columns of a table in crystal report for eclipse

Dear all,

I am using crystal report for eclipse and I came up with a problem that messes up my whole crystal report.

I am trying to create a crystal report through eclipse but if I use an sql command to take the columns I want it messes up the fieldName and instead of the table_name.Column_name it imports the command.Column_name. So I though it would be a good idea to select manually all the tables that I want and then import them to my CR.

The problem is that there is not a method where I can take all the columns from the different tables. Is there a solution for this?

Thank you.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Sep 18, 2017 at 04:27 PM

    Hi Mike,

    Correct, you cannot convert a report that uses direct Table connections to a SQL Command and same to go the other way.

    Due to the complexity of how this would work in the backend it was simply too much work for the Developers to do this. And not many people use it or requested the ability so it did not justify the cost to do so.

    Only option is to manually re-create the report by copying/pasting in the various objects.

    Don

    Add comment
    10|10000 characters needed characters exceeded