QlikView issue extracting string fields from SQL Server 2005
I have a weird issue.
I have a QV file that connects to SQL Server 2005 and loads (Select statament) a view created that joins three tables to create a mini datacloud.
This application works fine when I reload/refresh it using my laptop but when using another machine I get a lot of grey fields (blanks) which normally indicates there is no data available in the SQL table. However, this is not true because most fields have data specially after comparing it with the one I run on my machine.
I dont know where the problem is? The machine is down as adminstrator and has similar privilages and permissions to the one I use. We even upgraded it from XP to Windows 7.