Why does Crystal_Reports show me fields in a table that QlikView doesn't show?

[datanibbler]

Hi,

even though QlikView can use SQL, I rarely go beyond an >> SQL SELECT * << to fetch data from a database_table and do all the rest in a preceding LOAD statement.

A while ago I got a licence - and the task - to also manage/ design/ whatever reports in Crystal_reports, which, however less practical than QlikView, is our global standard BI tool.

Just now I had the phenomenon, like I had it before, that in Crystal_reports, I can add a certain table from the database and just search through the fields in that table - and I see a certain field that I need. <=> When I load the same table with a >>SQL SELECT *<< in QlikView, I don't see that particular field.

Is anyone here who knows both tools and can explain what is the underlying difference? The table_name is exactly the same.

Thanks a lot!

Best regards,

DataNibbler

[marcus_sommer]

Hi DataNibbler,

a reason could be differences with the user-rights or this aren't real fields like here: Laden von Daten aus Navision.

- Marcus

[datanibbler]

Hi Marcus,

unfortunately I don't know too much about that - but I'll just have a look in the database, I can log on to that, and I'll ask IT what those fields are.

Since both tools use SQL to query that table, there must be a difference to that field ...

[marcus_sommer]

Hi DataNibbler,

it meant that those fields could be calculations and I think other databases as MS have similar features:

FlowFields Overview

- Marcus